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.
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!
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.
Sam, glad to help