Early Retirement & Financial Independence Community

Early Retirement & Financial Independence Community (http://www.early-retirement.org/forums/)
-   FIRE and Money (http://www.early-retirement.org/forums/f28/)
-   -   How often do you mark-to-market? (http://www.early-retirement.org/forums/f28/how-often-do-you-mark-to-market-31621.html)

Maurice 12-01-2007 01:33 PM

How often do you mark-to-market?
 
How often do you formally mark your portfolio to market and update all your spreadsheets?

I do it at the end of each month. I enter closing prices of each position, the new # of shares if its a fund that reinvests, new FX rates, and the principal paid on my mortgage. My spreadsheet then calculates my net worth, my actual asset allocation, differences in $ and % between my actual and target allocations, and $ and % gain/loss for the month and for the year.

(By the way, November was a really bad month!)

twaddle 12-01-2007 01:35 PM

2-3 times per day. :)

My spreadsheet grabs quotes from yahoo automagically. I only update the bond values when I need an ego boost. :)

VaCollector 12-01-2007 01:35 PM

Way too much work for me :coolsmiley: ...I'm retired, ya know?

youbet 12-01-2007 01:37 PM

Depends on how I want things to look to DW.......

AltaRed 12-01-2007 03:50 PM

I use Quicken. I generally update security prices at the end of each week with a click on the Update button (an update Friday night or Saturday will capture all 5 previous business days). I prefer not to electronically download data from brokers and banks because I prefer to have the transactions appear as I want them to look. Thus I generally enter transaction activity once a week as well (or when monthly statements are available).

TickTock 12-01-2007 04:21 PM

Once year, right before rebalancing. I keep a snapshot of portfolio before and after rebalance.

Usually a couple times a year I'll 'cheat' and quickly total the portfolio, but not really do more than glance at individual asset classes. Takes maybe five minutes.

Of course, I'm still in the accumulation phase.

Cb 12-01-2007 04:27 PM

Daily after 6:00pm

Meadbh 12-01-2007 05:49 PM

Once a year, on March 31.

audreyh1 12-01-2007 06:13 PM

Daily after 6:00pm. Quicken does the download - just one push of a button. Super easy.

Audrey

FIREd 12-01-2007 06:38 PM

I track our stock/bond portfolio on a daily basis (Quicken).
I compute our networth once a month (on the 15th) using the most up-to-date asset values I have. I enter the numbers in a spreadsheet holding data going back several years. It calculates my networth, asset allocation and a bunch of other things. It also allows me to track our progress. I also have a plot showing the progression of our NW over the past 6 years.
Usually I mark RE assets to market only once a year on Jan15.

boilerman 12-01-2007 11:01 PM

Once a year (Jan 1) I update all portfolio values in a spreadsheet to compare against the plan. I do informally track the values in the yahoo finance portfolio feature and look at it every day or so.

NotSoonEnough 12-01-2007 11:09 PM

It depends, if the market is up, I update daily. If it is headed down, maybe once a week. Lately, with all the churning, not at all...

CyclingInvestor 12-01-2007 11:13 PM

I update most days (just a cut and paste), compile and save quarterly.

Gotadimple 12-01-2007 11:34 PM

Weekly update to spreadsheet.

Save annually to compare year-over-year results.

--Rita

Texas Proud 12-01-2007 11:39 PM

Do you have to have a spreadsheet to give and answer???

If yes, then I don't update as I don't have any spreadsheet...

If no, then once a month I update my Vanguard account with all my other accounts.

Gotadimple 12-01-2007 11:45 PM

Do You Have to Have a Spreadsheet?
 
Quote:

Originally Posted by Texas Proud (Post 583769)
Do you have to have a spreadsheet to give and answer???

If yes, then I don't update as I don't have any spreadsheet...

If no, then once a month I update my Vanguard account with all my other accounts.

Actually, you don't. You can register at M* and use their online site to monitor all you investments. It's ALMOST the same thing -- of course you don't get a lot of choice in the columns you can see. But all the pertinent info is there.

-- Rita

donheff 12-02-2007 06:25 AM

Quote:

Originally Posted by AltaRed (Post 583662)
I use Quicken. I generally update security prices at the end of each week with a click on the Update button (an update Friday night or Saturday will capture all 5 previous business days). I prefer not to electronically download data from brokers and banks because I prefer to have the transactions appear as I want them to look. Thus I generally enter transaction activity once a week as well (or when monthly statements are available).

Same here. I don't download transactions - I am paranoid about having an application like Quicken or site like Yahoo have account access.

donheff 12-02-2007 06:27 AM

Quote:

Originally Posted by twaddle (Post 583615)
2-3 times per day. :)

My spreadsheet grabs quotes from yahoo automagically. I only update the bond values when I need an ego boost. :)

How do you do that. It might make more sense than Quicken (the way I use Quicken). Care to post a copy?

ikubak 12-02-2007 06:43 AM

I use Quicken and I usually update at the end of each day. I used to do it manually and I can tell you that the automatic update is a wonderful thing.

Maurice 12-02-2007 06:45 AM

I'm also interested in the auto-download from yahoo into excel.

I find I need to use spreadsheets because the account consolidators have limited flexibility. Its hard to enter FX, private equity, non-marketable (144a) securities, etc.

Also, I like flexibility in my reporting, for example, tracking vested vs. non-vested assets, tying in my mortgage balance, reporting drift from target allocations, etc.

I do occasionally update my spreadsheet intra-month but those values will get written over at the end of the month. I keep one spreadsheet file for each year, with a tab (worksheet) for each month of the year. In the new year, I make a copy and start again.


All times are GMT -6. The time now is 02:59 PM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2018, vBulletin Solutions, Inc.