Bond Prices with new Mkt Value/Shares option

[dlevy]

This is perhaps related to viewtopic.php?f=6&t=3635.

I used the new OFX option to retrieve prices as Market Value divided by shares. Unfortunately, the value (and therefore the price) is divided by 100. This impacts bonds only--treasuries as well as TIPS. Suggestion?

[Mark]

Hi dlevy,

Is the bond price coming in near 1 or 100? Can you take a look at your "xmldump.txt" log file after retrieving from this broker, and show a snippet of that log file for your bond, so I can see how the market value and shares are being reported?

That log file will be in this hidden directory:

C:\Users\<username>\AppData\Roaming\Fund Manager

[dlevy]

Mark,

From the xmldump.txt file, here is one security (a treasury, not a TIP, so no factor):

- POSTYPE (LONG)
- UNITS (100000.0000)
- UNITPRICE (99.2500)
- MKTVAL (99250.00)

Here, units represents face value of the bond and not number of bonds. In the Data Register, the price is given as 0.9925.

And for a TIP:

- POSTYPE (LONG)
- UNITS (100000.0000)
- UNITPRICE (104.9219)
- MKTVAL (120794.49)

and the price in the data register is 1.2079.

Thanks,

David

PS

[Mark]

Hi David,

Thanks for the info. As you can see, FM is simply taking MKTVAL / UNITS and using that as the closing price. It looks like we will need to do something a bit more sophisticated. Since the meaning of UNITS can vary based off the investment type, we could either try to figure out all the investment types and their UNITS meaning. What may be better is to look at the value for UNITPRICE and use this information to help determine the order of magnitude. For your second example, we would compare 1.2079, 12.079, 120.79, and 1207.9 against 104.9219. Since 120.79 is the closest, we would use that scale factor, and record the price as 120.79.

If you'd like to test a pre-release with this change, please let me know.

[dlevy]

Yes, the brokerage system calculates MKTVAL = PRICE * QTY except for fixed income where MKTVAL = PRICE * QTY / 100. I've used ASSET TYPE as "FIXED INCOME" for everything, but I imagine that different users might have classified things in their own way. Equally well I could use a small list of TYPEs or SECTORs to identify fixed income.

Your way would work as well, though it might be safer to look only at the scale factors of 1 and 100.

I'd be happy to test a change pre-release.

David

[Mark]

Hi David,

Okay, please check your email, I've just sent you this pre-release with this improvement.