Gregg Wolin
Member
I'd like a to create a dynamic table of historic stock prices based on a list of dates and ticker symbols. The STOCKHISTORY function creates a dynamic output that includes a date column so I cant create a table like the one below and the stock function in the data tab is very cumbersome. Is there a formulaic way to populate such a table?
Date | NNN | EPRT | O |
1/1/2021 | $50 | $40 | $88 |