Solved

Excel VBA get range prices from historical stock prices

Posted on 2015-02-04
6
169 Views
Last Modified: 2016-02-10
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
Comment
Question by:gspodaku
  • 4
  • 2
6 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 40589550
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
 

Author Comment

by:gspodaku
ID: 40589676
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
 
LVL 29

Expert Comment

by:gowflow
ID: 40589725
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 40589738
Ooops !!! just saw your Excel 2003 ~~

Here it is.
gowflow
Yahoo-V02.xls
0
 

Author Comment

by:gspodaku
ID: 40589867
Thank you.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40590648
Welcome
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question