Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > stock quotes into spreadsheets?

stock quotes into spreadsheets?
Thread Tools
Timo
Addicted to MacNN
Join Date: Dec 2000
Location: New York City
Status: Offline
Reply With Quote
Aug 12, 2007, 11:11 PM
 
Is there a way to have an excel or numbers spreadsheet grab a quote? Dashboard obviously gets the info, but it would be great to transfer it (and other data) directly to a spreasheet.
     
-Q-
Moderator
Join Date: Jan 2001
Location: Atlanta, GA
Status: Offline
Reply With Quote
Aug 13, 2007, 12:55 PM
 
No idea if Numbers can do it, but Excel can with its 'Web Query' function. If you type 'Web Query' into Excel's help you'll get the steps for doing it. And there's already a canned stock quote query you can modify. Not sure it's formatted exactly as you like, but you can see the basics of how it's done.

Also, here's the MS Office support doc on it: http://office.microsoft.com/en-us/ex...450851033.aspx
     
   
Thread Tools
 
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Top
Privacy Policy
All times are GMT -4. The time now is 04:37 PM.
All contents of these forums © 1995-2017 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2017, Jelsoft Enterprises Ltd.,