Search found 18 matches

by just_learning
Sun Jan 03, 2021 8:44 pm
Forum: Investing - Theory, News & General
Topic: TSP share price in Google Sheets like GoogleFinance
Replies: 80
Views: 21150

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 ...
by just_learning
Sun Jan 03, 2021 8:33 pm
Forum: Investing - Theory, News & General
Topic: TSP share price in Google Sheets like GoogleFinance
Replies: 80
Views: 21150

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 :...
by just_learning
Mon Dec 14, 2020 11:10 pm
Forum: Investing - Theory, News & General
Topic: TSP share price in Google Sheets like GoogleFinance
Replies: 80
Views: 21150

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.
by just_learning
Wed Dec 09, 2020 2:25 pm
Forum: Investing - Theory, News & General
Topic: TSP share price in Google Sheets like GoogleFinance
Replies: 80
Views: 21150

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, ...
by just_learning
Sat Dec 05, 2020 10:50 pm
Forum: Personal Investments
Topic: AA for a child
Replies: 11
Views: 1071

Re: AA for a child

Thank you for your replies.
I think I will suggest he read one of the books first.
by just_learning
Fri Dec 04, 2020 11:02 pm
Forum: Personal Investments
Topic: AA for a child
Replies: 11
Views: 1071

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...
by just_learning
Fri Dec 04, 2020 9:08 pm
Forum: Personal Finance (Not Investing)
Topic: Tracking Networth and performance
Replies: 5
Views: 807

Re: Tracking Networth and performance

You could try FundManager.
by just_learning
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...
by just_learning
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...
by just_learning
Wed Sep 02, 2020 7:25 am
Forum: Personal Consumer Issues
Topic: Shopping for college
Replies: 164
Views: 12928

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...
by just_learning
Tue Sep 01, 2020 8:20 pm
Forum: Personal Consumer Issues
Topic: Shopping for college
Replies: 164
Views: 12928

Re: Shopping for college

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.)
....
What impact does money in the parent's 401k, IRA, HSA have? Are they considered as available for college expenses?
by just_learning
Sun Aug 30, 2020 9:02 pm
Forum: Personal Consumer Issues
Topic: Shopping for college
Replies: 164
Views: 12928

Re: Shopping for college

Bobby206 wrote: Sun Aug 30, 2020 8:57 pm
I have heard private schools might negotiate a bit but probably just second tier and below.
How does one negotiate with a college? Call up the admissions office and say I can pay $x...
by just_learning
Sun Aug 30, 2020 8:39 pm
Forum: Personal Consumer Issues
Topic: Shopping for college
Replies: 164
Views: 12928

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...
by just_learning
Sun Aug 30, 2020 8:21 pm
Forum: Personal Consumer Issues
Topic: Shopping for college
Replies: 164
Views: 12928

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 ...
by just_learning
Sun Aug 30, 2020 7:46 pm
Forum: Personal Consumer Issues
Topic: Shopping for college
Replies: 164
Views: 12928

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...
by just_learning
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...
by just_learning
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...