Quicken allows a user to import historical stock prices from a CSV
file in the following format:
TICKER,PRICE,DATE
For example, last weeks history for "Ross Dress for Less" could be imported as:
ROST,30.43,2/9/2004
ROST,30.57,2/10/2004
ROST,30.85,2/11/2004
ROST,30.82,2/12/2004
ROST,30.10,2/13/2004
There exist an undocumented file format for the CSV import that allows
importing of the above information, plus HIGH, LOW, and VOLUME
history. I know that this undocumented format exists because I used
to use it before (unfortunately) forgetting it. I do recall that the
format require the use of some null fields, and was something along
the lines of:
TICKER,PRICE,DATE,,HIGH,,LOW,,,VOLUME
The successful answer to this question will provide the correct
working syntax for the CSV import of historical data including HIGH,
LOW, VOLUME information. |
Clarification of Question by
blackrock-ga
on
20 Feb 2004 07:21 PST
Note: I did not specify the version of Quicken, which may or may not
be a factor. The solution must be effective in Quicken 2004 Premier
for Windows.
|
Request for Question Clarification by
denco-ga
on
03 Mar 2004 23:44 PST
Howdy blackrock-ga,
Do you mean something like:
"AAPL",18,"4/6/97",18.750,16.250,1253
"AAPL",18.500,"4/7/97",19.250,17.750,652
"AAPL",19,"4/8/97",20,18.500,530
or perhaps:
"AAPL",57.75,"3/3/2004","4:01pm",+0.43,57.32,57.77,57.26,2646900
"AAPL",23.18,"3/4/2004","4:00pm",-0.31,23.49,23.49,22.99,1198200
This latter format contains:
ticker,price,date,time,change,open,high,low,volume
So a null field version based on that format would be:
"AAPL",23.18,"3/3/2004",,,,23.49,22.99,1198200
or perhaps:
"AAPL",23.18,"3/3/2004","","","",23.49,22.99,1198200
Please see if one of the above works for you, and I can then
post it as an Answer. Apologies on the multiple formats, but
there is much conflicting information on the file formats.
Looking Forward, denco-ga - Google Answers Researcher
|
Clarification of Question by
blackrock-ga
on
04 Mar 2004 07:08 PST
Hi Denco,
The samples you proposed all caused Quicken to import simply the
ticker, date, and close, but no additional information.
The insight that the blank field I remember may be things like change
and volume is a good observation.
I do recall that the blank fields were't all adjacent to each other,
as they are in your last two examples.
Thanks for the effort so far, but still no solution...
|
Request for Question Clarification by
denco-ga
on
04 Mar 2004 18:03 PST
Howdy blackrock-ga,
When the undocumented file import worked, was it under an earlier
version of Quicken, for instance, 2000 or 2001?
Thanks! denco-ga
|
Clarification of Question by
blackrock-ga
on
08 Mar 2004 06:48 PST
Hi Deno,
Sorry for the delay responding - weekend full of travel.
I see where this could be going, maybe the feature is no longer there?
I'm a pretty religious upgrader, and am running Quicken 2004
currently. As mentioned above, while this once worked, at some point
I forgot how to do it. I can't say if I ever imported using quicken
2003, but am pretty sure this worked during the Quicken 2002
timeframe.
Having checked my old CDs, I don't have any copies of older versions
sitting around to "downgrade" to.
Maybe this leaves us stymied?
|
Request for Question Clarification by
denco-ga
on
08 Mar 2004 09:42 PST
Not a problem blackrock-ga,
Yep, that is what I am seeing. I suspect strongly that the "feature"
you use to use ended with Quicken 2002. Too bad, as it was a pretty
useful format to be able to use.
If anything were to work it would have been this:
"AAPL",58.82,"3/8/2004","12:07pm",+0.43,58.35,58.90,58.34,1579600
The above is the data that Yahoo gives you when you download stock
information. Once downloaded, Yahoo says:
"In Quicken, use the Import Prices command."
Standard practice in CSV files is to remove any information you want
to show up as null value and leave the separating commas.
The fact the above doesn't import any additional information, and
as I can't find any informaation to indicates that Quicken 2004 can
import anything other than "ticker,price,date" I think, indeed, we
are stymied.
You might have to work with tradiitonal spreadsheet program or one
of the various stock tracking programs.
Looking Forward, denco-ga - Google Answers Researcher
|
Clarification of Question by
blackrock-ga
on
08 Mar 2004 11:34 PST
Hi Denco,
Thanks for the effort you've put into this. Is there a way I can tip
you without having answered the question?
Anyhow, one comments:
> "AAPL",58.82,"3/8/2004","12:07pm",+0.43,58.35,58.90,58.34,1579600
I'm certain this wasn't it. Stripping out everything except ticker,
date, close, high, low, volume leaves:
"AAPL",58.82,"3/8/2004","","","",58.90,58.34,1579600
Notice that this would put the three null fields next to each other.
I'm certain that in the format I used (which may be gone for good),
the null fields were distributed around, and not all in a row.
|
Request for Question Clarification by
denco-ga
on
08 Mar 2004 16:00 PST
Howdy blackrock-ga,
The bottom line is that if the format of:
"AAPL",58.82,"3/8/2004","12:07pm",+0.43,58.35,58.90,58.34,1579600
on import doesn't give you anything but "ticker,price,date" then I
don't think that any other format will give you anything different.
In other words, the "feature" is gone, I'm afraid.
You could (last resort, and I think uselessly) try something like:
"AAPL",58.82,"3/8/2004",58.35
If this gives us 4 points of reference (don't know what the fourth
would be) then we could build from there.
Really no need to tip, etc. but if you insist, you can always post
a question, specifically address it to me (Quicken price imports -
for denco-ga please or equal) price it for $2.00 and then you can
tip (or not) additional to that, if desired. Truly no need to do
any of that as we are here to provide Answers to your Questions.
Nothing gained, nothing lost, other than the $0.50 listing fee.
My pleasure! denco-ga - Google Answers Researcher
|
