I would like to request a new Data Provider.
The site is multpl.com. This site contains various fundamental statistics for S&P 500, e.g. dividend, earnings, etc.
If you go to
http://www.multpl.com/sitemap, you'll see various S&P 500 Stats on the left. From there one can bring up a chart or break it down into table format (yearly or monthly table). I think it will be worthwhile to create a separate Data Provider for these important data.
Size:
Color:
Thanks for the pointer, I'll take a look.
Meanwhile you can get the following S&P 500 fundamental items from
YCharts paid feed: Return From Dividends Annual, Dividends Per Share, EPS, Operating EPS, Operating P/E Ratio, P/E Ratio.
Size:
Color:
I just downloaded some free data from Ycharts. But it only goes back a few years.
For symbol "SPY", I can get data for Dividend but no EPS and PE ratio (EPS and PE should be part of free data). For symbol ".SPX", there are no data.
I also tried "^GSPC" from Yahoo data set but the Dividend, EPS and PE ratio are incorrect.
So how do I get EPS and PE ratio for S&P 500 from YCharts? That is, is there a particular S&P 500 symbol (e.g. SPY, ^GSPC, etc) that I should update to get the EPS and PE ratio data?
Size:
Color:
You probably haven't downloaded the data from YCharts but from Yahoo? These are totally different things as YCharts is a fundamental provider like Fidelity fundamental data and hence doesn't support any "symbols" like SPY, ^GSPC and the like. Please follow the online manual (see link in my post above) on how to work with it. More information re: fundamental providers is available in the Wealth-Lab User Guide.
The Yahoo fundamental provider does not return any S&P related fundamental items for stock and/or index symbols - only stock dividends and splits (if applicable).
In free mode, YCharts data is very limited (AFAIR, 2-5 years depending on item and not all items are available).
Size:
Color:
Since SPY is not a company, it doesn't have earnings. Likewise for an index. That said, you could sum all the earnings and dividends of the components of an ETF or index right in Wealth-Lab and come up with those numbers as multpl does for the S&P 500. To make it easy though, it potentially could be added as an Index Definition to Index-Lab.
Here's an example for the Fidelity Fundamental provider:
CODE:
Please log in to see this code.
Size:
Color:
Yes, it would be good, if we had an Index-Lab definitions for fundamental data. I suggest the following: sum of earnings, sum of shares (to get earnings per share), sum of dividend, sum of sales, sum of book value.
Size:
Color:
QUOTE:
To make it easy though, it potentially could be added as an Index Definition to Index-Lab.
I'm afraid that accessing fundamental data in Index-Lab using the
FundamentalsRatio is not possible due to the absense of a WealthScript instance in IndexDefinitions.
Size:
Color:
richard1000, here's some good news for you:
Multpl.com provider to arrive in the upcoming release of
MS123 Extra Fundamental/News Providers early next month. We're going to support S&P 500 Stats, Treasury Rates and US Economic Stats.
Size:
Color:
The Multpl provider has been released.
Size:
Color:
Eugene, thank you for the Multpl provider.
Some feedback:
1) Can you also add 10-year Treasury Rate?
2) When I place the Multpl data using Drag and Drop onto a chart, the data does not appear. But if I push all the indicators into the strategy code, the data appears. It appears Drag and Drop is not functioning correctly with Multpl data.
Size:
Color:
QUOTE:
1) Can you also add 10-year Treasury Rate?
Wow, you've noticed that it's missing. I can add it since there's demand, but the item will be called "[mu] interest-rate" and so will sound its description. The naming on the website deviates from the pattern and I decided to not include it initially.
QUOTE:
2) When I place the Multpl data using Drag and Drop onto a chart, the data does not appear.
Never seen that. Always works for me, see
screenshot of a chart in the Wiki. Please attach a screenshot like mine and be as detailed in problem description as possible.
Size:
Color:
I am using WLP 6.7.19 64-bit.
After updating the Multpl data, I open up a chart and place the Multpl data using Drag and Drop onto the chart. The result is (attachment multpl1.jpg).
Size:
Color:
If I click "Push all Indicators ..." button, the result is (attachment multpl2.jpg).
Size:
Color:
May be it's a 6.7 issue, need to check.
Please update some other fundamental sources from MS123 Fundamental/News providers - does the issue persist or is it exclusive to Multpl?
Size:
Color:
Drag and Drop works on following Fundamental Providers: 99Wallstreet, Fidelity Fundamental Data for Securities, Morningstar Fundamental Data, YCharts Fundamental Data for Securities.
Drag and Drop does not work on following Fundamental Providers: Multpl economic data, YCharts economic data
Size:
Color:
QUOTE:
Drag and Drop does not work on following Fundamental Providers: Multpl economic data, YCharts economic data
Thanks, we're onto something: both of them are providers of
non-symbol (aka "economic") data.
Size:
Color:
Size:
Color:
richard1000,QUOTE:
If I click "Push all Indicators ..." button, the result is (attachment multpl2.jpg).
This is a new bug. It definitely didn't happen in 6.6 but in 6.8 I'm able to reproduce it. Your first screenshot with labels like "[mu] s-p-500-sales
(AXP)" says it all. It's an economic a.k.a. non-symbol data provider so the stock ticker shouldn't be there on your chart! It's gone on the 2nd screenshot, as expected. I'll commit a bug report.
Size:
Color:
What's new in v2019.02 MS123 Fundamental providers library?
* Change: Multpl provider: Item "[mu] interest-rate" is replaced with "[mu] 10-year-treasury-rate"
Size:
Color: