I appreciate that Quicken currently is designed for US & Canada use only. I want to update with UK security prices which I can download into a spreadsheet. Is there a way to import these into Quicken in one go rather than manually entering each security price?
Quicken will import security prices from a properly formatted comma delimited file. You can find all the info in Quicken Help ("import"). Here's the key part:
The data must be in standard ASCII format with one symbol/price/date per line, separated by either commas or double spaces (using only one type of separator per line).
These import formats are all acceptable. Note that Quicken can handle quotation marks:
ABC, 123.456
ABC, 123.456, 12/31/02
ABC 123.456 12/31/02
ABC, "ABC", 123.456, "12/31/02"
"ABC", "123.456", "12/31
There is a free program called Netstock which can get prices and create a comma delimited file that can be imported into Quicken. I'm not sure which non-U.S. prices Netstock is capable of getting, but it seems to me someone recently posted that they were getting UK prices using Netstock. Also, I believe Yahoo can download a comma delimited file of prices.
John
Many thanks for this - I am assuming you are a "UK" user/ potentioal of Quicken?
I'm a U.S. user of a U.S. version of Quicken.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.