Download Yahoo quotes to Q99?


D

Dan Wenz

I downloaded quotes.csv from Yahoo Finance and used the Q99 import
function to load into Q, but got no data loaded other than 2 (wrong)
prices out of the 14 I expected. Are you folks going this route having
any success with Q99, or must I edit the file to remove data Q won't
import (highs, lows, volume, etc.) - I hope not. At any rate the new
Dell came with MS Money so I'll give that a try also.
 
Ad

Advertisements

J

John Pollard

Dan said:
I downloaded quotes.csv from Yahoo Finance and used the Q99
import function to load into Q, but got no data loaded other
than 2 (wrong) prices out of the 14 I expected. Are you folks
going this route having any success with Q99, or must I edit
the file to remove data Q won't import (highs, lows, volume,
etc.) - I hope not. At any rate the new Dell came with MS Money
so I'll give that a try also.
Have you actually looked at the data in the file?

Q2002 just ignores highs, lows, volume; having them in the file
does not cause a problem, I doubt that it does in Q99 either.

It's not clear what your expectations were based on, so not
clear why the 2 prices were incorrect. Check the .csv file to
see if the prices were wrong there. Also, there should be a
blurb in the Quicken help describing the format of the .csv file
with one or more examples.

Price imports must have a ticker symbol matching the ticker
symbol for that security in Quicken.

And prices must be imported from the Portfolio View in Q2002, I
suspect some similar restriction applies in Q99.

One other possibility, someone else with Q99 can probably clear
this up; I believe Q99 may not have fully implemented y2k so I
am not sure what format it expects .csv dates to be in. If it
is looking for two digit years, or an apostrophe separator, it
will be disappointed.
 
J

Jim Craig

I downloaded quotes from Yahoo to Q99 for several years, but 6-8 months ago
suddenly it would not update most of the stocks - only a couple of stocks
and a couple of mutual funds. I looked at the data and could see no
difference between those that did update and those that didn't. As I was
only doing about 25 stocks monthly, I quit fighting it and did it manually.
Then when they announced that online support was being dropped, I moved up
to Q2002. The complete list now updates correctly from Yahoo. Q2002 seems to
work just as well as Q99 did, and with it being available quite reasonably
on ebay, would be a much easier conversion than going to MS Money.

Jim
 
H

Hank Arnold

Here's a SWAG.....

Check the date format. IIRC, Q99 had a problem with the current default for
date formats.
 
Ad

Advertisements

D

Dan Wenz

John said:
Have you actually looked at the data in the file?

Yes.
Q2002 just ignores highs, lows, volume; having them in the file
does not cause a problem, I doubt that it does in Q99 either.
But there is a problem, source unknown.
It's not clear what your expectations were based on, so not
clear why the 2 prices were incorrect. Check the .csv file to
see if the prices were wrong there. Also, there should be a
blurb in the Quicken help describing the format of the .csv file
with one or more examples.
I, as we all have, many ways to look at each day's prices - CNBC,
Fidelity, Yahoo, etc. The
prices in the .csv file were correct with 2 exceptions, Intel and Cisco
were both given wrong quotes, $6 for both! Downloading prices from
Quicken didn't change those figures, no idea why.
Price imports must have a ticker symbol matching the ticker
symbol for that security in Quicken.
They do.
And prices must be imported from the Portfolio View in Q2002, I
suspect some similar restriction applies in Q99.
They were.
One other possibility, someone else with Q99 can probably clear
this up; I believe Q99 may not have fully implemented y2k so I
am not sure what format it expects .csv dates to be in. If it
is looking for two digit years, or an apostrophe separator, it
will be disappointed.
Thanks to all for the input, I still need to take a look at MS Money,
already installed in a new Dell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Q99 Quotes 1
BT quotes on Yahoo. 4
Yahoo quotes/charts - now GONE 0
Download Yahoo Spreadsheet, Question 7
New Zealand Importing quotes (Infusion) 1
Download Quotes ?? 5
Downloading Quotes 0
Quote Downloads 2

Top