Search found 173 matches

by jason
Thu Jan 02, 2020 10:50 am
Forum: Bonds
Topic: WSJ import into Google sheets stopped working
Replies: 13
Views: 7013

Re: WSJ import into Google sheets stopped working

*bump*
Is anyone able to import Treasury prices into Google sheets? Nothing is working for me now.
by jason
Mon Dec 09, 2019 5:07 pm
Forum: Bonds
Topic: WSJ import into Google sheets stopped working
Replies: 13
Views: 7013

Re: WSJ import into Google sheets stopped working

Hello,
Now the bond prices at treasurydirect.gov are not importing into my google sheet. Is anyone having success with importing Treasury prices into a google sheet? If so, how? Please help!
by jason
Thu Nov 21, 2019 10:48 am
Forum: Bonds
Topic: WSJ import into Google sheets stopped working
Replies: 13
Views: 7013

Re: WSJ import into Google sheets stopped working

I've been reading online how you can extract/scrape data from websites using a Google Apps Script, but I can't figure it out. Does anyone know how to write a script and run it in google sheets? There has got to be a way to get the WSJ data imported into a Google spread sheet. Please help!!
by jason
Thu Oct 03, 2019 12:12 pm
Forum: Bonds
Topic: WSJ import into Google sheets stopped working
Replies: 13
Views: 7013

Re: WSJ import into Google sheets stopped working

Does anyone know if there are other Google sheets functions that can work such as these?
ImportXML
ImportFEED
ImportDATA
by jason
Wed Oct 02, 2019 3:16 pm
Forum: Bonds
Topic: WSJ import into Google sheets stopped working
Replies: 13
Views: 7013

Re: WSJ import into Google sheets stopped working

The pricing data does load into the source code of the URL, so if there is a possibility of somehow parsing the source code and inserting the data into a Google sheet, that would be great. This is way over my head, technically.
by jason
Wed Oct 02, 2019 9:02 am
Forum: Bonds
Topic: WSJ import into Google sheets stopped working
Replies: 13
Views: 7013

WSJ import into Google sheets stopped working

Hello,
I've been importing the US Treasury prices from the Wall Street Journal bond pricing page into my Google sheet for years. It stopped working for me recently. Have other people noticed the same thing? Is there a workaround or alternative source?
Thanks!
by jason
Thu Sep 12, 2019 8:17 pm
Forum: Permanent Portfolio Discussion
Topic: Best resource for PP backtesting?
Replies: 16
Views: 5414

Re: Best resource for PP backtesting?

Kriegsspiel wrote:
Thu Sep 12, 2019 7:28 pm
Yes.
Does portfoliocharts do the 15/35 rebalancing bands?
by jason
Thu Sep 12, 2019 1:34 pm
Forum: Permanent Portfolio Discussion
Topic: Best resource for PP backtesting?
Replies: 16
Views: 5414

Re: Best resource for PP backtesting?

PeaktoTrough.com still works fine for me. But if you're looking for other sources, Portfolio Charts has Permanent Portfolio data going back to 1970. I think the problem with Peaktotrough is that if you try to run it for YTD (Jan 1 2019 through today) no results come up. It does seem to work if I do...
by jason
Mon Aug 26, 2019 9:24 am
Forum: Permanent Portfolio Discussion
Topic: Best resource for PP backtesting?
Replies: 16
Views: 5414

Re: Best resource for PP backtesting?

PeaktoTrough.com still works fine for me. But if you're looking for other sources, Portfolio Charts has Permanent Portfolio data going back to 1970. Great, thanks. I guess I wasn't being patient enough with the Peaktotrough load time because I do see it is working now. Regarding the Portfolio Chart...
by jason
Wed Aug 21, 2019 10:29 am
Forum: Permanent Portfolio Discussion
Topic: Best resource for PP backtesting?
Replies: 16
Views: 5414

Best resource for PP backtesting?

Hello all,
Peaktotrough has been down for a long time now. Is there another resource to do PP backtesting that goes all the way back to 1971?
Thanks!
Jason
by jason
Wed Apr 10, 2019 11:48 am
Forum: Variable Portfolio Discussion
Topic: Best way to budget for mortgage payment?
Replies: 16
Views: 2590

Re: Best way to budget for mortgage payment?

I still don't get why a mortgage payment would be treated like a regular expense line item in a retirement budget. The main difference between making a mortgage payment and paying for a vacation is that if you spend $10K on a vacation, that money is gone forever. You will never get a single penny o...
by jason
Sun Apr 07, 2019 11:11 pm
Forum: Variable Portfolio Discussion
Topic: Best way to budget for mortgage payment?
Replies: 16
Views: 2590

Re: Best way to budget for mortgage payment?

I don't think you should assume that you'll profit from selling your house. Generally, housing prices keep up with inflation but don't do more than that, absent a housing bubble. What most of us do is regard the house as a consumption item. Your home equity figures as part of your net worth, but it...