Forum Discussion
Sam_S007
Jun 12, 2020Copper Contributor
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...
- Jun 12, 2020
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.
SergeiBaklan
Jun 12, 2020Diamond Contributor
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_S007
Jun 12, 2020Copper Contributor
- SergeiBaklanJun 13, 2020Diamond Contributor
Sam, glad to help