Bogleheads.org

The green boxes at the bottom give MY box numbers for my US dollars / international / EM international dollars as I add and subtract (calculations from different page and based on weighted style boxes of each relevant fund) (the little gray numbers below green boxes are reference numbers for non-ti...

Here's my spreadsheet: http://i48.tinypic.com/1zzgzn5.png Only the blue cells are meant to be edited -- everything else is auto-calculated (with the core component being =googlefinance() for price lookups). [img_resize=100:1am89f28]http://i48.tinypic.com/1zzgzn5.png[/img_resize:1am89f28] Nice job...

Enjoyed seeing your spreadsheet design! Very creative and elegant! Hope it helps you better manage your assets. One suggestion: consider using google docs and you will be able to have your fund prices downloaded automatically and save you the manual labor of inputting and also transcription errors....

I would think it depends on whether or not you reinvest them. I don't reinvest, but have my dividends moved to my money market account. So I don't include dividends in my account total. But if you do reinvest, then they would be a part of your total when rebalancing. I reinvest them. Stupid questio...

Another stupid question .. Do you rebalance based on the current total INCLUDING the dividends or NOT INCLUDING the dividends? I would think INCLUDING ....?

I already own VIPSX IN THERE. Just doing a little rebalancing. Haven't really decided on percentages of the various parts of my bond portion of my portfolio but TIPS is down compared to my starting amount so gonna move a little from total bond to TIPS.

Stupid question but .... If I want to exchange 1000 dollars of total bond for TIPS inside my vanguard Roth IRA it doesn't matter which shares I exchange correct? I just click exchange, plug in the info and that's it right? No tax consequences or anything....

Thank You

Congrats. Keep on keepin' on.....

Chan_va wrote:Thanks. I will plan to slowly wade in with VISVX.

Just FYI: You can save 14bps by using the ETF (VBR) instead of the investor shares (VISVX).

To be fair, you can get the admiral shares (same ER as ETF) at 10K as well.....

good luck
-z

empb wrote:Not sure whether you know this but Larry is a prolific poster on this forum under the handle: 'larryswedroe'

cool
-z

Here is a page of videos from "The BAM ALLIANCE."

I really enjoy reading and listening to Larry Swedroe.

http://www.thebamalliance.com/BAMIntell ... genceVideo

Enjoy.

Thank you for sharing this. I enjoy looking over other people's spreadsheet creations to look for ideas and differences. I built one before coming to this site and over the years it has become expansive (yet easy to maintain). I do have a tab dedicated to asset allocation and it is quite similar to...

Not sure why you want it critiqued. Such tools should support decision making, and you are the best judge of how best to support your decisions. Every one is different so you need to make it work for you. In my case the prime decision is where to direct new contributions so I hide a lot of what you...

"Resist the temptation to stretch for yield" - Larry Swedroe

http://seekingalpha.com/article/1081411 ... -for-yield

Here is a page on backdoor ROTH IRA. Read about the pro rata rule. http://www.forbes.com/sites/ashleaebeling/2012/01/23/the-backdoor-roth-ira-advanced-version/ "The barrier to the backdoor Roth—in many folks’ minds—is the pro rata rule. The rule says that you have to aggregate all your IRAs to ...

I'm no expert. Consider backdoor Roth Ira as an option. Others will explain and elaborate I'm sure.
Good luck.

For starters, I'd put the text descriptions in each row instead of numbers, e.g. Row 1 would say "ETF Costs" - it's much easier to read that way. Next, this is a much more complicated view of the cascading asset allocation spreadsheet in the wiki: Using a Spreadsheet to Maintain a Portfol...

I understand the OP is seeking comments on his spreadsheet, not his particular holdings chicagobear. I track my portfolio with Excel, with each mutual fund occupying a separate row, not column. Interesting to see things organized this way though. I like how everything is color-coded as well. For me...

Not sure why you want it critiqued. Such tools should support decision making, and you are the best judge of how best to support your decisions. Every one is different so you need to make it work for you. In my case the prime decision is where to direct new contributions so I hide a lot of what you...

I'm using VBR in taxable (just started adding it). Should I be using tax-managed? Very confusing subject and so many small cap funds/ETFs at vanguard? -z VBR (small-cap value) doesn't have a tax-managed alternative. If your investment strategy requires small-cap value in taxable, then VBR is probab...

I'm using VBR in taxable (just started adding it). Should I be using tax-managed? Very confusing subject and so many small cap funds/ETFs at vanguard?
-z

What is front running?
-z

http://i48.tinypic.com/omd1j.png Here is my portfolio tracking spreadsheet (mac numbers on ipad). Works pretty well for me. Yellow Column - Reits (dont own any yet) Blue Columns - Stocks (US first two, international next 5) ORange Columns - Bonds Black Column - Money Market Account (plan to get thi...