Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

Excel VBA get range prices from historical stock prices

I have a excel workbook with price-downloader macro, attached. What I'm looking for is a solution to get and store only data I need. Please see attached file for explanation.
Also I'd like to get an expert opinion about optimization of a quote downloading macro I have.
Thank you in advance.
Yahoo.xls
0
gspodaku
Asked:
gspodaku
  • 4
  • 2
1 Solution
 
gowflowCommented:
When you say:

One way would be to get needed data from those sheets and delete them but I think it is not the smartest way.

You mean you want all the data in sheet input ?
like
MSFT      1/1/2015      2/1/2015
should be 1 row only for this date range the
Open Price      Highest High      Lowest Low      Close Price

or it should be for every day during this period ?

Can you simply give us the real figures for these
MSFT      1/1/2015      2/1/2015
IBM              1/1/2015      2/1/2015
GOOG      1/1/2015      2/1/2015
GE              1/1/2015      2/1/2015

so we know how to go about doing the calculations ?
gowflow
0
 
gspodakuAuthor Commented:
What I need are Open Price, Highest High, Lowest Low, Close Price of specified date range for each Ticker.

I need to fill "yellow square" with data.
For example row for MSFT should look like:
Ticker      Start      End      Open Price      Highest High      Lowest Low      Close Price
MSFT      1/1/2015      2/1/2015      46.66      47.91      40.35      40.40



P.S.
I forgot to mention that I need it to work in MS Excel 2003.
0
 
gowflowCommented:
yes ok pls test this file it will get you the values in Input sheet and will not create the sheets.
gowflow
Yahoo-V01.xlsm
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
gowflowCommented:
Ooops !!! just saw your Excel 2003 ~~

Here it is.
gowflow
Yahoo-V02.xls
0
 
gspodakuAuthor Commented:
Thank you.
0
 
gowflowCommented:
Welcome
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now