Cell A1 contains only text - a 3 letter stock symbol, say IBM
Cell A2 has a formula for real time data exchange with my broker that returns the current (LAST) stock price: =RTD("tos.rtd", , "LAST", "IBM")
Instead of having to type the letters IBM in the formula, I would like the formula to get this text from cell A1 that contains it. Then if I change the contents of cell A! to a different stock symbol, say GM (General Motors) the formula will show the last price for GM
Bookmarks