search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
137 stars 17 forks source link

Two shares not pulling down data #24

Closed R7914T closed 3 years ago

R7914T commented 3 years ago

I am having problems with 2 shares and one ETF that will not bring down the data into a Libreoffice SS. Can you please look at why this is happening:

  1. BATM andvanced Comms: LSE BVC My call entered as =GETREALTIME($B12,"prev_close","ft") Note: B12=BVC

(error message #N/A)

  1. NORTHERN DYNASTY MINERALS LTD COM Per Web address: quote on NYSE with code NAK. I checked with NYSE web site. My call entered as =GETREALTIME("NYQ:NDM:","prev_close","ft") Error message =#N/A

ETF I have an etf from Invesco under the epic of SSLV. Is there a way of pulling down its price? For more detail about the ways of describing the ETF see https://etf.invesco.com/gb/private/en/product/invesco-physical-silver-etc/trading-information The etf is quoted on the LSE in $ Call entered as =GETREALTIME($B26,"prev_close","ft") B26 = SSLV Error = #N/A

Also How do I get the exchange rate for dollars to pounds in the SS automatically?

cmallwitz commented 3 years ago

Could you check your symbols are correct (as referenced from other cells)?

(All on FT web site)

R7914T commented 3 years ago

Thank you for your reply. In all of the following I change B12 to your suggestions GETREALTIME($B12,"prev_close","ft")

Could you please try it in a spreadsheet to see if you get a valid last price for no 2 and 3 below?

  1. b12=BVC:LSE It now works thank you.

  2. B12 as NDM:TOR. It does not pull the last price.

  3. B12 as SSLV:LSE does not pull the last price. SSLV:LSE:USD also does not work in my spreadsheet

What is the url for the FT data that you checked?

R7914T commented 3 years ago

I think I have found the cause in that if I substitute the middle part of the expression with 21 they work. Keeping it at "prev_close" does not appear to work in the complex location codes that went wrong for me. I hope you will be able to now easily find the underlying cause.

cmallwitz commented 3 years ago

Maybe I should look into using lower case names for these data points

cmallwitz commented 3 years ago

OK, nothing wrong with using lower case names to specify the code for the data point but

LAST_PRICE works for me with BVC:LSE NDM:TOR SSLV:LSE:USD PREV_CLOSE works for me with BVC:LSE NDM:TOR but not with SSLV:LSE:USD

Looking at "https://markets.ft.com/data/etfs/tearsheet/summary?s=SSLV:LSE:USD" it seems open/close/prev_close/etc is missing for ETFs (same problem for other ETFs I checked).

Please note: when trying the above I happened to use single instead of double quotes ('last_price' vs "last_price") - Open Calc doesn't seem to handle single quotes (this is not an issue with the extension itself which is not even called) - so please make sure you use double quotes.

Otherwise I can't see anything wrong...