Home Page link  

Size of Stock Price File

 

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
Size of Stock Price File Steve Blake 07-13-2007
Posted by Steve Blake on July 13, 2007, 8:19 am
Please log in for more thread options
I have a large stock price history file for two reasons. 1)Tracking
portfolio since 1990 and 2) I failed to quit downloading quotes after
selling securities. I have now unchecked the securities for downloading
that I have sold. I also went in and deleted thousands of prices. The
problem is that the size of the file did not change. Is there any way
to compact the file or any way to make it smaller?

Thanks,

Posted by John Pollard on July 13, 2007, 12:27 pm
Please log in for more thread options
Steve Blake wrote:
> I have a large stock price history file for two reasons.
> 1)Tracking
> portfolio since 1990 and 2) I failed to quit downloading
> quotes after
> selling securities. I have now unchecked the securities for
> downloading that I have sold. I also went in and deleted
> thousands
> of prices. The problem is that the size of the file did not
> change. Is there any way to compact the file or any way to
> make it smaller?

Deleting prices in Quicken *may* reduce the time it takes
Quicken to do certain tasks, even if the Windows price file
remains the same size.

But I don't know of anyway to reduce the size of the Windows
file of Quicken prices ... except to create a new, empty, price
file and add prices to it.

While not necessarily as simple as deleting prices from within
Quicken, it may not be as complex as it sounds.

I think the general process would be to:

1.) Export prices - to QIF file - from current Quicken data
(export "Security List")
2.) Delete unwanted prices from the QIF file (the hard part) ---
but I think if you have already deleted those prices in Quicken,
they should not export (I didn't test this)
3.) Create an empty Quicken price (qph) file (delete or rename
the existing file, or create a new Quicken data file)
4.) Import the modified QIF file of prices into Quicken when
Quicken has the empty price (QPH) file open

The result would be a QPH file of just the prices you wanted; it
could be used with any Quicken data fileset that had the same
securities.

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



Posted by Steve Blake on July 13, 2007, 2:47 pm
Please log in for more thread options


John Pollard wrote:
> Steve Blake wrote:
>> I have a large stock price history file for two reasons.
>> 1)Tracking
>> portfolio since 1990 and 2) I failed to quit downloading
>> quotes after
>> selling securities. I have now unchecked the securities for
>> downloading that I have sold. I also went in and deleted
>> thousands
>> of prices. The problem is that the size of the file did not
>> change. Is there any way to compact the file or any way to
>> make it smaller?
>
> Deleting prices in Quicken *may* reduce the time it takes
> Quicken to do certain tasks, even if the Windows price file
> remains the same size.
>
> But I don't know of anyway to reduce the size of the Windows
> file of Quicken prices ... except to create a new, empty, price
> file and add prices to it.
>
> While not necessarily as simple as deleting prices from within
> Quicken, it may not be as complex as it sounds.
>
> I think the general process would be to:
>
> 1.) Export prices - to QIF file - from current Quicken data
> (export "Security List")
> 2.) Delete unwanted prices from the QIF file (the hard part) ---
> but I think if you have already deleted those prices in Quicken,
> they should not export (I didn't test this)
> 3.) Create an empty Quicken price (qph) file (delete or rename
> the existing file, or create a new Quicken data file)
> 4.) Import the modified QIF file of prices into Quicken when
> Quicken has the empty price (QPH) file open
>
> The result would be a QPH file of just the prices you wanted; it
> could be used with any Quicken data fileset that had the same
> securities.
>

Thanks for the info. I'll give that a try when I have a chance.

Similar ThreadsPosted
Cleaning up stock price history file July 20, 2008, 11:32 am
Q 2008 file size September 4, 2007, 1:46 am
File Size Anomaly May 23, 2006, 2:09 pm
Quicken File Size Too Big November 6, 2008, 11:30 pm
Quicken 2008: File Size Seems Much Smaller than Q05's September 2, 2007, 3:53 pm
Manual Stock Price Import December 5, 2006, 8:16 pm
Download stock price in Quicken 2004 August 28, 2006, 11:31 am
Export or extract a day-by-day stock price list? September 4, 2007, 7:02 pm
Stock quote/Price history - can't download or manually update November 14, 2006, 11:59 am
Attachment Printing Size December 4, 2006, 7:00 pm

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