yahoo finance api not working

[chandan kumar]

hello all. I was using a spreadsheet for financial data which uses yahoo finance. But now as we all know that yahoo has stopped its financial API and now the spreadsheet is not working. Can anyone help me in this spreadsheet to make necessary changes in its vba codes so that it takes data from bse site. I am uploading the spreadsheet. thank you.

BSE API -

http://www.bseindia.com/stockinfo/stockprc2_excel.aspx?scripcd=532646&
fromDate=05-01-2017&toDate=05-31-2017&OldDMY=D&ScripName=UNIPLY

coping and pasting this in browser url address bar give a csv file to save.

my email id - chandan_ssj@yahoo.com

 

[Hui]

Chandan

Firstly, Welcome to the Chandoo.org Forums

Yes, Yahoo changed it about a month ago

I haven't seen any update or new info yet

maybe time to look for an alternate source

 

[Marc L]

Hi !

Just apply a web search for yahoo, solution on other forum …
​

 

[Logit]

I understand from another Excel forum that Yahoo has moved their data to a different folder:

"http://download.finance.yahoo.com/d/quotes.csv?s=" + Cells(i, 1)

 

[Hui]

Have a read of:
http://www.canbike.org/information-technology/yahoo-finance-url-download-to-a-csv-file.html

 

[AlanSidman]

If you are looking for end of day pricing, then this formula should work:

=NUMBERVALUE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s="&A2&"&f=l1"))

Assuming your symbol is in A2

Additionally, if you are looking for more data, then look at the download at this website:

http://investexcel.net/

and finally, there is an add-in that I am using located at:

www.parago.de

 

[Harry Espino]

I have moved to MarketXLS after this change, much more reliable data.