Actually, I just figured it out. To get PHYS to work in google sheets you now have to use this symbol: NYSEARCA:PHYS

PHYS stopped working for me in google sheets. I tried both PHYS and PHYS.U and neither are working for me. Are other people seeing the same problem? Any solution?

Hello all, I'm surprised there isn't more discussion in this forum regarding the use of high dose vitamin B3, niacin, for mental health benefits. Dr. Abram Hoffer discovered it in the 1950s after the pellagra (niacin deficiency) epidemic that was caused by the introduction of white/refined flour. Af...

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

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

I am 47 years old and retired because I sold my business a few years ago. Not counting my mortgage payment, which includes taxes and insurance, my annual budget is under the safe withdrawal rate of 4%. My mortgage payment, however, puts me at around a 5% withdrawal rate. Obviously, building equity ...

I am 47 years old and retired because I sold my business a few years ago. Not counting my mortgage payment, which includes taxes and insurance, my annual budget is under the safe withdrawal rate of 4%. My mortgage payment, however, puts me at around a 5% withdrawal rate. Obviously, building equity i...

HB talked about the fact that the FDIC is underfunded and insured bank deposits are a bit risky because of that. A law was passed in 2009 that authorized the FDIC to borrow as much as $500 billion from the treasury, as discussed in the article below: https://www.marketwatch.com/story/obama-signs-bil...

So does everyone here agree that if the West changed its interventionist foreign policy to non-interventionism, that the West would run the risk of being overrun by the East, and 50 years from now, Westerners might be speaking Chinese?

The most common criticism of Libertarians I have seen is that their non-interventionist policies would allow other rival powers, such as China or Russia, to grow in influence and to eventually take over much of the globe, greatly weakening the strength of the US and Europe, and ultimately could lead...

Bonds and stocks are going down lately. Gold has been pretty flat. If this trend continues, is gold likely to come to the rescue, even if inflation stays low? Have there been economic scenarios in the past that are similar to what is going on now? If so, how did the PP play out?

How far back does the Yahoo Finance data go? And can you automatically calculate re-balancing using 15/35 bands? Thanks If you use the Vanguard mutual funds you can go back through 1997 (for Gold I did kitco before GLD started in 2006). It will auto calculate re-balancing, but you have to setup the...

InsuranceGuy wrote:I use the SMF add-in for Excel to pull from Yahoo Finance.

How far back does the Yahoo Finance data go? And can you automatically calculate re-balancing using 15/35 bands?

Thanks

Portfolio Visualizer doesn't go all the way back to 1972, does it? How can I re-create peaktotrough.com using Excel? Are there any other options?

I frequently have problems loading bond prices into my google spread sheet. I am using this formula: =importhtml("http://www.wsj.com/mdc/public/page/2_3020-treasury.html", "table", 3) Sometimes, if I change the ,3 to something else like 0, it will work. But I can't get it to work...