|
|
How often do you mark-to-market?
12-01-2007, 01: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.
|
|
|
|
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!
|
12-01-2007, 01:35 PM
|
#2
|
Thinks s/he gets paid by the post
Join Date: Jun 2006
Posts: 1,703
|
2-3 times per day.
My spreadsheet grabs quotes from yahoo automagically. I only update the bond values when I need an ego boost.
|
|
|
12-01-2007, 01:35 PM
|
#3
|
Full time employment: Posting here.
Join Date: May 2007
Posts: 549
|
Way too much work for me ...I'm retired, ya know?
|
|
|
12-01-2007, 01:37 PM
|
#4
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2005
Location: Chicago
Posts: 13,183
|
Depends on how I want things to look to DW.......
__________________
"I wasn't born blue blood. I was born blue-collar." John Wort Hannam
|
|
|
12-01-2007, 03:50 PM
|
#5
|
Full time employment: Posting here.
Join Date: Feb 2004
Location: Okanagan Valley
Posts: 808
|
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).
|
|
|
12-01-2007, 04:21 PM
|
#6
|
Full time employment: Posting here.
Join Date: Oct 2007
Posts: 642
|
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.
__________________
"Making deliberate choices about how to spend your money and your time is the essence of making the most of your life energy." -Bill Perkins, Die With Zero
"I've traded love for pennies, sold my soul for less" -Jim Croce, Age
|
|
|
12-01-2007, 04:27 PM
|
#7
|
Recycles dryer sheets
Join Date: Jun 2002
Posts: 376
|
Daily after 6:00pm
|
|
|
12-01-2007, 05:49 PM
|
#8
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2006
Posts: 11,401
|
Once a year, on March 31.
|
|
|
12-01-2007, 06:13 PM
|
#9
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 38,140
|
Daily after 6:00pm. Quicken does the download - just one push of a button. Super easy.
Audrey
|
|
|
12-01-2007, 06:38 PM
|
#10
|
Moderator Emeritus
Join Date: May 2007
Posts: 12,901
|
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.
|
|
|
12-01-2007, 11:01 PM
|
#11
|
Recycles dryer sheets
Join Date: Sep 2007
Posts: 155
|
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.
|
|
|
12-01-2007, 11:09 PM
|
#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...
__________________
|
|
|
12-01-2007, 11:13 PM
|
#13
|
Thinks s/he gets paid by the post
Join Date: Jul 2005
Location: Los Angeles area
Posts: 1,708
|
I update most days (just a cut and paste), compile and save quarterly.
__________________
learn, work, save, invest, fire
|
|
|
12-01-2007, 11:34 PM
|
#14
|
Thinks s/he gets paid by the post
Join Date: Feb 2007
Posts: 2,612
|
Weekly update to spreadsheet.
Save annually to compare year-over-year results.
--Rita
__________________
Only got A dimple, would have preferred 2!
|
|
|
12-01-2007, 11:39 PM
|
#15
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: May 2005
Posts: 17,239
|
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.
|
|
|
Do You Have to Have a Spreadsheet?
12-01-2007, 11:45 PM
|
#16
|
Thinks s/he gets paid by the post
Join Date: Feb 2007
Posts: 2,612
|
Do You Have to Have a Spreadsheet?
Quote:
Originally Posted by Texas Proud
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!
|
|
|
12-02-2007, 06:25 AM
|
#17
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Feb 2006
Location: Washington, DC
Posts: 11,327
|
Quote:
Originally Posted by AltaRed
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.
__________________
Idleness is fatal only to the mediocre -- Albert Camus
|
|
|
12-02-2007, 06:27 AM
|
#18
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Feb 2006
Location: Washington, DC
Posts: 11,327
|
How do you do that. It might make more sense than Quicken (the way I use Quicken). Care to post a copy?
__________________
Idleness is fatal only to the mediocre -- Albert Camus
|
|
|
12-02-2007, 06:43 AM
|
#19
|
Recycles dryer sheets
Join Date: Dec 2007
Posts: 482
|
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
|
|
|
12-02-2007, 06: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.
|
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|