Page 1 of 1

Do All brokerages Mark Bonds to Market?

Posted: Sat Sep 25, 2010 9:58 pm
by MiniB
When I start my PP I will be holding individual treasuries.  Probably at Schwab but maybe at Vanguard.  Do all brokerages mark my holdings to market each day?  That would be really nice to be able to calculate how much what I have it worth on a daily basis for purposes of rebalancing.  I wont be checking daily, but when I do check, I dont want to have to do calculations.

Re: Do All brokerages Mark Bonds to Market?

Posted: Sun Sep 26, 2010 10:08 am
by MediumTex
I assume all brokerages do.  Vanguard does.

Re: Do All brokerages Mark Bonds to Market?

Posted: Sun Sep 26, 2010 10:38 am
by MCSquared
MiniB wrote: When I start my PP I will be holding individual treasuries.  Probably at Schwab but maybe at Vanguard.  Do all brokerages mark my holdings to market each day?  That would be really nice to be able to calculate how much what I have it worth on a daily basis for purposes of rebalancing.  I wont be checking daily, but when I do check, I dont want to have to do calculations.
Fidelity updates treasury holdings.  I use a google doc that does the same thing though.

Re: Do All brokerages Mark Bonds to Market?

Posted: Sun Sep 26, 2010 2:23 pm
by MiniB
MCSquared wrote: Fidelity updates treasury holdings.  I use a google doc that does the same thing though.
How do you do it in google doc?

I assume you need to input a formula that takes into account the maturity and yield compared to the day's date and current market yield.  I think you can pull that data into Excel so you don't have to manually type it in everyday.

Re: Do All brokerages Mark Bonds to Market?

Posted: Mon Sep 27, 2010 6:24 am
by MCSquared
MiniB wrote:
MCSquared wrote: Fidelity updates treasury holdings.  I use a google doc that does the same thing though.
How do you do it in google doc?

I assume you need to input a formula that takes into account the maturity and yield compared to the day's date and current market yield.  I think you can pull that data into Excel so you don't have to manually type it in everyday.
I use a formula but I do not pull the data into the spreadsheet daily.  I load the current yield maybe once a week for price calculation.  Here is a sample doc.  You can obviously ignore the calcs for bonds with call options etc.

https://spreadsheets.google.com/ccc?key ... y=COTeg6UK

Re: Do All brokerages Mark Bonds to Market?

Posted: Mon Sep 27, 2010 6:27 pm
by doug6zj9
MiniB wrote:     Do all brokerages mark my holdings to market each day? 
Schwab does at end of day.  (It IS fun to watch etfs though which update instantly and constantly)