SOLVED

Issues downloading historical data from Yahoo Financ

New Contributor

Hi, when I am downloading historical data, it is not downloaded directly into columns, this is my first issue and my second issue is that the numbers are displayed in an odd manner. cfr. below

Joerivdb_0-1640956705974.png

So e.g. in column B2 the number is displayed as 110.760.002, instead of 110,76. The same for all the other numbers.

This makes it difficult for me to execute calculations.

Does anyone has a solution for my 2 issues?

Thanks!

6 Replies

@Joerivdb Exactly what and how are you downloading? Do you have a URL? Using Power Query?

@Riny_van_Eekelen 

Hi Riny,

I take the following steps: I go to Yahoo Finance, I type in e.g. BABA, I go to historical data:

Joerivdb_0-1641114671257.png

click apply and than I click on download and my pc asks me to save the file:

Joerivdb_1-1641114789510.png

Next I get a cvs file at the bottom of my pc:

Joerivdb_2-1641114870465.png

I just click on the file to open it and I get the following in Excel:

Joerivdb_3-1641114953011.png

Next I try to convert the data into columns and I get the following:

Joerivdb_4-1641115179327.png

I don't have an url and I don't use a power query (don't really know what that is really)

Thank you for your help!

 

@Joerivdb Don't open the CSV just by clicking on it. Import it into Excel in stead via Power Query or the legacy text import wizard.

Screenshot 2022-01-02 at 10.43.53.png

No further adjustments needed. The end result will look like in the attached file.

@Riny_van_Eekelen 

Hi Riny,

I still keep encountering the same problem.

I took the following steps:

Joerivdb_0-1641141622209.png

And I get:

Joerivdb_1-1641141682010.png

It is the same as when I download the cvs file directly into Excel. There keep appearing two dots in every number.

I live in Belgium and I have a dutch version. I don't know if that has anything to do with that?

Is there another way to display the numbers correctly?

Thanks!

@Joerivdb 

On the third step what are your decimal and thousand separators?

image.png

best response confirmed by Joerivdb (New Contributor)
Solution

@Sergei Baklan 

Hi Sergei,

 

On the 3th step it shows the following:

 

Joerivdb_0-1641652469188.png

Decimals: a comma and thousands: a point.

 

Thanks!