Search found 18 matches
- Sun Jan 03, 2021 8:44 pm
- Forum: Investing - Theory, News & General
- Topic: TSP share price in Google Sheets like GoogleFinance
- Replies: 80
- Views: 21080
Re: TSP share price in Google Sheets like GoogleFinance
From the looks of it, "+1" will break on 3 day weekends, or more generally when the market is closed for 3 or more consecutive days over the last 5 days... It should fix itself once the market reopens... it is fixable with the use of a little more logic, which I hope someone will take up ...
- Sun Jan 03, 2021 8:33 pm
- Forum: Investing - Theory, News & General
- Topic: TSP share price in Google Sheets like GoogleFinance
- Replies: 80
- Views: 21080
Re: TSP share price in Google Sheets like GoogleFinance
From the looks of it, "+1" will break on 3 day weekends, or more generally when the market is closed for 3 or more consecutive days over the last 5 days... It should fix itself once the market reopens... it is fixable with the use of a little more logic, which I hope someone will take up :...
- Mon Dec 14, 2020 11:10 pm
- Forum: Investing - Theory, News & General
- Topic: TSP share price in Google Sheets like GoogleFinance
- Replies: 80
- Views: 21080
Re: TSP share price in Google Sheets like GoogleFinance
To answer myself, I ended up doing something like this-
https://www.vertex42.com/ExcelTemplates ... uotes.html
Published a google sheet on the cloud with public data and then imported the info from sheets into my private excel spreadsheet on the laptop.
https://www.vertex42.com/ExcelTemplates ... uotes.html
Published a google sheet on the cloud with public data and then imported the info from sheets into my private excel spreadsheet on the laptop.
- Wed Dec 09, 2020 2:25 pm
- Forum: Investing - Theory, News & General
- Topic: TSP share price in Google Sheets like GoogleFinance
- Replies: 80
- Views: 21080
Re: TSP share price in Google Sheets like GoogleFinance
Hello, Do you all save all your financial assets information on google, in the cloud? Or is there a way to keep it locally and view/manage the local copy? I prefer to not have it on the cloud... I tried to download the Excel version of the Sheets document and manipulate it using Excel on my laptop, ...
- Sat Dec 05, 2020 10:50 pm
- Forum: Personal Investments
- Topic: AA for a child
- Replies: 11
- Views: 1068
Re: AA for a child
Thank you for your replies.
I think I will suggest he read one of the books first.
I think I will suggest he read one of the books first.
- Fri Dec 04, 2020 11:02 pm
- Forum: Personal Investments
- Topic: AA for a child
- Replies: 11
- Views: 1068
AA for a child
Hello, My nephew received a gift from his grandma and his parents were wondering how to invest it. The kid being young (15), I was considering to suggest to them, an all stock portfolio- 20% S&P 20% US small cap 20% QQQ 20% Intl stock 20% Emerging market stock I haven't looked up how much of the...
- Fri Dec 04, 2020 9:08 pm
- Forum: Personal Finance (Not Investing)
- Topic: Tracking Networth and performance
- Replies: 5
- Views: 806
Re: Tracking Networth and performance
You could try FundManager.
- Mon Sep 07, 2020 9:17 am
- Forum: Personal Consumer Issues
- Topic: Personal spreadsheet for college decisions
- Replies: 9
- Views: 906
- Sat Sep 05, 2020 4:44 pm
- Forum: Personal Consumer Issues
- Topic: Personal spreadsheet for college decisions
- Replies: 9
- Views: 906
Re: Personal spreadsheet for college decisions
Someone asked me about this in another thread, so I thought I'd bore everyone to tears. We had an extensive, 44 column spreadsheet for gathering data and tracking status for colleges. We included 98 schools, every one that seriously attracted our eye, or sent mail or email. I've rated the columns w...
- Fri Sep 04, 2020 8:15 pm
- Forum: Personal Consumer Issues
- Topic: Personal spreadsheet for college decisions
- Replies: 9
- Views: 906
Re: Personal spreadsheet for college decisions
Someone asked me about this in another thread, so I thought I'd bore everyone to tears. We had an extensive, 44 column spreadsheet for gathering data and tracking status for colleges. We included 98 schools, every one that seriously attracted our eye, or sent mail or email. I've rated the columns w...
- Wed Sep 02, 2020 7:25 am
- Forum: Personal Consumer Issues
- Topic: Shopping for college
- Replies: 164
- Views: 12612
Re: Shopping for college
family income approximate total assets outside 401k and other tax advantaged vehicles like pension/ira/hsa/etc nationality (Asian/Hispanic/Caucasian/etc.) .... What impact does money in the parent's 401k, IRA, HSA have? Are they considered as available for college expenses? 401K and IRA are not rep...
- Tue Sep 01, 2020 8:20 pm
- Forum: Personal Consumer Issues
- Topic: Shopping for college
- Replies: 164
- Views: 12612
Re: Shopping for college
What impact does money in the parent's 401k, IRA, HSA have? Are they considered as available for college expenses?fwellimort wrote: ↑Mon Aug 31, 2020 6:59 pm family income
approximate total assets outside 401k and other tax advantaged vehicles like pension/ira/hsa/etc
nationality (Asian/Hispanic/Caucasian/etc.)
....
- Sun Aug 30, 2020 9:02 pm
- Forum: Personal Consumer Issues
- Topic: Shopping for college
- Replies: 164
- Views: 12612
- Sun Aug 30, 2020 8:39 pm
- Forum: Personal Consumer Issues
- Topic: Shopping for college
- Replies: 164
- Views: 12612
Re: Shopping for college
There are a couple of ways for 6 figure families to get help. Some of the best endowed colleges (Harvard, Stanford, etc) are very generous with financial aid. Harvard is free if the family makes under 80K, 10% of income between 80-150K, with continued possibilities up to 200K. For one of my kids, o...
- Sun Aug 30, 2020 8:21 pm
- Forum: Personal Consumer Issues
- Topic: Shopping for college
- Replies: 164
- Views: 12612
Re: Shopping for college
Good timing on this question because something like this came up when we were discussing a friend's child's admission... When people refer to "scholarships" and "merit scholarships", are these need based or need blind? If a family is making say, 200k a year, can they expect any ...
- Sun Aug 30, 2020 7:46 pm
- Forum: Personal Consumer Issues
- Topic: Shopping for college
- Replies: 164
- Views: 12612
Re: Shopping for college
Good timing on this question because something like this came up when we were discussing a friend's child's admission... When people refer to "scholarships" and "merit scholarships", are these need based or need blind? If a family is making say, 200k a year, can they expect any n...
- Wed Aug 21, 2019 6:58 pm
- Forum: Personal Investments
- Topic: Good time to implement plan?
- Replies: 6
- Views: 453
Good time to implement plan?
Hello, A friend has investments that are roughly 35/65 (stock/bonds+CDs). I have prodded him to make a plan and pointed him to resources on this website. He would like the split to be 65/35 or 60/40 (stock/bond+CD). Question- Although he would like to get the ratio in line with what he would like it...
- Sat Aug 03, 2019 3:23 pm
- Forum: Personal Finance (Not Investing)
- Topic: Accounting for currency loss when filing taxes
- Replies: 0
- Views: 340
Accounting for currency loss when filing taxes
Hello. Long time lurker. I looked around some on the boards and didn't find anything useful regarding the below... I am trying to figure out how to account, while filing taxes, for currency losses accrued due to an investment made outside the country. Here is the scenario- 1. I send $100 to anther c...