How to download CSV from Yahoo Finance

KNIME Analytics Platform
1

Hello all,

I have downloaded CSV files form the web with KNIME several times. But with Yahoo finance this is not working, even if it is a CSV file.

This is the URL:

https://query1.finance.yahoo.com/v7/finance/download/AMD?period1=1496835513&period2=1499427513&interval=1d&events=history&crumb=wIjT09Ti8vk

 

Any idea how it works?

Thank  :)

Ralph 

2

The link is not a csv file, I get an "unauthorized" page, when I click on it.

Best, Iris 

1 Like
3

Hey Ralph,

According to this stackoverflow post Yahoo changed the API and you need a cookie.

I put together a little workflow that does this for you. You can extend it to use custom dates etc with String Manipulation nodes.

Best,
Ferry

3 Likes
4

Hey Ferry,

thanks so much!

Its works perfectly form me  :)

Ralph

5

Hi Ferry,
If I would import everyday’s data of a specific portfolio (created in Yahoo Finance) to automatically calculate the daily fixing price of it (as the investment funds do)… is your workflow useful connected to a downstream workflow to do rest of the job?
Thank you.
Regards
Andrea

6

Maybe, do you want to use Google Finance Historical Data ?
Then you can use this workflow :
google_api.knwf (90.5 KB)

2 Likes