QIF Import

[Mark]

Hi MikeD,

You should be able to get historical pricing data out of Quicken. There are 2 ways to do this:

1) When you export your QIF file, if you include Transactions, Account List, and Securities your QIF file will include historical pricing information that Fund Manager will import when you import the QIF file. You can open up your QIF file in a text editor, and verify it has pricing. It is normally towards the bottom of the file.

2) A second way to get pricing is to edit the pricing history in Quicken, and you will see a "Print" button in the "Price History" dialog. You can press this button, and will be given the choice of where/how to print. Choose the option to print to a "123 (*.PRN) Disk File. You can then import this pricing data into Fund Manager using "File / Import / Prices / Quicken (*.PRN)...".

You do not have to go through Quicken to get transactions from IB into Fund Manager. You can download either the Quicken or MS Money formatted files from IB, and then import directly into Fund Manager using "File / Import / Transactions / Open Financial Exchange (*.OFX, *.QFX)...".

[MikeD]

Hi, It looks like your program is not importing Option pricing data. The date of a buy or sell is handled correctly, but quotes between transactions are not being annotated. The data is in the QIF file. Here are some samples. Thanks

^
!Type:Prices
"ADBE 100619P00032000",1.422476," 5/ 6'10"
^
!Type:Prices
"ADBE 100619P00032000",1.647883," 5/ 7'10"
^
!Type:Prices
"ADBE 100619P00032000",0.710289," 5/10'10"
^
!Type:Prices
"ADBE 100619P00032000",0.801332," 5/11'10"
^
!Type:Prices
"ADBE 100619P00032000",0.492857," 5/12'10"
^
!Type:Prices
"ADBE 100619P00032000",0.566868," 5/13'10"
^
!Type:Prices
"ADBE 100619P00032000",0.793696," 5/14'10"
^
!Type:Prices
"ADBE 100619P00032000",0.734411," 5/17'10"

[Mark]

Hi MikeD,

I test imported the data you posted below, and it imported correctly. Maybe you don't have the correct symbol recorded in your investment? Do you have an investment with a symbol of:

ADBE 100619P00032000

?

If your QIF file did not contain security information, your symbol may be incorrectly recorded as the "Name" instead of the "Symbol". QIF format uses the investment name in the transaction data, and the security information section has a corresponding symbol for the name. Fund Manager will use that security information to update your symbol if it is present, but if it isn't, it will just default it to the name.

Try updating your investment's symbol, and then import just the pricing information from your QIF file using "File / Import / Prices / Quicken (*.QIF)...".

[MikeD]

I don't understand all of this QIF stuff. Here is some more information:


^
!Type:Security
NADBE 100619P00032000 ADBE 19JUN10 32 P
SADBE 100619P00032000
TOption

^
D5/ 6'10
NBuy
YADBE 100619P00032000 ADBE 19JUN10 32 P
I1.60
Q1,700
Cc
U2,727.58
T2,727.58
O7.58


^
D5/ 6'10
NBuy
YADBE 100619P00032000 ADBE 19JUN10 32 P
I1.60
Q100
Cc
U160.76
T160.76
O0.76


^
!Type:Prices
"ADBE 100619P00032000",1.422476," 5/ 6'10"
^
!Type:Prices
"ADBE 100619P00032000",1.647883," 5/ 7'10"
^
!Type:Prices
"ADBE 100619P00032000",0.710289," 5/10'10"
^
!Type:Prices
"ADBE 100619P00032000",0.801332," 5/11'10"
^
!Type:Prices
"ADBE 100619P00032000",0.492857," 5/12'10"
^
!Type:Prices
"ADBE 100619P00032000",0.566868," 5/13'10"
^
!Type:Prices
"ADBE 100619P00032000",0.793696," 5/14'10"
^
!Type:Prices
"ADBE 100619P00032000",0.734411," 5/17'10"
^
!Type:Prices
"ADBE 100619P00032000",0.91162," 5/18'10"
^
!Type:Prices
"ADBE 100619P00032000",1.08614," 5/19'10"
^
!Type:Prices
"ADBE 100619P00032000",1.773287," 5/20'10"
^
!Type:Prices
"ADBE 100619P00032000",1.38435," 5/21'10"
^
!Type:Prices
"ADBE 100619P00032000",1.520765," 5/24'10"
^
!Type:Prices
"ADBE 100619P00032000",1.462423," 5/25'10"
^
!Type:Prices
"ADBE 100619P00032000",1.699512," 5/26'10"

[MikeD]

There is something going on with how the program is handling the new option naming convention. I have older options that are handled correctly...

[Mark]

Hi MikeD,

This all looks correct. You can see the security name/symbol/type are being shown in the "!Type:Security" section. The transaction is described by name, and the pricing is described by symbol.

If you look at your investment's properties, what do you have for the symbol? It should be: ADBE 100619P00032000 and not: ADBE 100619P00032000 ADBE 19JUN10 32 P. The name should be: ADBE 100619P00032000 ADBE 19JUN10 32 P, and the symbol should be: ADBE 100619P00032000.

If you imported this file containing the security information, and pricing, and it didn't update properly, please email me the whole file (do not post it here). I'll send you an email now, so you can reply to it with an attachment if necessary.

[Mark]

Hi MikeD,

Thanks for sending the file. I found there is a problem in Fund Manager. It is because there are 2 adjacent spaces in the symbol. Fund Manager was compressing these to a single space when trying to clean things up for the price import. This will be fixed for the next release. I can send you a pre-release of the next version with this fix. What version are you using? Personal, Professional, or Advisor?

[MikeD]

Thanks alot.... It looks like all of the data is imported and correct.

[Mark]

Excellent. Glad that fixed it. Thanks for pointing out this problem.

[MikeD]

Looks like I have run across something else that looks a little weird. The Stacked Value Investment chart doesn't look right. Using that same QIF file, Apple doesn't show up in the chart until the Feb time frame. It should be there from the beginning.

Thanks

[Mark]

Hi MikeD,

Look at your Apple investment, and check the value for the date(s) in question. If it is wrong, look at why it is wrong. Do you have all the recorded transactions? Are one or more of your closing prices wrong? The value of an investment is simply the number of shares owned times the market price. The number of shares owned is a sum of all recorded transactions up to that date. Knowing this, you can figure out what is not as expected.

[MikeD]

It looks like the "Stacked Value Investment" graph is not right. If I look at the value of Apple on 1/4/10 in the data register it is correct......

Thanks

[Mark]

Hi MikeD,

Why don't you give me a call at 480-705-0129, and I'll connect into your computer, and we can take a look together.