search

cmallwitz / Financials-Extension

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

Nasdaq.com - div ex-date and annual dividend #89

Open DrakeBliss opened 1 year ago

DrakeBliss commented 1 year ago

I have only a few ETF type stocks that Yahoo of FT do not have the data on.

I wanting to have Annual Dividends and ex-Dividend dates for my spreadsheet. Nasdaq site does have the data. For example https://www.nasdaq.com/market-activity/etf/tsly

Yahoo https://finance.yahoo.com/quote/TSLY does not have the data and I get a #N/A

Thanks for your help and I love the extension

cmallwitz commented 1 year ago

The effort to get additional web sites supported pretty much depends on how easy it is to extract the data from web pages. So if a web site only supports a sub set of assets (like NASDAQ only supporting NASDAQ quoted stocks), the effort is too much from my side and I would rather get another web site added covering a broad range of assets. There is always the chance someone contributes support for anther website :-)

DrakeBliss commented 1 year ago

The Nasdaq.com does supports other exchanges, see below examples

NYSE - https://www.nasdaq.com/market-activity/stocks/t EFT - https://www.nasdaq.com/market-activity/stocks/t OTC - https://www.nasdaq.com/market-activity/stocks/vlkaf BTC - https://www.nasdaq.com/market-activity/cryptocurrency/btc

chr0mag commented 9 months ago

Dividend data is available from Yahoo. The "Historical Data" table can be filtered for a specific time period (eg. 1 year / TTM) and restricted to only dividends.

https://finance.yahoo.com/quote/TSLY/history?period1=1676770871&period2=1708306871&interval=capitalGain%7Cdiv%7Csplit&filter=div&frequency=1d&includeAdjustedClose=true

I've been using a hacky javascript in Google Spreadsheets with a URL similar to: https://query1.finance.yahoo.com/v7/finance/download/VTI?period1=1509723651&period2=1512315651&interval=1d&events=div&crumb=.xxxxxxxxx ....to pull historical dividend data for years, but am trying to get away from Google.

I use this historical dividend data to calculate total returns, but also just to get the current dividend (DIV/71) which is often not available from the GETREALTIME() data for ETFs.

So I don't think supporting a new website / data source (in this case Nasdaq) is needed.

I haven't looked at the Python code yet, but a new GETHISTORICRANGE(ticker, code, startdate, enddate, source) function that returned a list of "ex-date, dividend" pairs for the range in question would probably be sufficient and would allow calculating TTM dividend payouts among other things.