Forum Discussion
When downloading historical data from Yahoo Finance I am not able to convert text into numbers
Hello,
I have an odd issue with the historical data of the company that I have downloaded from the Yahoo Finance. When I try to convert the data from text into decimal numbers using the query editing tab all the numbers in the column are changing into "error". I have tried downloading the data directly from the Yahoo Finance page using the download button from their website as well as using the download from web option in the Excel (The URL is: https://finance.yahoo.com/quote/GRG.L/history?period1=1513641600&period2=1608336000&interval=1d&filter=history&frequency=1d&includeAdjustedClose=true). In both cases I have the same issue. What is more, I have tried different companies to see if there is any difference, however in every case I have still the same results.
Does anyone know the solution? I attached a copy of the spreadsheet.
dsmiech See attached. Changed data type using locale for UK that recognises the comma as a thousand separator.
8 Replies
dsmiech Try replacing comma's with nothing. Then Power Query should be able to recognise the values as numbers.
Can't test it right now as I'm not close a computer with PQ.🙂
Unfortunately, but after replacing commas with nothing Power Query is still not recognizing the values as numbers and when I try to convert them the errors still occur.
dsmiech After replacing, did you change the data type to a decimal number or a whole number?
