0

I am trying to import data from yahoo finance. However, when I go to

Data >> From text/CSV and enter the link, the following screen pops up:

Pop_UP 1

Pop_UP_2

The link I enter is just a copied link from yahoo finance (i.e. yahoo finacne >> google >> historical price >> download data >> copy link address).

Thank you very much!

Community
  • 1
  • 1
Achyut
  • 19
  • 1
  • 4
  • https://www.youtube.com/watch?v=EoeIn-3jbhI&t=19s ---> I am following a Youtube Video tutorial for importing stock. Unlike in the video @ 2:59, I get the pop up screen (image attached in the post). – Achyut Jul 08 '17 at 01:12
  • I am getting the same, not sure why. The video is using Excel 2007, maybe it works different with later versions. – Kevin Jul 08 '17 at 01:25
  • You can import from the Web page by using the **from Web** import wizard; the URL being the URL on the page that is displaying the historical quotes; and selecting the proper table (Table 2 when I tried it) – Ron Rosenfeld Jul 08 '17 at 02:04

1 Answers1

2

The video you linked to in your comment has been shot with Excel 2007, so it is about software that is 10 years behind what you are using. It was published three years ago. Things have changed since then.

Yahoo Finance API is no longer a free service. They shut down the service earlier this year and you can no longer pull data from it with Excel.

Apart from that, if you run the most recent versions of Excel 2016, the icon to import text or CSV will now start the Get & Transform functionality, also known as Power Query, not the old text import wizard. The dialogs that you see are from Get & Transform, asking you to authenticate for the URL you entered. If you have a user name and password, enter it and the connection will be made.

If you want to use the old text import wizard, you need to go File > Options > Data and tick the box for "From Text (Legacy)".

enter image description here

Then you can use the drop-down option for Legacy Wizards in the Get Data dialog of Get & Transform.

enter image description here

But I doubt that this will work, since Yahoo Finance has shut down the service.

teylyn
  • 34,374
  • 4
  • 53
  • 73