Welcome to the Excel Forum

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.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 07-01-2009, 12:25 PM
cantog cantog is offline
Registered User
 
Join Date: 01 Jul 2009
Location: Norway
MS Office Version:Excel 2003
Posts: 1
cantog is becoming part of the community
Question Req: How to import rates for tickers (financial)?

Please Register to Remove these Ads

Hi,

I wonder if it's possible to automatickly import the latest rate for a share by clicking an "update" button in excel. (open, high, low, volume...)

After clicking I would like the worksheet to contain all values from the last time I updated to the present day. None of the previous rates (for past days) are to be deleted. I would like to do this in order to make a graph for the historical rates.
The ticker I'm going to use is YAR (Yara International)

Thanks in advance.
Reply With Quote
  #2  
Old 07-01-2009, 12:58 PM
JBeaucaire's Avatar
JBeaucaire JBeaucaire is offline
Forum Guru
 
Join Date: 21 Mar 2008
Location: Bakersfield, CA
MS Office Version:2003 (can read 2007 files)
Posts: 9,532
JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay
Send a message via Skype™ to JBeaucaire
Re: Req: How to import rates for tickers (financial)?

Hi Cantog. You probably want to read up on using the DATA > IMPORT EXTERNAL DATA > WEB QUERY.
__________________
If you've been given good help, use the icon to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting 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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump