Search found 104 matches

by GLState
Fri May 26, 2017 10:29 am
Forum: Investing - Help with Personal Investments
Topic: Vanguard vs higher cost bond funds
Replies: 10
Views: 823

Re: Vanguard vs higher cost bond funds

If you look at the PTRQX asset allocation on Morningstar you'll see that its bond holdings are 181.51% long, 85.98% short, for a net of 95.82% bonds. In the past, PTRQX has been "worth it" if return is your only concern. PTRQX is a "Total Return" bond fund, which has different goals than a "Total Bo...
by GLState
Thu May 25, 2017 7:49 pm
Forum: Investing - Help with Personal Investments
Topic: Index's Holding Cash? Why?
Replies: 7
Views: 1107

Re: Index's Holding Cash? Why?

It looks like PTTRX is shorting cash and bonds they don't like to buy more bonds that they do like. Personal capital must just be showing net...Morningstar shows short and long positions. edit: PTTRX is short 38.42% Cash and Net 138.17% Bonds (210.64% long, 72.47 short). http://beta.morningstar.com/...
by GLState
Thu May 25, 2017 3:00 pm
Forum: Investing - Theory, News & General
Topic: Boglehead Portfolio vs. All Other Possible Investments
Replies: 74
Views: 7377

Re: Boglehead Portfolio vs. All Other Possible Investments

Hmm, interesting. But, let's say that I had created a portfolio containing these top-performing companies + 40% total bond fund, and held that portfolio for 40 years. Would the risk-adjusted returns (as measured, let's say, by the Sharpe ratio) have been as good as, or better, than a 60/40 Boglehea...
by GLState
Thu May 25, 2017 2:55 pm
Forum: Investing - Theory, News & General
Topic: Boglehead Portfolio vs. All Other Possible Investments
Replies: 74
Views: 7377

Re: Boglehead Portfolio vs. All Other Possible Investments

Index investors know that we will never have the "best" returns, risk adjusted or not. There will always be an asset class or asset will have a higher return than our portfolio. We are content to share in the growth of the world economy by owning most of the corporations in the world. We'd likely ha...
by GLState
Wed May 24, 2017 3:23 pm
Forum: Investing - Theory, News & General
Topic: Convenient listing of additions and removals of companies in international indices?
Replies: 7
Views: 722

Re: Convenient listing of additions and removals of companies in international indices?

OK I will bite. I don't know if there is an official site but here is what I do. Because I am a world stock investor, I keep a spreadsheet which lists all the companies I own and how many dollars I have invested in them. Why? I don't worry about countries but when random news happens e.g. VW diesel...
by GLState
Mon May 22, 2017 5:46 pm
Forum: Investing - Theory, News & General
Topic: yahoo finance - adjusted price data incorrect?
Replies: 63
Views: 9725

Re: yahoo finance - adjusted price data incorrect?

The yahoo data has changed and it doesn't look like it will be back as we knew it. In the one of the Yahoo support forums, a mod responded: Nixon Official 'Hoo Staff Nixon Official 'Hoo Staff ‎05-17-2017 02:59 PM Re: Is Yahoo! Finance API broken? Hi All - This feature was discontinued by the Finance...
by GLState
Sun May 21, 2017 9:38 am
Forum: Investing - Theory, News & General
Topic: Home Country Bias...makes sense?
Replies: 235
Views: 12814

Re: Home Country Bias...makes sense?

The "boglehead way" advocates investing in the Total Stock Market without regard to the political and economic climate. We hold the whole market without attempting to weed out "bad" stocks or sectors from the "good". We don't make buy and sell decisions based on past performance. Why shouldn't these...
by GLState
Sat May 20, 2017 8:10 am
Forum: Investing - Theory, News & General
Topic: MarketWatch "Lazy Portfolios"
Replies: 10
Views: 2197

Re: MarketWatch "Lazy Portfolios"

The 2nd Grader's portfolio on MarketWatch is a three fund portfolio but it is not THE three fund portfolio. According to this boglehead page, https://www.bogleheads.org/wiki/Three-fund_portfolio , Taylor Larimore's Three Fund Portfolio is equal weight. "Vanguard funds From Vanguard's list of "core f...
by GLState
Thu May 18, 2017 3:13 pm
Forum: Investing - Help with Personal Investments
Topic: Vangaurd ETF Live NAV?
Replies: 17
Views: 809

Re: Vangaurd ETF Live NAV?

Am I missing something, or is there not a way to compare Bid-Ask pricing live to determine if there is a premium or discount? I'm not sure how "live" it is, but Morningstar shows bid/ask spread along with discount/premium. The TDAmeritrade thinkorswim platform shows bid/ask spread can get the IV fo...
by GLState
Thu May 18, 2017 1:34 pm
Forum: Personal Finance (Not Investing)
Topic: Google Finance Ticker Symbol to Monitor Oil Price and CPI-U
Replies: 1
Views: 458

Re: Google Finance Ticker Symbol to Monitor Oil Price and CPI-U

There aren't ticker symbols for everything that you might want to track. CPI-U and WTI Crude price histories are available on the FRED web site (St. Louis FED) or Quandl. This data could be added to a Google Sheet after downloading. https://fred.stlouisfed.org/series/CPIAUCSL https://fred.stlouisfed...
by GLState
Thu May 18, 2017 10:20 am
Forum: Investing - Help with Personal Investments
Topic: Asset Allocation Re-balancing Math: Help Needed
Replies: 3
Views: 384

Re: Asset Allocation Re-balancing Math: Help Needed

Combine the values of both accounts. Then multiply the desired allocation for each symbol by the total dollar amount. If you have a total of $10000 in both accounts, your rebalancing targets would be as below: VBMPX 0.200 $2,000.00 VIIIX 0.486 $4,860.00 VMCPX 0.024 $240.00 VSCPX 0.090 $900.00 SWISX ...
by GLState
Wed May 17, 2017 9:14 am
Forum: Investing - Theory, News & General
Topic: yahoo finance - adjusted price data incorrect?
Replies: 63
Views: 9725

Re: yahoo finance - adjusted price data incorrect?

However, if you use the download button to grab a CSV file the issue goes away. You get the adjusted prices. Thanks. I had given up on using Yahoo since it didn't appear that they were providing the adjusted price. I'll download instead. Yahoo still gives an "adjusted price" but it is no longer adj...
by GLState
Wed May 17, 2017 7:20 am
Forum: Investing - Theory, News & General
Topic: yahoo finance - adjusted price data incorrect?
Replies: 63
Views: 9725

Re: Yahoo downloads not working. Changes to yahoo's API

As I understand it, a few weeks ago yahoo switched from http to https. They have now changed the historic data download url. R's quantmod developer is working on a fix. Likely, there will also be fixes forthcoming for Python datareader. Excel macro users will have to edit their macros.
by GLState
Tue May 16, 2017 7:29 pm
Forum: Investing - Theory, News & General
Topic: yahoo finance - adjusted price data incorrect?
Replies: 63
Views: 9725

Re: yahoo finance - adjusted price data incorrect?

This evening, I can't download any Yahoo stock or fund prices into Excel, Python, or R. Hopefully just a short-term problem. Downloading prices from google into R works ok.
by GLState
Tue May 16, 2017 9:39 am
Forum: Investing - Theory, News & General
Topic: yahoo finance - adjusted price data incorrect?
Replies: 63
Views: 9725

Re: yahoo finance - adjusted price data incorrect?

And so ... are you saying that the Adjusted Price in the CSV file depends on the starting date of the data in the CSV file? [Also note that the the CSV file is sorted now on date in opposite way than last year. And downloaded file seems to have "-2" at end of name perhaps to indicate a change in th...
by GLState
Tue May 16, 2017 8:07 am
Forum: Investing - Theory, News & General
Topic: yahoo finance - adjusted price data incorrect?
Replies: 63
Views: 9725

Re: yahoo finance - adjusted price data incorrect?

from investopedia: "An adjusted closing price is a stock's closing price on any given day of trading that has been amended to include any distributions and corporate actions that occurred at any time prior to the next day's open. The adjusted closing price is often used when examining historical ret...
by GLState
Tue May 16, 2017 7:49 am
Forum: Investing - Theory, News & General
Topic: yahoo finance - adjusted price data incorrect?
Replies: 63
Views: 9725

Re: yahoo finance - adjusted price data incorrect?

Do you have a specific example?

Adjusted Close IBM...

edit: This is not correct either

Code: Select all

May 08, 2017	152.80	153.47	152.20	153.03	153.03	7,492,000
May 08, 2017	1.5 Dividend
May 05, 2017	153.52	155.78	153.00	155.05	155.05	12,521,300
by GLState
Fri May 12, 2017 11:11 am
Forum: Investing - Theory, News & General
Topic: Anyone use Python to analyze their finances?
Replies: 40
Views: 7355

Re: Anyone use Python to analyze their finances?

With these two lines of code in R: library(tidyquant) data <- tq_get("IBM", get = 'key.stats') I can get all of the following metrics for IBM: [1] "Ask" "Ask.Size" [3] "Average.Daily.Volume" "Bid" [5] "Bid.Size" "Book.Value" [7] "Change" "Change.From.200.day.Moving.Average" [9] "Change.From.50.day.M...
by GLState
Thu May 11, 2017 7:10 pm
Forum: Investing - Help with Personal Investments
Topic: Play-money Investment Simulator?
Replies: 11
Views: 1274

Re: Play-money Investment Simulator?

TDAmeritrade has Papermoney, which uses the ThinkorSwim platform to trade stocks, options, and futures. https://www.thinkorswim.com/t/pm-registration.html . I've had an account for years, but I see its currently only for a 60 day free trial. You're using the same platform that you would be using wit...
by GLState
Thu May 11, 2017 1:30 pm
Forum: Investing - Theory, News & General
Topic: Anyone use Python to analyze their finances?
Replies: 40
Views: 7355

Re: Anyone use Python to analyze their finances?

For the OPs intended use, I would lean to using Excel for its easy input and short learning curve. I use R to explore financial data beyond my portfolio. With R or Python, we can do the work of the Portfolio Visualizer web site, Simba's spreadsheet or Morningstar's Growth of $10,000 charts, with the...
by GLState
Tue May 09, 2017 1:28 pm
Forum: Investing - Help with Personal Investments
Topic: JPMorgan index ETFs (commission free at etrade)
Replies: 3
Views: 377

Re: JPMorgan index ETFs (commission free at etrade)

JPGE is a global fund that has 25% of its portfolio in US stocks, so it would perform better than a 100% foreign fund over the past couple of years. From the prospectus, JPGE's gross expense ratio is 0.93% with a 0.55% waiver until 2/29/2020. JPUS has a also has an expense waiver...0.90% in the pros...
by GLState
Sun May 07, 2017 8:24 pm
Forum: Investing - Theory, News & General
Topic: Low Cost Active Funds: Theoretical Advantages?
Replies: 7
Views: 843

Re: Low Cost Active Funds: Theoretical Advantages?

I read a report from morningstar of the best actively managed funds. Guess what, most of them where Vanguard and American Funds, which are low cost (yearly expenses). Also, American Funds released a report stating that the most important two variables that can tell you if the actively managed funds...
by GLState
Sat May 06, 2017 7:24 pm
Forum: Investing - Theory, News & General
Topic: Why do stock prices move more while the market is open?
Replies: 11
Views: 1520

Re: Why do stock prices move more while the market is open?

The index doesn't "trade" overnight but the effects of news, earnings, etc should still be reflected in the difference between the previous day's close and the current day's open. In the stock's and ETF's that pay dividends, we are not taking into account those dividends...so, that is a problem when...
by GLState
Sat May 06, 2017 6:05 pm
Forum: Investing - Theory, News & General
Topic: Why do stock prices move more while the market is open?
Replies: 11
Views: 1520

Re: Why do stock prices move more while the market is open?

I also used GSPC and MSFT and got the same results as you did. I think we're missing something in the way we were creating the graphs. Overnight plus Intraday returns should sum to our total returns. I created a histogram of overnight and intraday returns for GSPC. The overnight and intraday movemen...
by GLState
Sat May 06, 2017 12:12 pm
Forum: Investing - Theory, News & General
Topic: Why do stock prices move more while the market is open?
Replies: 11
Views: 1520

Re: Why do stock prices move more while the market is open?

SPY rather than ^GSPC

for the time period of 2007 to yesterday, using SPY, I get:
annualized return Market Open - 2.35%
annualized return Market Closed - 2.82%

Image
by GLState
Fri May 05, 2017 5:47 pm
Forum: Investing - Theory, News & General
Topic: "Wondering how to convert to Admiral Shares?"
Replies: 20
Views: 2791

Re: "Wondering how to convert to Admiral Shares?"

GLstate Once you become admiral, Vanguard doesn't drop you to investor if your balance decreases (I believe they can, but it has not happened to me in the past and I doubt they would find it a worthwhile exercise); and no one should pay more in expenses for investor class shares when admiral have c...
by GLState
Fri May 05, 2017 11:06 am
Forum: Investing - Theory, News & General
Topic: "Wondering how to convert to Admiral Shares?"
Replies: 20
Views: 2791

Re: "Wondering how to convert to Admiral Shares?"

Rather than giving a link, Vanguard should just do this automatically when you hit the account minimum for admiral shares - it shouldn't be a game for those in the know If I remember correctly, Vanguard will, at some point, either automatically convert or perhaps just keep bugging you to convert. I...
by GLState
Fri May 05, 2017 7:01 am
Forum: Investing - Theory, News & General
Topic: "Wondering how to convert to Admiral Shares?"
Replies: 20
Views: 2791

Re: "Wondering how to convert to Admiral Shares?"

I did this a few days ago. There was a button on my "Balances and Holdings" page that said "Convert to Admiral" (or something similar) on the account that held the asset that was eligible for conversion.
by GLState
Wed May 03, 2017 6:44 pm
Forum: Investing - Help with Personal Investments
Topic: Vanguard CSV file of fund performance history
Replies: 16
Views: 1748

Re: Vanguard CSV file of fund performance history

In the past, I've used the macro found here http://www.mathfinance.cn/download-mult ... oo-finance to download Yahoo price data for multiple symbols into Excel.
by GLState
Wed May 03, 2017 10:16 am
Forum: Personal Finance (Not Investing)
Topic: best way to get a handle on expenses?
Replies: 16
Views: 1483

Re: best way to get a handle on expenses?

If it would take an hour a day to enter expenses, perhaps you are just buying too much stuff? :D I have quite a few bills that I can't pay by credit card or they charge 2% or 3% to do so....property taxes, utilities, etc so using credit cards to track expenses wouldn't work for me. My credit card in...
by GLState
Mon May 01, 2017 6:24 pm
Forum: Investing - Theory, News & General
Topic: R and Data Sets
Replies: 18
Views: 2228

Re: R and Data Sets

Your path with python would be similar as with R. Data Camp has R and Python classes. Coursera has "Programming for Everbody" from the University of Michigan and Rice University has "An Introduction to Interactive Programming in Python". The Python Pandas documentation is a good intro to using Pytho...
by GLState
Mon May 01, 2017 3:58 pm
Forum: Investing - Theory, News & General
Topic: R and Data Sets
Replies: 18
Views: 2228

Re: R and Data Sets

I would also suggest starting with EdX and Coursera classes ... many statistics classes use R. The Analytics Edge class begins June 6th on EdX...you can take it for free. DataCamp also has introductory R classes as well as finance specific classes..."Importing and Managing Financial Data in R" & "In...
by GLState
Sat Apr 22, 2017 12:31 pm
Forum: Investing - Help with Personal Investments
Topic: A few questions about International... VXUS, VEA, VWO... low returns
Replies: 24
Views: 2375

Re: A few questions about International... VXUS, VEA, VWO... low returns

Christian...You don't like international simply because of past returns? At some point, you're going to hate every asset in your portfolio. Buying based on past performance is the wrong way to invest. Over the past couple of week's you've kept adding funds solely based on past performance without co...
by GLState
Fri Apr 21, 2017 7:13 am
Forum: Investing - Help with Personal Investments
Topic: How to Track Previous Portfolio Performance in Keeping Pace with the Market
Replies: 6
Views: 785

Re: How to Track Previous Portfolio Performance in Keeping Pace with the Market

Portfolio Visualizer is easy to use to create a benchmark for comparision https://www.portfoliovisualizer.com/ Excel may also be a good choice, but if you want to compare your portfolio to a custom benchmark you would have to find the data for all of the components. Don't be too quick to jump to con...
by GLState
Tue Apr 18, 2017 8:04 am
Forum: Investing - Help with Personal Investments
Topic: My Story so far. Totally confused! Vanguard, Charles Schwab, Merrill Edge. Managing own portfolio... or NOT?
Replies: 86
Views: 8249

Re: My Story so far. Totally confused! Vanguard, Charles Schwab, Merrill Edge. Managing own portfolio... or NOT?

[quote="Christian NY" Can I add a "junk bond" fund to cover the lower quality bonds and also attempt to increase overall long-term returns of the bond portion of the portfolio? [/quote] You don't need to "cover" low quality bonds or gamble on riskier bonds in an "attempt to increase the overall long...
by GLState
Mon Apr 17, 2017 4:25 pm
Forum: Investing - Help with Personal Investments
Topic: My Story so far. Totally confused! Vanguard, Charles Schwab, Merrill Edge. Managing own portfolio... or NOT?
Replies: 86
Views: 8249

Re: My Story so far. Totally confused! Vanguard, Charles Schwab, Merrill Edge. Managing own portfolio... or NOT?

On the Prudential fund, if I understand you correctly you are saying that as interest rates rise, returns from PDBZX could go down and become similar to those of BND/BIV. So because of the expense ratio of 0.51% on PDBZX I may actually get worse net returns than BND. It is very possible that all bo...
by GLState
Mon Apr 17, 2017 3:02 pm
Forum: Investing - Help with Personal Investments
Topic: My Story so far. Totally confused! Vanguard, Charles Schwab, Merrill Edge. Managing own portfolio... or NOT?
Replies: 86
Views: 8249

Re: My Story so far. Totally confused! Vanguard, Charles Schwab, Merrill Edge. Managing own portfolio... or NOT?

I wouldn't buy PDBZX (Prudential Total Return Bond) when there are so many other better choices. Past bond returns are not what you'll get in the future. Bond funds have benefited from the decline of interest rates since the 1980s. Interest rates are currently rising. An AAA rated corporate bond tod...
by GLState
Mon Apr 17, 2017 11:11 am
Forum: Investing - Help with Personal Investments
Topic: My Story so far. Totally confused! Vanguard, Charles Schwab, Merrill Edge. Managing own portfolio... or NOT?
Replies: 86
Views: 8249

Re: My Story so far. Totally confused! Vanguard, Charles Schwab, Merrill Edge. Managing own portfolio... or NOT?

PDBZX, Prudential Total Return Bond Fund, is a class Z fund. It is likely only available in 401K. You would have to buy the A shares or other class (B,C,?) of the fund outside of a 401k. A shares have a 4.5% front end load. I owned PDBZX for a many years in my 401k. It was the best choice, but I wou...
by GLState
Sat Apr 15, 2017 3:51 pm
Forum: Investing - Theory, News & General
Topic: Is there any reason a buy-and-hold investor would buy gold?
Replies: 121
Views: 8383

Re: Is there any reason a buy-and-hold investor would buy gold?

Yes there are reasons for long-term investors to buy gold. Search the forum for Permanent Portfolio for one point of view. Go to the Portfolio Visualizer website and create a 60/40 stock/bond portfolio and a 50,40,10 stock/bond/gold portfolio. You'll find that the addition of gold will give a bit be...
by GLState
Wed Apr 12, 2017 8:21 am
Forum: Investing - Theory, News & General
Topic: A time to EVALUATE your jitters
Replies: 219
Views: 170666

Re: A time to EVALUATE your jitters

Investing in Japan would only have been "fatal" if we invested our total wealth at the very high. Looking only at previous highs on charts gives a false impression of what an investor would actually experience. Look at the chart of the Nikkei and imagine investing 5% of our pay every week over the l...
by GLState
Fri Mar 31, 2017 8:05 am
Forum: Investing - Help with Personal Investments
Topic: Quandary of ML Stock Picker vs. VTSMX or VFINX
Replies: 16
Views: 1387

Re: Quandary of ML Stock Picker vs. VTSMX or VFINX

Here is a link to the 2008 Standard & Poors SPIVA report mentioned by Taylor... http://www.spindices.com/documents/spiva/spiva-us-year-end-2008.pdf "The belief that bear markets favor active management is a myth. A majority of active funds in eight of the nine domestic equity style boxes were outper...
by GLState
Fri Mar 31, 2017 7:57 am
Forum: Investing - Help with Personal Investments
Topic: Schwab offering .03% ER
Replies: 75
Views: 4702

Re: Schwab offering .03% ER

I wouldn't select a broker on the basis of a difference in an expenses ratio of .02%. I was a Schwab customer in the 80's and I liked them, but they began to discourage investors with accounts less than 50K, so I transferred that account to Vanguard. Low costs seem to be part of Vanguard's "personal...
by GLState
Thu Mar 23, 2017 11:19 am
Forum: Investing - Help with Personal Investments
Topic: Advice investing in index funds
Replies: 9
Views: 1159

Re: Advice investing in index funds

VTSMX has a $3000 minimum investment requirement. One of Vanguard's Target Date funds, which have a minimum investment of $1000, would be a good choice for a first investment. Or, instead of VTSMX, you could purchase the equivalent ETF, VTI, but would have to pay a commission of $5-$10, depending on...
by GLState
Thu Mar 16, 2017 7:53 am
Forum: Personal Consumer Issues
Topic: Vegetable Gardening - seeds vs seedlings?
Replies: 29
Views: 3173

Re: Vegetable Gardening - seeds vs seedlings?

A lot depends on the scale. It makes little sense to buy a packet of seeds for 3 or 4 bucks to get 100 seeds when you only need 3 or 4 plants that cost 3 or 4 bucks. You don't say what facilities you have to grow seeds ....you need heat and lots of light and quite a bit of room. It also depends on t...
by GLState
Wed Mar 08, 2017 9:03 am
Forum: Investing - Help with Personal Investments
Topic: Should I be distributed throughout the Style Map?
Replies: 6
Views: 496

Re: Should I be distributed throughout the Style Map?

First determine the type of portfolio that you want, then buy funds that fit this preference. Don't just choose a different style box with each purchase...you'll end up with a hodgepodge of funds with no direction. Understand what the style box is saying....buying a value and a growth fund results i...
by GLState
Sat Feb 25, 2017 9:06 am
Forum: Investing - Help with Personal Investments
Topic: Bogleheads' Philosophy a Generalization?
Replies: 55
Views: 3925

Re: Bogleheads' Philosophy a Generalization?

[/quote] Does this apply to Vanguard funds such as Wellesley Income Fund?[/quote] Wellesley is just another mutual fund...it is subject to forces that affect other funds. It has performed well in the past, but that doesn't foretell the future. Wellesley has a large allocation toward large-cap divide...
by GLState
Sat Feb 25, 2017 8:52 am
Forum: Investing - Help with Personal Investments
Topic: Bogleheads' Philosophy a Generalization?
Replies: 55
Views: 3925

Re: Bogleheads' Philosophy a Generalization?

That's great information, thanks. The only thing I'd push back on is while "Past performance is not an indicator of future returns" you can find finds that have been beating or matching indexes for lengthy historical periods. It seems if you're willing to review progress annually or such you could ...
by GLState
Fri Feb 24, 2017 2:09 pm
Forum: Investing - Theory, News & General
Topic: ProShares S&P 500 Dividend Aristocrats ETF - thoughts?
Replies: 32
Views: 3656

Re: ProShares S&P 500 Dividend Aristocrats ETF - thoughts?

Since it's inception in late 2013, NOBL and SPY have performed about the same. There isn't any increased performance or reduced volatility by owning NOBL over SPY. We're not getting anything for the higher expense ratio. SPY NOBL Annualized Return 0.1087235 0.1017161 Annualized Standard Deviation 0....