[Solved] Any Alternatives to GETQUOTE?

[husky55]

NOTE: This is where the difference comes in - when using the OO version your input should look like "=GETYAHOO('XOM';21)", while when using the LO version it should look like "=GETYAHOO('XOM',21)". Note the semicolon vs. comma.

Also, the upcoming release will support both LO and OO out of the box, consolidating the two versions I linked above; however the semicolon vs comma difference will remain..

Exactly right!!! In addition, in OO if you use paste link then you need to use the function VALUE in OO 4.1.1 for any calculation to work.

[Villeroy]

NOTE: This is where the difference comes in - when using the OO version your input should look like "=GETYAHOO('XOM';21)", while when using the LO version it should look like "=GETYAHOO('XOM',21)". Note the semicolon vs. comma.

Also, the upcoming release will support both LO and OO out of the box, consolidating the two versions I linked above; however the semicolon vs comma difference will remain..

Exactly right!!! In addition, in OO if you use paste link then you need to use the function VALUE in OO 4.1.1 for any calculation to work.

WRONG!
Of course you need to use the list separator which is valid for your individual office setup. My LibreOffice requires semicolons as well because comma is my decimal separator. The changable list separators is one of the most confusing "improvements" in LibreOffice.

And no, the VALUE problem should have been resolved with the latest versions of GETQUOTE. My LIbre/OpenOffice can not convert strings to values by means of VALUE when the assumed decimal separator is point which is how this long topic started. The GETQUOTE functions should return numeric cell values now.

[howdydooit]

Exactly right!!! In addition, in OO if you use paste link then you need to use the function VALUE in OO 4.1.1 for any calculation to work.

It took me a while to bumble my way through this, but THANKYOU!

[husky55]

It took me a while too!!!!LOL

[howdydooit]

So, to save people with my skill level a ton of time, the syntax is:
=VALUE(GETYAHOO(A3;21)) (This is for Open Office. Others are saying to replace the semi colon with a comma in Libre Office)

In the example below:
"Equity" is the heading in A2, "Share Price" is the heading in B2
"AAPL" is whatever ticker you want in A3, and "126.60" in B4 is the value returned by typing the above formula into B4.

Equity Share Price
AAPL 126.60

You can format B4 to your liking (add a $ for instance, or change the decimal setting, etc.)
In my case, I had a column of symbols in A and a column of share price values in B. Other formulas in the spreadsheet that refer to Values in those cells work fine.

[Villeroy]

So, to save people with my skill level a ton of time, the syntax is:
=VALUE(GETYAHOO(A3;21)) (This is for Open Office. Others are saying to replace the semi colon with a comma in Libre Office)

No, with the latest version it is simply =GETYAHOO(A3 ; 21) or =GETYAHOO(A3 , 21) because the latest version returns numbers. Old versions returned text.

[howdydooit]

Well, for people like me, who are on Open Office 4.1.1 (Windows 7) where your method clearly doesn't work, try my version. Villeroy - read my post at the end of page 2.

[Villeroy]

Well, then use VALUE if that works for you.

If your document needs to be compatible with comma decimals:

Code: Select all

=VALUE(SUBSTITUTE(GETYAHOO(A1;B1);".";MID(PI();2;1))

That one converts point decimals into values regardless of the current locale setup.

[husky55]

So, to save people with my skill level a ton of time, the syntax is:
=VALUE(GETYAHOO(A3;21)) (This is for Open Office. Others are saying to replace the semi colon with a comma in Libre Office)

No, with the latest version it is simply =GETYAHOO(A3 ; 21) or =GETYAHOO(A3 , 21) because the latest version returns numbers. Old versions returned text.

Trust me I have spent lots of time before finding this forum. There are 2 versions of SMF, for LO and OO. I used both LO and OO The latest version SMF .70 does not return a number that I can copy and paste and perform operation on it. Try it and you will see. OO 4.11 version. It does return a number but that number does not work when you copy and paste and perform operation on it. SMF .7 works fine in LO 4.4.3. In OO, It returns an error when copy and paste and perform any operation Try it for yourself before posting.

[Villeroy]

I am not the maintainer of that extension. 4 months ago I added a tiny little bit of code to make it return numbers. If the extension returns text again, I won't do anthing about it.

[husky55]

Hey Villeroy, we do not always have to agree on everything but I am grateful that you shared your knowledge on this forum. Hopefully the next SMF version will be compatible with both LO and OO and most importantly not break anything.

I understood your use of the comma as a separator in your application and therefore your need to do a conversion.

[santer]

Sooooo... I don't understand what you mean by "install the extension to LIBREOFFICE". I have to install LIBREOFFICE instead of Open Office? And then install an extension (or mod?) that allows me to use the "getquote" command? And at that point, I can use a comma to separate "A1" from "29", instead of a semicolon?

Thanks for your help.

The GETQUOTE extension is no longer developed or supported by it's creator; it has been succeeded by the SMF extension. SMF will function in OpenOffice with this version: https://drive.google.com/file/d/0B8TbA- ... view?pli=1, or in LibreOffice with this version: https://github.com/madsailor/SMF-Extension/releases.

Please read the description here to get an idea of the functionality and how to use the extension: https://github.com/madsailor/SMF-Extension.

NOTE: This is where the difference comes in - when using the OO version your input should look like "=GETYAHOO('XOM';21)", while when using the LO version it should look like "=GETYAHOO('XOM',21)". Note the semicolon vs. comma.

Also, the upcoming release will support both LO and OO out of the box, consolidating the two versions I linked above; however the semicolon vs comma difference will remain..

madsailor
I downloaded your fix for SMF and still can't get it to work on OO. Works find on LO. What gives?

[Villeroy]

madsailor
I downloaded your fix for SMF and still can't get it to work on OO. Works find on LO. What gives?

Install LO

[santer]

madsailor
I downloaded your fix for SMF and still can't get it to work on OO. Works find on LO. What gives?

Install LO

Villeroy
I have installed LO and SMF works fine. But with OO I get errors.

[Villeroy]

It is an extension for LibreOffice which is obviously no longer maintained for OpenOffice.

[santer]

It is an extension for LibreOffice which is obviously no longer maintained for OpenOffice.

Do you know if there are any plans to maintain it? Also, for LO, are there any plans to accommodate array processing with SMF?

[carl.c.wheeler]

I'm having a hard time finding the right input to retrieve a simple index price (DJI) in LibreOffice Calc.

What I have tried are:

=VALUE(GETYAHOO("DJI",21))
=VALUE(GETYAHOO("^DJI",21))

But these don't work. The above format works for stock prices, just not the indexes.

Thanks.

[Villeroy]

This will break every time when Yahoo makes changes to its website. This may be intended by Yahoo.

[santer]

This will break every time when Yahoo makes changes to its website. This may be intended by Yahoo.

Any plans to fix this so it works again?

[immo2014]

for all germans with libreoffice 5 try this for e.g pbb.de

=WERT(WECHSELN(GETYAHOO("pbb.de";21);".";","))