Forum Discussion
Solved
Historical Stock Prices into Excel from Yahoo! Finance
I am using Power Query to automatically download historical stock price data from Yahoo! Finance into Excel. The URL is https://finance.yahoo.com/quote/QQQ/history/ It populates a worksheet with...
Sure, just open the query on editing, find Change Type step, stay on it, select proper column and apply Decimal Number format, close the query.
I did that in attached file.
That's since all data returned is texts
= Table.TransformColumnTypes(Data2,{{"Date", type date}, {"Open", type text}, {"High", type text}, {"Low", type text}, {"Close*", type text}, {"Adj Close**", type text}, {"Volume", type text}})Please change in Power Query on decimal numbers where applicable.
Just wondering why the first column (the Date column) is recognized properly as a date column while the other 6 columns are only recognized as text? Is there any way to change the format of the price columns from text to numbers without VBA or any programming?
Thanks!