*bump*
Is anyone able to import Treasury prices into Google sheets? Nothing is working for me now.
Search found 248 matches
- Thu Jan 02, 2020 10:50 am
- Forum: Bonds
- Topic: WSJ import into Google sheets stopped working
- Replies: 16
- Views: 18114
- Mon Dec 09, 2019 5:07 pm
- Forum: Bonds
- Topic: WSJ import into Google sheets stopped working
- Replies: 16
- Views: 18114
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!
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!
- Thu Nov 21, 2019 10:48 am
- Forum: Bonds
- Topic: WSJ import into Google sheets stopped working
- Replies: 16
- Views: 18114
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!!
- Thu Oct 03, 2019 12:12 pm
- Forum: Bonds
- Topic: WSJ import into Google sheets stopped working
- Replies: 16
- Views: 18114
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
ImportXML
ImportFEED
ImportDATA
- Wed Oct 02, 2019 3:16 pm
- Forum: Bonds
- Topic: WSJ import into Google sheets stopped working
- Replies: 16
- Views: 18114
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.
- Wed Oct 02, 2019 9:02 am
- Forum: Bonds
- Topic: WSJ import into Google sheets stopped working
- Replies: 16
- Views: 18114
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!
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!
- Thu Sep 12, 2019 8:17 pm
- Forum: Permanent Portfolio Discussion
- Topic: Best resource for PP backtesting?
- Replies: 17
- Views: 13713
Re: Best resource for PP backtesting?
Does portfoliocharts do the 15/35 rebalancing bands?
- Thu Sep 12, 2019 1:34 pm
- Forum: Permanent Portfolio Discussion
- Topic: Best resource for PP backtesting?
- Replies: 17
- Views: 13713
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...
- Mon Aug 26, 2019 9:24 am
- Forum: Permanent Portfolio Discussion
- Topic: Best resource for PP backtesting?
- Replies: 17
- Views: 13713
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...
- Wed Aug 21, 2019 10:29 am
- Forum: Permanent Portfolio Discussion
- Topic: Best resource for PP backtesting?
- Replies: 17
- Views: 13713
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
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
- Wed Apr 10, 2019 11:48 am
- Forum: Variable Portfolio Discussion
- Topic: Best way to budget for mortgage payment?
- Replies: 15
- Views: 8887
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...
- Sun Apr 07, 2019 11:11 pm
- Forum: Variable Portfolio Discussion
- Topic: Best way to budget for mortgage payment?
- Replies: 15
- Views: 8887
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...
- Sat Apr 06, 2019 7:16 am
- Forum: Variable Portfolio Discussion
- Topic: Best way to budget for mortgage payment?
- Replies: 15
- Views: 8887
Re: Best way to budget for mortgage payment?
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 ...
- Thu Apr 04, 2019 9:00 pm
- Forum: Variable Portfolio Discussion
- Topic: Best way to budget for mortgage payment?
- Replies: 15
- Views: 8887
Best way to budget for mortgage payment?
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...
FDIC risk
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...
- Wed Aug 01, 2018 1:14 pm
- Forum: Other Discussions
- Topic: Interventionism versus non-interventionism
- Replies: 43
- Views: 19820
Re: Interventionism versus non-interventionism
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?
- Tue Jul 31, 2018 4:06 pm
- Forum: Other Discussions
- Topic: Interventionism versus non-interventionism
- Replies: 43
- Views: 19820
Interventionism versus non-interventionism
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...
- Thu Feb 08, 2018 2:21 pm
- Forum: Permanent Portfolio Discussion
- Topic: Is the PP going to hold up?
- Replies: 114
- Views: 59267
Is the PP going to hold up?
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?
- Fri Jan 19, 2018 2:24 pm
- Forum: Permanent Portfolio Discussion
- Topic: Alternatives to peaktotrough.com?
- Replies: 6
- Views: 5136
Re: Alternatives to peaktotrough.com?
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...
- Wed Jan 17, 2018 10:23 pm
- Forum: Permanent Portfolio Discussion
- Topic: Alternatives to peaktotrough.com?
- Replies: 6
- Views: 5136
Re: Alternatives to peaktotrough.com?
How far back does the Yahoo Finance data go? And can you automatically calculate re-balancing using 15/35 bands?InsuranceGuy wrote:I use the SMF add-in for Excel to pull from Yahoo Finance.
Thanks
- Tue Jan 16, 2018 2:30 pm
- Forum: Permanent Portfolio Discussion
- Topic: Alternatives to peaktotrough.com?
- Replies: 6
- Views: 5136
Re: Alternatives to peaktotrough.com?
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?
- Tue Jan 02, 2018 12:34 pm
- Forum: Bonds
- Topic: Google sheets and WSJ bond prices
- Replies: 2
- Views: 5745
Google sheets and WSJ bond prices
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...
- Tue Jan 02, 2018 12:31 pm
- Forum: Permanent Portfolio Discussion
- Topic: Re-balance instantly or wait a little while?
- Replies: 23
- Views: 15293
Re: Re-balance instantly or wait a little while?
I did not pull the trigger in 2017 to re-balance. Now, in 2018, my stocks are not over 35% anymore. So should I wait until it hits 35% again before re-balancing? I know HB said to only check the account around once a year so if I had not been checking it, I would not have known it had temporarily mo...
- Wed Dec 27, 2017 4:54 pm
- Forum: Permanent Portfolio Discussion
- Topic: Re-balance instantly or wait a little while?
- Replies: 23
- Views: 15293
Re: Re-balance instantly or wait a little while?
Jason, Are you making $470,701 and over for married-filing-jointly? Is that why your long-term cap gains tax rate is 20%? If so, just be thankful that you have such a problem, rebalance your portfolio and pay the damn tax. For people making below that, there is no 20% capital gains tax rate. Look a...
- Mon Dec 11, 2017 3:20 pm
- Forum: Permanent Portfolio Discussion
- Topic: How much is "enough" in the Permanent Portfolio?
- Replies: 33
- Views: 20873
Re: How much is "enough" in the Permanent Portfolio?
I agree that based on the historical PP data, a 4% SWR is safe for retirement. But if it's in a taxable account, the taxes will come out of the 4%. For example, if someone has a PP with $6 million in it, they can safely take out $240,000 per year, but taxes will apply to that $240,000. So, how does...