Quicken for Windows
Importing Security Prices
This discussion was created from comments split from:
Batch Import Security Prices by Symbol?
> @sslucas88 said:
> I found a way to import this file with all this information.
> I'm using the following layout (image.png - attached):
> Symbol, Price, Price, Date, High, High, Low, Volume, Null
> The only thing is:
> Date - must be a text without /
> Volume - is divided by 100 (one hundred) in the attached image. I carry the volume 113.86 which is equal to 11,300 (decimals is disregarded).
> Attached, you will find the image of the results (result 1.png)
> And now the graphics are working. (2.png result)
> Hope this helps
I have also been playing with this functionality. . . my results have been a mixed bag. I do ok with importing prices only. . but getting High,Low, Volume is a bit problematic.
The format for high/low/volume "more or less" seems to work.
1) The values in the 3rd and 5th columns seems to be irrelevant. sslucas88 is using "price" and "high" in those columns; but my testing indicates that any value (even a dash) works.
2) I don't have any issue with date column. . . . mine is formatting mm/dd/yyyy; and it seems to work fine.
3) The real sticking point for me is the "null" column. I am trying to create the CSV file from excel; in comma separated format. If I put any sort of character in that column; I get a pop up from Quicken ON EVERY PRICE labelled "security price detail". The popup it self is blank except for a button. Most annoying. The import does not seem to work without the last column. If I manually go into the CSV file with notepad, and manually enter a trailing comma. . . the import does not work.
4) A small import (10 or so prices) works ok (except for the popup). For a larger import (say, 50ish securities for 5-10 days). . . I find that I only get a partial import. I only get say, 150 of 200 price entries. The read doesn't seem consistent. If I do a "price only" import; it seems to work. . . except that I have a file with 250 rows. . .and Quicken reports importing 280 prices. . . .(I don't have this discrepancy with small imports)
I am using Q17R20; Creating the CSV file using MS Excel. I prefer to use excel, as I can easily create the CSV file for Quicken using a sheet that gets all the trading data from another source.
This discussion has been closed.
It looks like you're new here. If you want to get involved, click one of these buttons!
Alerts, Online Banking & Known Product Issues
Welcome to the Community!
Before you Buy
Quicken for Windows
Quicken for Mac
Quicken on the Web