Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Old 09-02-2014, 10:28 PM   #21
Full time employment: Posting here.
gcgang's Avatar
 
Join Date: Sep 2012
Posts: 924
iPad.


Sent from my iPad using Early Retirement Forum
__________________

__________________
In theory, there's no difference between theory and practice. In practice, there is. YB
gcgang 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 09-02-2014, 10:36 PM   #22
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
Without trying to feel that I am back at work (this is E-R.org), make sure you have an Apple account and Google, and search the App Store for Sheets. I just did this and it was there. There is no "purchase" involved (no money).
__________________

__________________

steelyman is offline   Reply With Quote
Old 09-03-2014, 12:51 AM   #23
Full time employment: Posting here.
 
Join Date: Aug 2007
Posts: 892
+1 for Google Sheets.

I migrated all my Excel spreadsheets over a year ago and have no complaints. The GoogleFinance function is way easier than anything Excel supports and the ability to view my spreadsheets on multiple devices is a nice extra. Plus, there's nothing to backup since it's on Google Drive.
__________________
Eat, Drink and Be Merry.
tulak is online now   Reply With Quote
Old 09-03-2014, 06:55 AM   #24
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,638
Quote:
Originally Posted by explanade View Post
Yeah I use a Google spreadsheet that lists all the stocks and funds across all my accounts. Maybe takes up 30-40 rows.

I didn't break them up into separate tabs or workbooks -- which I think is an Excel feature.

So it tallies up each second and then a grand total at the bottom.

The GoogleFinance function is indispensable. There are ways to do updating of securities prices in offline spreadsheets but it seems to be more hassle to set up.
I did the same thing for DW and I. For each fund the spreadsheet calculates current price, YTD gain/loss, percent of portfolio, fund type (for AA), then subtotals by account, then totals for all funds. Below all that I run some rows with AA, year by year spend, and SWR calculations using several approaches just to keep track of where I would be with each. I am tempted to drop the SWR part since I can't really go back to some other approach but will probably wait for a big downturn to see how they diverge. For overall growth I just calculate last year's EOY total against current total (which includes the negative amount of my spending). I recognize that doesn't tell me the actual total return of my combined funds - I will leave that amount of detail to the engineers.

What I like best about the Google sheet is watching the numbers go up after a big up day. I would not recommend regular peeks for risk averse investors since the down days can be eye popping.
__________________
Every man is, or hopes to be, an Idler. -- Samuel Johnson
donheff is offline   Reply With Quote
Old 09-03-2014, 07:14 AM   #25
Thinks s/he gets paid by the post
 
Join Date: May 2008
Posts: 3,418
How do you get YTD info and fund type? Are these special functions or different parameters of GoogleFinance function?
__________________
explanade is online now   Reply With Quote
Old 09-03-2014, 08:25 AM   #26
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,638
Quote:
Originally Posted by explanade View Post
How do you get YTD info and fund type? Are these special functions or different parameters of GoogleFinance function?
I just invented some designators for fund type based on my own assessment I then add up the %of portfolio for all funds in those types for calculating my AA -- basically, it is a manual, subjective calculation. I add up equities and bonds and then break those up by small cap, value, and international. Fairly close but not scientific.

YTD is a GF function -- =GoogleFinance(B7,"returnytd") where B7 is the ticker cell for the fund in row 7. There are other functions I use, like 12 mth distribution yield -- =GoogleFinance(B7,"yieldpct") and 1 yr total return -- =GoogleFinance(B7,"return52"). I look at those to evaluate which funds should be tapped for periodic withdrawals.

The key current price value returned every evening to track portfolio values is -- =GoogleFinance(B7;"closeYest"). Like others, I periodically update the numbers to reflect changes due to distributions. Some people do this automatically but I don't like giving any other sites access to my fund sites so I update manually every few months.

I borrowed the concept from a sheet someone here posted years ago and then modified it to give me what I am interested in.
__________________
Every man is, or hopes to be, an Idler. -- Samuel Johnson
donheff is offline   Reply With Quote
Old 09-03-2014, 09:50 AM   #27
Thinks s/he gets paid by the post
 
Join Date: May 2008
Posts: 3,418
Thanks, I'll check those out.
__________________
explanade is online now   Reply With Quote
Old 09-03-2014, 10:53 AM   #28
Thinks s/he gets paid by the post
Cobra9777's Avatar
 
Join Date: Jul 2012
Location: Texas
Posts: 1,132
Quote:
Originally Posted by donheff View Post
I just invented some designators for fund type based on my own assessment I then add up the %of portfolio for all funds in those types for calculating my AA -- basically, it is a manual, subjective calculation. I add up equities and bonds and then break those up by small cap, value, and international. Fairly close but not scientific.

...I periodically update the numbers to reflect changes due to distributions. Some people do this automatically but I don't like giving any other sites access to my fund sites so I update manually every few months.
This is precisely why I use sites like Personal Capital and Fidelity Full View (with GPS) for basic data accumulation and portfolio analytics. For starters, they always know the correct share count. But more importantly, they dissect each fund down to the individual securities being held for a very precise measurement of asset allocation, performance, yield, expense ratios, duration, sectors, developed vs emerging, etc. For example, you'd be surprised how much cash you're actually holding when you see how much cash each of your funds holds. Of course, I can't spend that at the grocery store, but it does affect performance and thus asset allocation and fund selection decisions.

I think Google Sheets and Excel both have advantages and disadvantages. But my overall point is that spreadsheets in general are better suited for periodic decision support, analysis, modeling, scenario planning, what-if's, etc. Basic real-time data accumulation and categorization is much more efficient and accurate with readily-available, robust tools designed for that specific purpose.

Regarding security, I can remember 10-15 years ago when I wasn't comfortable entering my credit card number on Amazon. We all got past that. I wasn't comfortable with the account aggregation tools until about 2 years ago. So I understand the hesitation. But at some point, you just have to get past that too. On the other hand, if you are a die-hard DIY type who's OK with subjective estimates of AA, then carry on.
__________________
Retired at 52 in July 2013. On to better things...
AA: 55% stock, 15% real estate, 27% bonds, 3% cash
WR: 2.0% SI: 2 pensions, some rental income, SS later
Cobra9777 is offline   Reply With Quote
Old 09-03-2014, 10:57 AM   #29
Thinks s/he gets paid by the post
 
Join Date: May 2008
Posts: 3,418
I don't know the Fidelity Full View. Most of my accounts are with Vanguard, including IRAs that I moved from Fidelity.

I checked out Personal Capital but leery about giving my login data to some external party. And then they apparently look at your portfolio and try to sell you services.
__________________
explanade is online now   Reply With Quote
Old 09-03-2014, 11:05 AM   #30
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
I guess it's about what you are interested in. As I've mentioned in LOL!'s timing thread, I currently just do monthly shifts of funds within an account. The rest of the time I just hang and let the funds or stocks do their thing. I know generally what their stated purposes are.
__________________

steelyman is offline   Reply With Quote
Old 09-03-2014, 11:10 AM   #31
Recycles dryer sheets
 
Join Date: Aug 2013
Posts: 349
Quote:
Originally Posted by steelyman View Post
Here's how I organize my workbooks for tracking investments with Sheets. I have separate workbooks for taxable and retirement accounts.

Each book has a "Summary" sheet that pulls the totals from the other sheets.

Then there is a "Securities" sheet that lists the various investments, names, ticker symbols, and current price (obtained through the GoogleFinance function). This can be referred to by other sheets.

The remaining sheets are specific holdings at different companies (Fidelity, Vanguard, etc.). These are the only things I have to update due to purchases, sales, distributions.and so on.

Otherwise, all I have to do is open the workbook and everything is up-to-date through the magic of Google Sheets.
Any chance you can create a version of them with your personal data removed and share them? It would give some of us less sophisticated types something to start with.
__________________
aim-high is offline   Reply With Quote
Old 09-03-2014, 11:15 AM   #32
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
Quote:
Originally Posted by aim-high View Post
Any chance you can create a version of them with your personal data removed and share them? It would give some of us less sophisticated types something to start with.

I can try, for sure. It's not too complicated. I'll just make up data. I don't know if I can post it to E-R.org, so any tips would help.
__________________

steelyman is offline   Reply With Quote
Old 09-03-2014, 11:25 AM   #33
Recycles dryer sheets
 
Join Date: Aug 2013
Posts: 349
Quote:
Originally Posted by steelyman View Post
I can try, for sure. It's not too complicated. I'll just make up data. I don't know if I can post it to E-R.org, so any tips would help.
1. Make a new folder in your Google Docs. Eg. Call it ERSheets

2. Right click on each of your spreadsheet documents and make a copy of them.

3. Right click on the copies and move them to your ERSheets folder.

4. Edit the sheets to replace your data with fictitious data.

5. Right click on the folder and choose "Share" to share it publicly by changing access to allow "Anyone who has a link" to have view only rights to the folder.

6. Right click again on the folder, choose "Share" and it will give you the link for access to it. You can copy / paste that link here and it should share the file.

If you're uncomfortable sharing it with the world, you can share it with just me, and I can copy them to my aim-high google account and share them. Just PM me the link. I will keep it private.

I don't think there is any risk of losing anonymity by sharing a folder, but just in case I've setup an anonymous gmail acount for such occasions.
__________________
aim-high is offline   Reply With Quote
Old 09-03-2014, 11:27 AM   #34
Thinks s/he gets paid by the post
target2019's Avatar
 
Join Date: Dec 2008
Posts: 3,705
Quote:
Originally Posted by steelyman View Post

I can try, for sure. It's not too complicated. I'll just make up data. I don't know if I can post it to E-R.org, so any tips would help.
If this is Google sheets, copy your existing file and rename. Change all the data. Close it and share to "anybody with the link." don't let everyone have capability to change. You can post the link, or just email it to those you trust.
__________________
target2019 is offline   Reply With Quote
Old 09-03-2014, 11:35 AM   #35
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
OK thanks, aim-high. I will get it done by the end of the weekend.

Anonymity is important to me but I can call out my gangsta friends, the moderators, to lay a hurt on any violators.
__________________

steelyman is offline   Reply With Quote
Old 09-03-2014, 11:40 AM   #36
Thinks s/he gets paid by the post
target2019's Avatar
 
Join Date: Dec 2008
Posts: 3,705
Quote:
Originally Posted by aim-high View Post

1. Make a new folder in your Google Docs. Eg. Call it ERSheets

2. Right click on each of your spreadsheet documents and make a copy of them.

3. Right click on the copies and move them to your ERSheets folder.

4. Edit the sheets to replace your data with fictitious data.

5. Right click on the folder and choose "Share" to share it publicly by changing access to allow "Anyone who has a link" to have view only rights to the folder.

6. Right click again on the folder, choose "Share" and it will give you the link for access to it. You can copy / paste that link here and it should share the file.

If you're uncomfortable sharing it with the world, you can share it with just me, and I can copy them to my aim-high google account and share them. Just PM me the link. I will keep it private.

I don't think there is any risk of losing anonymity by sharing a folder, but just in case I've setup an anonymous gmail acount for such occasions.
Your procedure is excellent.
When sharing I've only used my anonymous Gmail account. That's the best path given a the uncertainty about security.
__________________
target2019 is offline   Reply With Quote
Old 09-03-2014, 11:42 AM   #37
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
What's an anonymous Gmail account? Mine is my name.
__________________

steelyman is offline   Reply With Quote
Old 09-03-2014, 12:17 PM   #38
Thinks s/he gets paid by the post
target2019's Avatar
 
Join Date: Dec 2008
Posts: 3,705
Quote:
Originally Posted by steelyman View Post
What's an anonymous Gmail account? Mine is my name.
If it's Steelyman, then relatively obscure depending on how you've used the account.
If it's Your Name, then not anonymous.
__________________
target2019 is offline   Reply With Quote
Old 09-03-2014, 12:22 PM   #39
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
Quote:
Originally Posted by target2019 View Post
If it's Steelyman, then relatively obscure depending on how you've used the account.
If it's Your Name, then not anonymous.

Well, it's not Steelyman. This is the only barroom I go by that. But I understand what you're saying, thanks!
__________________

steelyman is offline   Reply With Quote
Old 09-03-2014, 12:24 PM   #40
Confused about dryer sheets
 
Join Date: Feb 2007
Posts: 3
You can not password protect Google files
__________________

__________________
frugal_dave 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
Google Drive app & Google Docs steelyman Other topics 19 03-14-2014 05:07 PM
There's No Tracking Like UPS Tracking easysurfer Other topics 60 05-04-2013 02:28 PM
Google Chrome - Google's new web browser Marquette Other topics 22 09-04-2008 03:24 PM
Google launches Google Finance Olav23 FIRE and Money 11 02-08-2008 02:42 PM
Check out the "google" at the top of the google page cute fuzzy bunny Other topics 0 03-17-2006 09:40 PM

 

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