Re: Excel 2003 Web Query Smart Tag definition?

  • From: "Farfar Carlson" <dgcarlson@xxxxxxxxxxxxx>
  • To: <jfw@xxxxxxxxxxxxx>
  • Date: Sat, 5 Mar 2011 21:34:42 -0800

Ann Marie,

All I can say is "wow". I understand everything you put in your notes -- I'll 
just have to carve out a bit of time and give them a try. Good learning 
experience.

Dave
Composed on a Dell Latitude 630 in the general vicinity of my Audio Recording 
and Mixing Studios, San Francisco Bay Area.
  ----- Original Message ----- 
  From: Ann Marie Medlar 
  To: jfw@xxxxxxxxxxxxx 
  Sent: Saturday, March 05, 2011 13:47
  Subject: Re: Excel 2003 Web Query Smart Tag definition?


  Hi,
  I am still working on this project.  But if I figure it out it is so easy to 
access important info from sites.  I can create a company report if you are 
interested which gives a summary what a company does and other financial info.  
If one has an interview it would be easy to research about that company in a 
couple minutes.  Also if you wish to buy a stock it might give you some 
insights.    But this tool is endless to do specific research on anything.  
Jaws research it feature is similar and I just downloaded the info from FS 
site.  Hope to be able to get info more easily so I'll keep working on this.    
  Here are my Excel notes:
  Download link for 
  Excel spreadsheet with a web Query for stock quotes called 
  StockQuoteTemplate.xls
  You may Need to copy and paste link into your browser because link name is 
too long.

  
http://webcache.googleusercontent.com/search?q=cache:FS7e8sn8rlQJ:www.vertex42.com/ExcelTemplates/excel-stock-quotes.html+Link+StockQuoteTemplate.xls&hl=en&gl=us&strip=1
  Enter on text only version and read page until download link
  or Type "H" twice for download  
  After downloading and opening Excel spreadsheet called StockQuoteTemplate.xls 
  2 buttons appear 
   Press button that Enables data to be refreshed
  press control +G for GoTo Excel command  
  type c6 and enter 
  Type stock symbol and enter 
   go to b11 right and left arrow for company stock quotes  
  On B11 enter on stock symbol to link to web

  to get company report use insert+f7 enter on print report link
  type x and check company report
  type b for button enter on generate report new browser window opens 
  enter on print link
  company report displayed on screen which looks like a PDF
  Other notes:
  Press alt+F5 key to refresh
  There are many links on this page as well.  It is easier navigating site 
  using this work book.
  Microsoft link for Excel Web Queries:
  
http://msdn.microsoft.com/en-us/library/aa203721(v=office.11).aspx#odc_xlwebquery_introduction
  Smart Tag link:
  
http://webcache.googleusercontent.com/search?q=cache:8Aft_cEwD5wJ:support.microsoft.com/kb/289148+Add+smart+tag+Excel+2003&cd=1&hl=en&ct=clnk&gl=us&source=www.google.com

    
    ----- Original Message ----- 
    From: Farfar Carlson 
    To: jfw@xxxxxxxxxxxxx 
    Sent: Friday, March 04, 2011 6:27 PM
    Subject: Re: Excel 2003 Web Query Smart Tag definition?


    Ann Marie,

    You're way above my head. I'm going to keep your name on my list if I have 
any Excel questions.

    Sorry I can't help.

    Dave
    Composed on a Dell Latitude 630 in the general vicinity of my Audio 
Recording and Mixing Studios, San Francisco Bay Area.
      ----- Original Message ----- 
      From: Ann Marie Medlar 
      To: jfw@xxxxxxxxxxxxx 
      Sent: Friday, March 04, 2011 11:55
      Subject: Re: Excel 2003 Web Query Smart Tag definition?


      Hi all,
      I am trying to define a smart tag for company report in Excel 203 to go 
to the MSN central money site.  Right now if you enter a stock ticker symbol in 
c6, the stock price action is populated in B11:q11 or so.  
      If I enter on B11 I go to site and company report is a check box under 
print report.  So I would like to link the new company report smart tag to this 
site so the company report will be included on spread sheet.  

Other related posts: