Messages In This Digest (11 Messages)
- 1a.
- Does RCHGetTableCell function work in array? From: boo1712
- 1b.
- Re: Does RCHGetTableCell function work in array? From: Randy Harmelink
- 2a.
- Inaccurate yahoo finance dividend data? From: cgrwells
- 2b.
- Re: Inaccurate yahoo finance dividend data? From: Gary Funck
- 2c.
- Re: Inaccurate yahoo finance dividend data? From: Gary Funck
- 3a.
- =rchcreatecomment(Ticker,1,,,,,,,,"Chart") question From: peteblack43
- 3b.
- Re: =rchcreatecomment(Ticker,1,,,,,,,,"Chart") question From: Randy Harmelink
- 4a.
- morningstar key ratios template From: think1stb4utrade
- 4b.
- Re: morningstar key ratios template From: Randy Harmelink
- 4c.
- Re: morningstar key ratios template From: Randy Harmelink
- 5a.
- Re: forward EBITDA element? From: tkqucz
Messages
- 1a.
-
Does RCHGetTableCell function work in array?
Posted by: "boo1712" boo1712@yahoo.co.uk boo1712
Sun Jul 31, 2011 5:51 am (PDT)
Hi,
Just want to confirm whether the function work in array?
Hard to get more than a handful of cells if it cannot work in array.
Thanks
Terry
- 1b.
-
Re: Does RCHGetTableCell function work in array?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jul 31, 2011 8:08 am (PDT)
It does not work in an array. I don't understand your second comment. Even
if it did work in an array, it would be doing the same amount of work to
fill the range. There was no point in making it an array, since arrays just
complicate worksheet usage.
On Sun, Jul 31, 2011 at 5:51 AM, boo1712 <boo1712@yahoo.co.uk > wrote:
>
> Just want to confirm whether the function work in array?
>
> Hard to get more than a handful of cells if it cannot work in array.
>
- 2a.
-
Inaccurate yahoo finance dividend data?
Posted by: "cgrwells" cgrwells@yahoo.co.uk cgrwells
Sun Jul 31, 2011 10:48 am (PDT)
Hi guys,
apologies if this has been dealt with before, I'm sure it has as its fairly 'fundamental' (no pun intended!). I'm a former hedge-fund equity analyst, now out of work, and I'm building an advanced stock selection system in PERL, screen-scraping a lot of fundamental data from reuters, and then implementing things like piotroski, sloan's accruals, and other methods so I'm not actually using the smfplugin (although it looks great and I may do at some stage but not for this), but the question about source-data seems a reasonable one hence I am asking in this group.
My problem is that for e.g. BATS.L (British american tobacco, a major UK-listed international tobacco company), the dividend data appears to be incorrect; just eyeballing, its far too large! e.g. 60% of the share price in March 2010! If you look at http://uk.finance.yahoo.com/ you can see that the dividends in the yahoo system are enormous and incorrect (if you compare with the company's websiteq/hps=BATS. L&b=1&a=00& c=2003&e= 31&d=06&f= 2011&g=v,
http://www.bat.com/group/ \nt&SKN=1 you can see the divis they actually paid). This means that the yahoo adjusted price is way out, and if they got it wrong for a major FTSE-100 company like BATS then it will surely be wrong for many smaller companies and in other markets; unfortunately, this means that the aggregate price performance of any selection of stocks will also be wrong, and therefore I can't backtest any strategies with yahoo data. Has anyone here got any views on this? if I don't use the adjusted price then the price won't be adjusted for stock-splits ... I could manually scrape out stock-splits from the yahoo page for each stock and do the price adjustments myself (assuming the stock-split history is accurate), and I could use the reuters P&L to calculate the dividends paid in any accounting period using yahoo's payment dates but that would be somewhat tedious!sites/uk_ _3mnfen.nsf/ vwPagesWebLive/ DO6QCH8J? opendocume
Thanks for any thoughts/help.
Best regards,
Carl
- 2b.
-
Re: Inaccurate yahoo finance dividend data?
Posted by: "Gary Funck" gary@intrepid.com garyfunck
Sun Jul 31, 2011 5:16 pm (PDT)
On 07/31/11 16:16:25, cgrwells wrote:
> My problem is that for e.g. BATS.L (British american tobacco,
> a major UK-listed international tobacco company), the dividend
> data appears to be incorrect; just eyeballing, its far too
> large! e.g. 60% of the share price in March 2010! If you look at
> http://uk.finance.yahoo.com/ q/hps=BATS. L&b=1&a=00& c=2003&e= 31&d=06&f= 2011&g=v,
> you can see that the dividends in the yahoo system are enormous
> and incorrect (if you compare with the company's website
> you can see the divis they actually paid).
They do look out-of-whack. If you try the ADR, the numbers
seem to be more in line, with an annual div. rate of 3.8%/so.
For the heck of it, you might ask BT's investor department
if they can explain the anomaly.
> This means that the yahoo adjusted price is way out, and if they
> got it wrong for a major FTSE-100 company like BATS then it will
> surely be wrong for many smaller companies and in other markets;
It might be worth trying some of those other companies to see
if this issue is unique to BT.
One thought comes to mind, is there perhaps a "group dividend"
that includes all the separate tobacco companies held by the
holding company that holds BT (and it is this dividend that
is being incorrectly for BT)? (please note that I don't know
anything about the details of BT as a company, so this idea
could be completely off base).
> unfortunately, this means that the aggregate price performance of
> any selection of stocks will also be wrong, and therefore I can't
> backtest any strategies with yahoo data. Has anyone here got any
> views on this? if I don't use the adjusted price then the price
> won't be adjusted for stock-splits ... I could manually scrape out
> stock-splits from the yahoo page for each stock and do the price
> adjustments myself (assuming the stock-split history is accurate),
> and I could use the reuters P&L to calculate the dividends paid
> in any accounting period using yahoo's payment dates but that
> would be somewhat tedious!
Note that the Yahoo! adjusted price can be inaccurate over
long time periods because it is reported only to two decimal places.
IIRC, there is an "R" package that fetches stock prices and
captures both split and dividends separately and makes its
own adjustments. For example,
http://www.r-chart.com/ 2010/06/stock- analysis- using-r.html
If you're hacking in Perl, this CPAN module may help:
http://search.cpan.org/ ~msisk/Finance- QuoteHist- 1.16/lib/ Finance/QuoteHis t.pm
- Gary
- 2c.
-
Re: Inaccurate yahoo finance dividend data?
Posted by: "Gary Funck" gary@intrepid.com garyfunck
Sun Jul 31, 2011 5:26 pm (PDT)
On 07/31/11 17:15:43, Gary Funck wrote:
> IIRC, there is an "R" package that fetches stock prices and
> captures both split and dividends separately and makes its
> own adjustments. For example,
> http://www.r-chart.com/ 2010/06/stock- analysis- using-r.html
Also, if you're comfortable with programming in "R", there
is an add-on which bridges to Excel.
Summary: http://en.wikipedia.org/wiki/ RExcel
RExcel: http://rcom.univie.ac. at/
- Gary
- 3a.
-
=rchcreatecomment(Ticker,1,,,,,,,,"Chart") question
Posted by: "peteblack43" peteblack43@yahoo.com peteblack43
Sun Jul 31, 2011 11:18 am (PDT)
Hi Randy,
If you have a list of tickers that are static on one page and you are
using =rchcreatecomment(Ticker,1, ,,,,,,,"Chart" ) the chart will work
correctly when you first open the spreadsheet.
If you put the =rchcreatecomment(Ticker,1, ,,,,,,,"Chart" ) on the
same page as where you are manually changing one ticker it will work.
If you have a spreadsheet that you are changing the ticker manually on
page 1 and and referencing and displaying that same ticker on page 2,
why doesn't the chart on page 2 update? But, if you click on that
cell on page 2 for the =rchcreatecomment, put the cursor at the end of
the statement and hit 'Enter' it will change the chart to the correct
ticker. Why can't this change automatically when you put in a new
ticker on page 1?
Thank you for all you hard work.
Pete
- 3b.
-
Re: =rchcreatecomment(Ticker,1,,,,,,,,"Chart") question
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jul 31, 2011 11:24 am (PDT)
It only works on the active sheet, sorry.
On Sun, Jul 31, 2011 at 11:18 AM, peteblack43 <peteblack43@yahoo.com > wrote:
>
> If you have a list of tickers that are static on one page and you are using
> =rchcreatecomment(Ticker,1, ,,,,,,,"Chart" ) the chart will work correctly
> when you first open the spreadsheet.
>
> If you put the =rchcreatecomment(Ticker,1, ,,,,,,,"Chart" ) on the same
> page as where you are manually changing one ticker it will work.
>
> If you have a spreadsheet that you are changing the ticker manually on
> page 1 and and referencing and displaying that same ticker on page 2, why
> doesn't the chart on page 2 update? But, if you click on that cell on page
> 2 for the =rchcreatecomment, put the cursor at the end of the statement and
> hit 'Enter' it will change the chart to the correct ticker. Why can't this
> change automatically when you put in a new ticker on page 1?
>
- 4a.
-
morningstar key ratios template
Posted by: "think1stb4utrade" makp@charter.net think1stb4utrade
Sun Jul 31, 2011 7:06 pm (PDT)
On the morning star key ratios template is the profit margins and profitability sections part of morningstars premier membership,because those are getting errors,but the rest of template works fine. I am new to smf addins but it has already been a great help. Thanks
- 4b.
-
Re: morningstar key ratios template
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jul 31, 2011 7:09 pm (PDT)
Morningstar converted that page to be dynamically generated, so there is no
data available for the add-in to extract.
On Sun, Jul 31, 2011 at 6:56 PM, think1stb4utrade <makp@charter.net > wrote:
> On the morning star key ratios template is the profit margins and
> profitability sections part of morningstars premier membership,because those
> are getting errors,but the rest of template works fine. I am new to smf
> addins but it has already been a great help.
>
- 4c.
-
Re: morningstar key ratios template
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jul 31, 2011 7:14 pm (PDT)
PS: I just noticed that the CSV file on the "Export" button is available --
try:
=smfGetCSVFile("
http://financials.morningstar. ")com/ajax/ exportKR2CSV. html?t=MMM
On Sun, Jul 31, 2011 at 6:56 PM, think1stb4utrade <makp@charter.net > wrote:
> On the morning star key ratios template is the profit margins and
> profitability sections part of morningstars premier membership,because those
> are getting errors,but the rest of template works fine. I am new to smf
> addins but it has already been a great help. Thanks
>
- 5a.
-
Re: forward EBITDA element?
Posted by: "tkqucz" thomas.kwon@queensu.ca tkqucz
Sun Jul 31, 2011 10:31 pm (PDT)
I am also looking for ways to pull a forward ebitda (1yr, 2yr)
Thanks!
--- In smf_addin@yahoogroups.com , "vacek_tim" <vacek_tim@...> wrote:
>
> Does anyone know where i can pull 1 year forward EBITDA estimates?
>
> Thanks!
>
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