Is it possible to use the Smart Tag feature in Excel 2007 to reference one cell that has a stock ticker in it and then:
1. Populate a cell with the company name
2. Populate a different cell with the closing price of the stock?
ie,
Cell A2 has the Ticker symbol
Cell A3 will get the Company name
Call A4 will get the closing price
It seems that you have to accept a lot more information when using this feature.
Any ideas?
Thank you,
Barney
Use the Smart Tag feature to pull the data into Excel on a scrap sheet, then use references to draw the data from there onto your formatted sheet to look the way you want/prefer.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hello,
you can also use Financial Link for Excel to load updating stock quotes, financial statements, estimates, price histories into Excel. Easy-to-use formulas to load the data and also wizards to help you creating the formulas.
More detailed information here:
http://www.xlconsulting.net/flink.php
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks