Forum Discussion
Gr_Del4
Feb 24, 2025Copper Contributor
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...
mathetes
Mar 03, 2025Gold Contributor
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.