*bump*
Is anyone able to import Treasury prices into Google sheets? Nothing is working for me now.

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!

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!!

Does anyone know if there are other Google sheets functions that can work such as these?
ImportXML
ImportFEED
ImportDATA

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.

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!

Kriegsspiel wrote: ↑

Thu Sep 12, 2019 7:28 pm

Yes.

Does portfoliocharts do the 15/35 rebalancing bands?

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

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

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

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

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