Importing QIF files

[Mark Wigmore]

On 2 February 2015 at 18:27, David Reiser <dbreiser at icloud.com> wrote:

>
> When Yahoo fails for you, can you see the change in reporting pence vs
> pounds in the normal web page viewing? It’s been a long time, but there was
> a point when I wrote a patch for Finance-Quote to handle mutual funds which
> for some reason didn’t have an exchange associated with the price report
> and for which Yahoo was serving up quotes in GBp (case sensitive!, pence)
> vs. GBP (pounds). As long as Yahoo always declares a currency (GBp vs GBP)
> for your problem cases, FQ can be fixed. I can’t remember whether I sent
> the patch upstream. I think I was working on it at a time when FQ had no
> maintainer for quite a while. And since there has been little clamor for a
> fix that seemed to affect almost no-one, I haven’t pursued it lately.
>

In Moneydance's stock price importer there is a Test function, which gets
the prices without updating the database. This is to make sure it is all
working, you have the right market and currency. Pressing the test button
twice gives different results, just a minute or two apart. If you adjust it
one way and then test again the result is out by 100x in the opposite
direction! It's like herding cats... Only seems to affect ETFs.

I have downloaded a trial edition of BankTree (http://www.banktree.co.uk)
and it imported the QIF file from Moneydance with just a few warnings about
'Type mismatch'. I've had to fix a few things, like opening balances and
symbols for securities, but it seems to be working.

Thanks for your help and suggestions,

Mark