End Of Day Data (EODDATA) not Yahoo anymore

[Hallgente]

1. Quite some time ago, with the aid of this Forum, I was helped with some VBA code to download end of day stock prices from Yahoo. But since Yahoo was acquired by Verizon, they no longer allow access. So I found another provider called EODDATA and I have subscribed to their Platinum services.... but perhaps prematurely as I can't make head nor tail of how I can download the stock history I am after.

2. The Excel workbook I built has about 40 sheets in it. Of these, 30 sheets are each dedicated to a ticker/symbol, for example AAPL (Apple). Each sheet used to get populated with about 1,000 days of price history if available. The code this Forum helped me put together for the Yahoo pull was as follows 'YahooDownloadCode.txt'

1drv.ms/f/s!AhnMo5XqPIsMzHy48TJImm9-HrVo


3. The EODDATA download requires a token that lasts 24Hrs. You can see the page here: ws.eoddata.com/Data.asmx?op=Login (Doesn't work in Firefox but does work in MS Edge) It returns the following (I've changed the Token as I don't want them to get miffed with me for publishing a real Token) The file is called 'Token.txt

1drv.ms/f/s!AhnMo5XqPIsMzHy48TJImm9-HrVo


4. The EODDATA website is here eoddata com default aspx

5. Can anyone help/guide me how the VBAfor the Yahoo download above gets changed so that I can resurrect my Workbook please?

Thank you

Graham Hall

[skminter]

I found that downloading their DataClient and telling it to create Excel files was the best option.

Susan K Minter

[Hallgente]

Hi Susan

I have terminated my subscription with EODDATA for now.
But my need to build myself a stock scanner has not diminshed so will look at this again in the future.
I taught myself to trade Options so figure I can teach myself to code in due course and get to better grips with what I want to do

Thank you