Update Municipal Bond Price

[finmanjim]

Hi Mark,

For some reason I cannot update the price of this bond (see attached) from FINRA. I am using the latest FM update.

Thanks.

Jim

[Mark]

Hi Jim,

For FINRA, you have to record the "ticker" value of the URL for the symbol in Fund Manager. It looks like you've recorded the "symbol" instead of the "ticker" as your symbol in your investment. For instructions, see:

https://www.fundmanagersoftware.com/int ... FinraBonds

For example, if you look at the URL for this bond:

http://finra-markets.morningstar.com/Bo ... MMM4131137

You would want to record C668080 as the symbol in your FM investment (not MMM4131137).

[finmanjim]

Hi Mark,

Can you find the FINRA page for the municipal bond that I posted? Your example is for a corporate bond.

I set up my municipal bonds in FM some time ago and it has been working. You have to adjust the properties in FM since there are different "tickers and symbols" used for price retrieval (FINRA) and transaction retrieval (E*Trade).

Thanks.

Jim

[Mark]

Hi Jim,

Transaction retrieval utilizes CUSIP, and price retrieval utilizes Symbol. This enables you to do both transaction and price retrieve without changing properties. Also, if you can't find this bond on Finra, retrieving transactions will update the price with a broker supplied price. To do this, just retrieve transactions, and even if there are no new transactions, finish the transaction import, and your price will be updated by whatever is reported from the broker.

[finmanjim]

Hi Mark,

I discovered why the price retrieval was not working for this municipal bond. There was a reorganization of some type and the CUSIPs changed.

Now I have another question about how to handle this in FM. I own 15 of these bonds. After the reorganization, the investment was split into two groups, one group of 10 bonds and another group of 5 bonds. The bonds in each of these groups have different CUSIPs and the CUSIPs are different from the original lot.

I looked at the Transfer Out | Transfer Between dialogs but not sure if either of those will work.

I appreciate any advice you might have.

Thanks.

Jim

[Mark]

Hi Jim,

You can use the "Spin-Off" wizard. That will create a new spun-off child investment for the new bond with 5 shares. This also records distributions in the parent to account for the child. After the spin-off you will still own 15 shares in the parent. You can then record a split transaction with a ratio of 10 for 15, and then change the name/cusip/etc on the parent to be whatever they are for this new bond you own 10 shares in.

[finmanjim]

Thanks Mark, I will give it a try.

Jim