search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
152 stars 21 forks source link

Yahoo getHistoric does not work #8

Closed gikari closed 3 years ago

gikari commented 4 years ago

I tried to put this into the cell to get the price of the stock on the specified day:

=GETHISTORIC("AAPL", "LAST_PRICE", "2020-10-13", "YAHOO")

And this returned the result:

Data doesn't exist - 21

But on https://finance.yahoo.com/quote/AAPL there is some data for the stock price on the specified day.

GETREALTIME function, however, works.

cmallwitz commented 4 years ago

LAST_PRICE is not supported for historic data. Supported fields for historic data are:

Field Code
OPEN 6
LOW 14
HIGH 16
VOLUME 35
CLOSE 90
ADJ_CLOSE 91

Have a look at the examples in examples.ods, tab "Historic Examples". Thanks for giving the extension a try!