Home Page link  

Download historical prices

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Download historical prices Jack Mangrove 06-17-2007
Posted by Jack Mangrove on June 17, 2007, 6:55 pm
Please log in for more thread options
I just downloaded historical prices for several securities for the
current year. There are prices missing for many dates and it is the
same dates in all securities. There are prices for just four days in
January - Fridays only, five days in February (all Fridays plus Tues
2/27), the first four Fridays in March plus most of the last week,
then every day for April, May and June. How do I get prices for every
day in Jan, Feb, and Mar? I have transactions on days not provided.


Posted by John Pollard on June 17, 2007, 10:32 pm
Please log in for more thread options
Jack Mangrove wrote:
> I just downloaded historical prices for several securities for
> the
> current year. There are prices missing for many dates and it
> is the
> same dates in all securities. There are prices for just four
> days in
> January - Fridays only, five days in February (all Fridays
> plus Tues
> 2/27), the first four Fridays in March plus most of the last
> week,
> then every day for April, May and June. How do I get prices
> for every
> day in Jan, Feb, and Mar? I have transactions on days not
> provided.

The only thing you can control about historical price downloads
is the overall time frame of the download.

Historical prices are designed to download: daily prices for the
current month; weekly prices for the 11 months prior to that;
and monthly prices prior to that.

If you see other prices in your price history, they came from a
previous "Quote" download, a previous "Historical Price"
download, a download of your holdings from your fi, a manual
update of your price history, or an investment transaction that
contained a price.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by Jack Mangrove on June 18, 2007, 1:09 pm
Please log in for more thread options
As far as I can tell, the price history lists in Quicken are for
visual reference only, and the values do not automatically popluate
any forms or functions, even where it would be very useful as in
entering a buy transaction. So, if I get historical prices from other
sources, is there any reason for me to enter them in the price history
lists in Quicken.


Posted by John Pollard on June 18, 2007, 4:35 pm
Please log in for more thread options
Jack Mangrove wrote:
> As far as I can tell, the price history lists in Quicken are
> for
> visual reference only, and the values do not automatically
> popluate
> any forms or functions, even where it would be very useful as
> in
> entering a buy transaction. So, if I get historical prices
> from other
> sources, is there any reason for me to enter them in the price
> history
> lists in Quicken.

The prices in your Quicken price history are used to value your
securities: automatically.

If you want to know what your IBM stock was worth a year ago,
you need a price/share in Quicken dated a year ago. If you want
to see if the value of your Quicken holdings match the value of
your holdings on your last brokerage statement, you need a
price/share for each security held at the brokerage as of the
date of that statement. If you want to see a graph of the
change in the value of your holdings over time, you need
price/share for the end of each period shown in the graph.

So I think the Quicken historical prices are fairly useful.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by Jack Mangrove on June 27, 2007, 12:52 pm
Please log in for more thread options
> Jack Mangrove wrote:
> > As far as I can tell, the price history lists in Quicken are
> > for
> > visual reference only, and the values do not automatically
> > popluate
> > any forms or functions, even where it would be very useful as
> > in
> > entering a buy transaction. So, if I gethistoricalprices
> > from other
> > sources, is there any reason for me to enter them in the price
> > history
> > lists in Quicken.
>
> Thepricesin your Quicken price history are used to value your
> securities: automatically.
>
> If you want to know what your IBM stock was worth a year ago,
> you need a price/share in Quicken dated a year ago. If you want
> to see if the value of your Quicken holdings match the value of
> your holdings on your last brokerage statement, you need a
> price/share for each security held at the brokerage as of the
> date of that statement. If you want to see a graph of the
> change in the value of your holdings over time, you need
> price/share for the end of each period shown in the graph.
>
> So I think the Quickenhistoricalpricesare fairly useful.
>
> --
> John Pollard
> First initial underscore Last name at mchsi dot com
> Please reply to newsgroup

More about historical prices.
I found a source of historical prices on Yahoo! Finance that is
complete and can be downloaded as an Excel spreadsheet. Is there any
way of getting that data into Quicken en masse instead of editing the
Price History lists and entering individually? This would be for
periods in the past for which data is not available thru Quicken
because it will only get one value per week.


Similar ThreadsPosted
Stopping Download of Historical Prices May 31, 2007, 10:52 pm
Historical Prices - Q2008HB April 26, 2008, 7:51 pm
Error message--Update historical prices February 16, 2008, 10:35 am
Download Historical Bank Transactions January 20, 2008, 2:51 pm
Can't download today's prices November 14, 2006, 6:28 pm
How do I prevent historical quotes? January 24, 2007, 8:39 pm
02/10/2007: Historical Quotes Down? February 10, 2007, 4:43 pm
Where is Edit Historical Quotes - Q07? March 29, 2007, 5:22 am
How to import historical investment transactions October 25, 2006, 2:29 pm
Historical Return for Watch List Securities February 5, 2007, 9:56 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap