Exporting Exchange Rates from Quicken

dwg's Avatar

dwg

21 Jan, 2020 12:09 PM

Folks,

I'm looking for information from someone that may still have Quicken running.

I'm interested in if we can get Exchange rates out of Quicken somehow in a usable format..

In my research it seems possible to get at least part of the way but information dries up. I have uncovered the following instructions:

In the Tools menu > Currency List.  Click on the currency you wish to print and select the Historical Prices button from the bottom right side of the window.

In the Window that opens, select "print" at the top and toggle the option to "Export"

I'd like to know if the options under export include:

1. Tab delimited file
2. PRN file.

and if so what the file looks like that these two options produce.

Thanks for any pointers.

Des

  1. 1 Posted by tgilbert666 on 21 Jan, 2020 03:37 PM

    tgilbert666's Avatar

    Hi Des,
    I'm in Australia and moving from Reckon Home & Business 2020 to MD on Windows. I believe it's been similar for at least the last 5 versions of H&B

    I've tested all of the above and have attached a quick-and-dirty spreadsheet result below. Reckon gives you the choice to export the complete currency list with name, symbol and LATEST rate only, or to export a Full Currency History, ONE CURRENCY PAIR AT A TIME (including date and rate).
    Export to Text, Print to Text and Print to PRN all give the same output which is perfectly usable although my symbols needed attention during Excel import to choose the correct charset which defaulted wrongly. (In my case Windows (ANSI) was required but the files defaulted to Shift-JIS - perhaps by recognising my ¥ Yen symbol.) The screenshot is the result of Tools | Currency List | Historical Rates | Print
    Hope that helps.

  2. 2 Posted by dwg on 21 Jan, 2020 08:23 PM

    dwg's Avatar

    Hi,

    Thanks for the effort. That is the soft of thing I wanted to see. When I migrated from Reckon myself I had to export a transaction report from each account and I remembered there was a funny way through Print then export to an Excel "compatible" format. A screen shot I saw during my research triggered some memories.

    Why I asked about the two formats was that I found another note about some subtle differences between the two formats that might make PRN (which is what was used with Lotus 1-2-3) more straightforward. A file with a format that is close may just need to be opened in something like Notepad and have some little changes made which then make it importable into Moneydance.

    It is the first page of your Excel file that is the interesting one. I have been able to make some little changes, save it as a true CSV file and import it successfully. I'm particularly glad you did Sterling as it looks like the rates need to be inverted for Moneydance. Time for some more fiddling :)

    The whole reason for looking at this is for migrating away from Quicken/Reckon. A fellow user found that if exchange rates were loaded first and an account was set to use a loaded foreign currency then transfers between accounts would be converted. This has the potential to avoid the duplicates that otherwise occur and avoid some manual corrections, as what is in Quicken is hopefully the exchange rate used for the transactions rather then just being indicative rates you could get from other sources.

    Des

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac