1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

yahoo finance api not working

Discussion in 'VBA Macros' started by chandan kumar, Jun 6, 2017.

  1. chandan kumar

    chandan kumar New Member

    Messages:
    1
    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

    Attached Files:

    ThrottleWorks likes this.
  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,532
    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
    ThrottleWorks likes this.
  3. Marc L

    Marc L Excel Ninja

    Messages:
    3,094

    Hi !

    Just apply a web search for yahoo, solution on other forum …
    ThrottleWorks likes this.
  4. Logit

    Logit Member

    Messages:
    90
    ThrottleWorks likes this.
  5. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,532
  6. AlanSidman

    AlanSidman Active Member

    Messages:
    121
    ThrottleWorks likes this.
  7. Harry Espino

    Harry Espino New Member

    Messages:
    1
    I have moved to MarketXLS after this change, much more reliable data.
    ThrottleWorks likes this.

Share This Page