Messages In This Digest (10 Messages)
- 1a.
- Re: RCH GET History Question. From: MikeM
- 1b.
- Re: RCH GET History Question. From: Nick Leaton
- 2a.
- Re: Does anyone have an excel that uses a moving average crossover? From: Ron Spruell
- 3a.
- ETF;s, Mutual Funds and Stocks From: nrothfuss@dalpos.com
- 3b.
- Re: ETF;s, Mutual Funds and Stocks From: Randy Harmelink
- 3c.
- Re: ETF;s, Mutual Funds and Stocks From: Rothfuss, Neal
- 3d.
- Re: ETF;s, Mutual Funds and Stocks From: Randy Harmelink
- 4a.
- RCHGetWebData-Template-Bar Chart-Quotes-Extract From: HenryT
- 4b.
- Re: RCHGetWebData-Template-Bar Chart-Quotes-Extract From: Randy Harmelink
- 5a.
- Re: Australian data not updated in MSN Money From: dockairne
Messages
- 1a.
-
Re: RCH GET History Question.
Posted by: "MikeM" mikemcq802@yahoo.com mikemcq802
Sun Apr 15, 2012 6:20 am (PDT)
I can speak from personal experience that Yahoo's dividend history is weak. I routinely retrieve price and dividend data to analyze separately. I've had to create a scheme to allow manual adjustments to the dividend history (in columns other than the formulas for SMF).
I have to manually adjust the 10-year dividend history far more than half the time.
With 1000 tickers the amount of dividend data you would have to manually adjust would take an absurdly long time.
I think Randy could easily reduce his 1000 limit to something like 200. The amount of data errors in the free services is just too high to use for large screening.
--- In smf_addin@yahoogroups.com , "clifford.dowler" <clifford.dowler@...> wrote:
>
> Ultimately, what i want to do is to get the closing prices of a group of stocks for say daily data going back 10 years and perhaps also get any dividends paid. Still the work around would be to get just the closing prices in one table and the dividends in another,and then combine the two tables to get total return for any given stock over a specific period.
>
> Thank you.
>
> Cliff
>
- 1b.
-
Re: RCH GET History Question.
Posted by: "Nick Leaton" nickle@gmail.com njleaton
Sun Apr 15, 2012 6:51 am (PDT)
I've been looking at scrapping dividends for the UK, for the FTSE 350.
I found the data particularly odd.
I've found dividends on stockopedia, yahoo, advfn, exdividenddate
The dividend structure that I'm after is
source, ticker, type, currency, declaration date, ex div date, record date,
pay date, amount, gbp amount, fx rate
Not all sources have all the data so I'm going to try and fill in from
others. Also, if I have the ex div date, I can calculate the record date
and vice versa.
Another angle I've been thinking about is that most of the companies have
historical data on their sites. Now I suspect that there is a common
registrar service running this part of their websites. That might mean that
their format of the HTML is pretty consistent. So it might be possible to
write generic parsers.
I agree that having an override is the right way of going.
Now, the smf_addin angle. If the data is scrapped on something like
scraperwiki, https://scraperwiki.com/scrapers/ for my alphadividends/
dividend set up, then its very easy for smf_addin to get the data.
This is quite a nice architecture. Central scrapper, consistent format
output for an addin.
--
Nick
- 2a.
-
Re: Does anyone have an excel that uses a moving average crossover?
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Sun Apr 15, 2012 7:03 am (PDT)
Sort of! I have a spreadsheet that calculates the 8-day, 20-day, 50-day, 75-day and 200-day SMA among other things. It does indicate the spread between the 200-day SMA and the Current Price. It doesn't use cross over, it uses the slope of the SMA.
For example, I know that on the last trading day 4/13/12 that the SPY was 10.92 above the 200-day SMA. The slopes are as follows:
8-day -0.42%
20-day -0.11%
50-day 0.08%
75-day 0.11%
200-day 0.04%
The purpose of the spreadsheet was to track Marvin and Gerald Appel's ETF Rotation in the book"Beating the Market, 3 Months at a Time".
If you want a copy post back.
Ron Spruell
>____________________ _________ ___
> From: scott_grant2 <scott_grant2@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Sunday, April 15, 2012 12:11 AM
>Subject: [smf_addin] Does anyone have an excel that uses a moving average crossover?
>
>
>
>I have an excel sheet that does a different kind
>of trend, i could try and write it, i love the plug-in
>but i wouldnt be ashamed to ask if anyone else has
>already written one..
>
>thanks
>Scott
>
>
>
>
>
- 3a.
-
ETF;s, Mutual Funds and Stocks
Posted by: "nrothfuss@dalpos.com" nrothfuss@dalpos.com nrothfuss
Sun Apr 15, 2012 10:23 am (PDT)
This question may have been asked before but I could not find it.
Is there a template that will return the normal information for: ETF, MF's and Stocks all on one page? or is that impossible?
Thanks, Neal
- 3b.
-
Re: ETF;s, Mutual Funds and Stocks
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 15, 2012 10:30 am (PDT)
It all depends on what you mean by "normal information".
Certainly, you can mix functions where some return ETF data, some return
Fund data, and some return stock data. But most information is not
available for all three items, and not sourced the same way. For example,
most defined elements only work for one of the three types of equities.
RCHGetYahooQuotes() can return price data for all three, but the
fundamental data will not be carried for all three.
On Sun, Apr 15, 2012 at 10:23 AM, <nrothfuss@dalpos.com > wrote:
> This question may have been asked before but I could not find it.
> Is there a template that will return the normal information for: ETF, MF's
> and Stocks all on one page? or is that impossible?
>
- 3c.
-
Re: ETF;s, Mutual Funds and Stocks
Posted by: "Rothfuss, Neal" nrothfuss@dalpos.com nrothfuss
Sun Apr 15, 2012 10:35 am (PDT)
OK By normal I meant fundamental
_____________________ _________ __
From: smf_addin@yahoogroups.com [smf_addin@yahoogroups.com ] on behalf of Randy Harmelink [rharmelink@gmail.com ]
Sent: Sunday, April 15, 2012 1:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] ETF;s, Mutual Funds and Stocks
It all depends on what you mean by "normal information".
Certainly, you can mix functions where some return ETF data, some return Fund data, and some return stock data. But most information is not available for all three items, and not sourced the same way. For example, most defined elements only work for one of the three types of equities.
RCHGetYahooQuotes() can return price data for all three, but the fundamental data will not be carried for all three.
On Sun, Apr 15, 2012 at 10:23 AM, <nrothfuss@dalpos.com <mailto:nrothfuss@dalpos.com >> wrote:
This question may have been asked before but I could not find it.
Is there a template that will return the normal information for: ETF, MF's and Stocks all on one page? or is that impossible?
- 3d.
-
Re: ETF;s, Mutual Funds and Stocks
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 15, 2012 11:15 am (PDT)
I'm not sure they're even comparable between the various equities. For
example, a P/E ratio doesn't make sense on a commodities ETF. But you could
certainly get a P/E factor on something like SPY.
On Sun, Apr 15, 2012 at 10:35 AM, Rothfuss, Neal <nrothfuss@dalpos.com >wrote:
> OK By normal I meant fundamental
>
- 4a.
-
RCHGetWebData-Template-Bar Chart-Quotes-Extract
Posted by: "HenryT" hkctsui@shaw.ca henrykctsui
Sun Apr 15, 2012 2:27 pm (PDT)
Hello :
The template seems to work fine for US stocks.
I had problems to get the quotes for Canadian stock like
TA.TO ,CU.TO ...by replacing the symbol from MMM.
Please advise
Henry
- 4b.
-
Re: RCHGetWebData-Template-Bar Chart-Quotes-Extract
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Apr 15, 2012 2:49 pm (PDT)
I just tried TA.TO and it worked fine for me. You're probably asking for a
time period BarChart doesn't offer for Canadian stocks.
For example, when I look here for TA.TO:
http://charts.barchart. com/chart. asp?sym=TA. TO
...only 30-minute, daily, weekly, and monthly choices are available.
On Sun, Apr 15, 2012 at 2:14 PM, HenryT <hkctsui@shaw.ca > wrote:
>
> The template seems to work fine for US stocks.
> I had problems to get the quotes for Canadian stock like
> TA.TO ,CU.TO ...by replacing the symbol from MMM.
>
> Please advise
>
- 5a.
-
Re: Australian data not updated in MSN Money
Posted by: "dockairne" dockairne@yahoo.com.au dockairne
Sun Apr 15, 2012 6:55 pm (PDT)
--- In smf_addin@yahoogroups.com , "John" <jfp1008@...> wrote:
>
> Hello Randy:
>
> Since 3/29/2012 Australian data has not been updated on MSN Money.
>
> For example, see the 10-day price chart for AU:MIN --
>
> http://investing.money.msn. com/investments/ charts?symbol= au:min#all= on&period= 10d&interactive= on&symbol= au:min
>
> It shows $12.03 on March 29 and nothing since.
>
> Any thoughts?
>
> John
>
John, I had been using msmoney and the excel addin msn quotes for years, but per their announcement several years ago that msmoney was done and with the withdrawal of the msn quotes addin, it seems msn is now totally useless for the Australian sharemarket, so i happened upon a youtube item, and couldn't be happier as my updates now come into excel directly from the ASX!!!! what more could we ask for (except 52wk highs and lows mkt cap and shares outstanding), asked the asx to supply that info, but aint holding my breath, so good luck using the ASX rather than yahoo, google or msn, the youtube url is http://www.youtube. com/watch? v=q_fjdkeZb6Y
regards Sam
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar