Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
How often do you mark-to-market?
Old 12-01-2007, 02:33 PM   #1
Full time employment: Posting here.
 
Join Date: Oct 2007
Location: New York
Posts: 898
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!)
__________________

__________________
Money's just something you need in case you don't die tomorrow.
Maurice is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 12-01-2007, 02:35 PM   #2
Thinks s/he gets paid by the post
twaddle's Avatar
 
Join Date: Jun 2006
Posts: 1,378
2-3 times per day.

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

__________________
twaddle is offline   Reply With Quote
Old 12-01-2007, 02:35 PM   #3
Full time employment: Posting here.
VaCollector's Avatar
 
Join Date: May 2007
Posts: 544
Way too much work for me ...I'm retired, ya know?
__________________
VaCollector is offline   Reply With Quote
Old 12-01-2007, 02:37 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
youbet's Avatar
 
Join Date: Mar 2005
Location: Chicago
Posts: 9,965
Depends on how I want things to look to DW.......
__________________
"I wasn't born blue blood. I was born blue-collar." John Wort Hannam
youbet is offline   Reply With Quote
Old 12-01-2007, 04:50 PM   #5
Full time employment: Posting here.
 
Join Date: Feb 2004
Location: Okanagan Valley
Posts: 805
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).
__________________
AltaRed is offline   Reply With Quote
Old 12-01-2007, 05:21 PM   #6
Recycles dryer sheets
 
Join Date: Oct 2007
Posts: 463
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.
__________________
TickTock Rule Of Finance - heavily discount any promises of money/benefits to be paid to you in the future

"I've traded love for pennies, sold my soul for less" -Jim Croce, Age
TickTock is offline   Reply With Quote
Old 12-01-2007, 05:27 PM   #7
Recycles dryer sheets
 
Join Date: Jun 2002
Posts: 374
Daily after 6:00pm
__________________
Cb is offline   Reply With Quote
Old 12-01-2007, 06:49 PM   #8
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jul 2006
Posts: 11,018
Once a year, on March 31.
__________________
Meadbh is offline   Reply With Quote
Old 12-01-2007, 07:13 PM   #9
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 16,471
Daily after 6:00pm. Quicken does the download - just one push of a button. Super easy.

Audrey
__________________
audreyh1 is offline   Reply With Quote
Old 12-01-2007, 07:38 PM   #10
Moderator Emeritus
 
Join Date: May 2007
Posts: 11,044
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.
__________________
FIREd is online now   Reply With Quote
Old 12-02-2007, 12:01 AM   #11
Recycles dryer sheets
boilerman's Avatar
 
Join Date: Sep 2007
Posts: 82
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.
__________________
boilerman is offline   Reply With Quote
Old 12-02-2007, 12:09 AM   #12
Recycles dryer sheets
 
Join Date: Jul 2007
Posts: 192
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...
__________________

NotSoonEnough is offline   Reply With Quote
Old 12-02-2007, 12:13 AM   #13
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Location: Los Angeles area
Posts: 1,432
I update most days (just a cut and paste), compile and save quarterly.
__________________
learn, work, save, invest, fire
CyclingInvestor is offline   Reply With Quote
Old 12-02-2007, 12:34 AM   #14
Thinks s/he gets paid by the post
Gotadimple's Avatar
 
Join Date: Feb 2007
Posts: 1,761
Weekly update to spreadsheet.

Save annually to compare year-over-year results.

--Rita
__________________
Only got A dimple, would have preferred 2!
Gotadimple is offline   Reply With Quote
Old 12-02-2007, 12:39 AM   #15
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: May 2005
Posts: 13,277
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.
__________________
Texas Proud is offline   Reply With Quote
Do You Have to Have a Spreadsheet?
Old 12-02-2007, 12:45 AM   #16
Thinks s/he gets paid by the post
Gotadimple's Avatar
 
Join Date: Feb 2007
Posts: 1,761
Do You Have to Have a Spreadsheet?

Quote:
Originally Posted by Texas Proud View Post
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
__________________
Only got A dimple, would have preferred 2!
Gotadimple is offline   Reply With Quote
Old 12-02-2007, 07:25 AM   #17
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
donheff's Avatar
 
Join Date: Feb 2006
Location: Washington, DC
Posts: 8,644
Quote:
Originally Posted by AltaRed View Post
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.
__________________
Every man is, or hopes to be, an Idler. -- Samuel Johnson
donheff is offline   Reply With Quote
Old 12-02-2007, 07:27 AM   #18
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
donheff's Avatar
 
Join Date: Feb 2006
Location: Washington, DC
Posts: 8,644
Quote:
Originally Posted by twaddle View Post
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?
__________________
Every man is, or hopes to be, an Idler. -- Samuel Johnson
donheff is offline   Reply With Quote
Old 12-02-2007, 07:43 AM   #19
Recycles dryer sheets
ikubak's Avatar
 
Join Date: Dec 2007
Posts: 391
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.
__________________
Retire date Jan. 10, 2018
ikubak is offline   Reply With Quote
Old 12-02-2007, 07:45 AM   #20
Full time employment: Posting here.
 
Join Date: Oct 2007
Location: New York
Posts: 898
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.
__________________

__________________
Money's just something you need in case you don't die tomorrow.
Maurice is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mark Forums Read error Rich_by_the_Bay Forum Admin 2 10-30-2007 09:44 AM
Mark All Read Khan Forum Admin 3 05-30-2007 09:16 PM
ER - 5 Year Mark Danny Other topics 8 08-03-2006 06:30 PM
Hi, Im Mark.... MSDOGS1976 Hi, I am... 8 02-13-2005 05:44 PM

 

 
All times are GMT -6. The time now is 01:58 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.