Forum Discussion

Dash_Riprock_UK's avatar
Dash_Riprock_UK
Frequent Visitor
1 year ago

Yahoo Finance Power Query Link Not Working

Hello, I have a spreadsheet which downloads daily currency rates from Yahoo Finance using PowerQuery, for example...   = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/down...
Need Help
Dash_Riprock_UK's avatar
Dash_Riprock_UK
Frequent Visitor
1 year ago

Thanks to all for their help and suggestions.  Sadly, I couldn't get the JSON links to work meaningfully.  Either it involved playing around with many steps (at which point it was difficult to feel confident about data quality) or I couldn't achieve normal dates.  

 

After much faffing I gave up with Yahoo (hopefully they fix it in the future).

 

For now, I found this website... https://eodhd.com/

 

Free option... easy to use API... 20 free requests per day.  

  • G05DVD's avatar
    G05DVD
    Frequent Visitor
    1 year ago

    Thanks for this

     

    One issue I have with Yahoo Finance is I scrape data for a small number of ETF investments and said data doesn't include trade volumes. This could provide an alternative data source