Search found 141 matches

by GLState
Wed May 17, 2017 9:14 am
Forum: Investing - Theory, News & General
Topic: yahoo finance - adjusted price data incorrect?
Replies: 64
Views: 12432

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: 64
Views: 12432

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: 64
Views: 12432

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: 64
Views: 12432

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: 64
Views: 12432

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: 64
Views: 12432

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: 9049

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: 1497

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: 9049

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: 445

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: 963

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: 1725

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: 1725

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: 1725

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: 3870

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: 3870

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: 3870

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: 2529

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: 1685

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: 2580

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: 2580

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: 3331

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: 920

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: 9776

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: 9776

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: 9776

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: 9776

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: 158
Views: 13735

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: 283
Views: 243607

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: 1592

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: 5493

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: 1284

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: 3463

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: 599

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: 4301

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: 4301

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: 4177

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....
by GLState
Sun Feb 19, 2017 2:43 pm
Forum: Investing - Theory, News & General
Topic: I think some criticisim of active management is wrong.
Replies: 22
Views: 2926

Re: I think some criticisim of active management is wrong.

We can all have options but not facts.... study after study shows that managers do not add value after fees in any predictable manner. Curious. Might this also apply to the Wellesley Income Fund and Wellington Fund? j Yes...it applies to the Wellesley and Wellington Funds. Over the past 10 years, y...
by GLState
Sat Feb 18, 2017 5:21 pm
Forum: Personal Finance (Not Investing)
Topic: Missing my Microsoft Money - any equivalents?
Replies: 51
Views: 11294

Re: Missing my Microsoft Money - any equivalents?

Does anyone know of a program like Microsoft Money that also has an educational component? I'm a recent grad and don't have a lot of experience managing my finances so I'd like to learn more I would suggest downloading the free Microsoft Money Sunset edition. https://www.microsoft.com/en-us/downloa...
by GLState
Thu Feb 16, 2017 10:12 am
Forum: Investing - Help with Personal Investments
Topic: Very basic question about fees
Replies: 10
Views: 1310

Re: Very basic question about fees

Expenses are calculated on your balance not your contribution. If you have $10,000 in your account, your expenses would 10,000 * .0033 (.33%) or $33 per year vs. $17/year for the fund charging .0017 (.17%). This is an annual expense....the costs of running the fund.
by GLState
Wed Feb 15, 2017 4:48 pm
Forum: Investing - Help with Personal Investments
Topic: Math help needed. Calculating allocation Wellington Wellesley Total Bond to 30/70.
Replies: 22
Views: 2559

Re: Math help needed. Calculating allocation Wellington Wellesley Total Bond to 30/70.

According to the Vanguard web site, Wellesley has a current 38.6/61.4 ratio of stocks to bonds, so a large share of money not already allocated to Wellesley would go to adding bond funds to get down to a 30/70 ratio. You don't have much leeway to buy stock index funds with a 70% Wellesley portfolio....