Forum Discussion
Excel 365 Stock Data Type Frustrations
Fellow Excel users, I'm hitting major roadblocks with the Stock data type in Excel 365 that seem to defeat its purpose: Excel refuses to accept anything but plain text as a stock ticker. Even a si...
See if this link is helpful.
Beyond that, I have a spreadsheet that uses STOCKHISTORY to retrieve prices from past dates (as recent as yesterday) and I am consistently referring to the stock symbol as it appears in a different cell. This is the formula,
=STOCKHISTORY($C$2,$B35,,,0,3,4)
which retrieves the high and low prices for the stock specified in $C$2 and the date specified in $B35.