stgermainr
New Member
- Joined
- Jan 20, 2021
- Messages
- 4
- Office Version
- 2019
- Platform
- Windows
Hello,
I have data that is organized like this:
In the Ticker column, I would like to have tickers in cells A2:A501 and would like to simply copy the cell the formula in B2 all the way down. I know if I nest the Stockhistory function in the Transpose function, I would get the solution I'm looking for but I need the data to be in column vs in rows like this:
Ticker Price
WMT $50.20
WMT $50.40
WMT $49.56
WMT $52.80
... $51.78
PRU $120.77
PRU $122.40
etc.
With the stockhistory function consistently returning dynamic data that increases as each trading day passes, how would I achieve my goal of having the Stockhistory function return data in column B without resulting in a #SPILL error or overlapping data without first spreading out each ticker x number of rows (which would work once, but not when I refresh it and another day's price gets added for each ticker)?
I have data that is organized like this:
In the Ticker column, I would like to have tickers in cells A2:A501 and would like to simply copy the cell the formula in B2 all the way down. I know if I nest the Stockhistory function in the Transpose function, I would get the solution I'm looking for but I need the data to be in column vs in rows like this:
Ticker Price
WMT $50.20
WMT $50.40
WMT $49.56
WMT $52.80
... $51.78
PRU $120.77
PRU $122.40
etc.
With the stockhistory function consistently returning dynamic data that increases as each trading day passes, how would I achieve my goal of having the Stockhistory function return data in column B without resulting in a #SPILL error or overlapping data without first spreading out each ticker x number of rows (which would work once, but not when I refresh it and another day's price gets added for each ticker)?