Sabtu, 10 Agustus 2013

[smf_addin] Digest Number 2729

13 New Messages

Digest #2729
2a
2b
Re: Does the Add-in works in Excel 2010? by "Randy Harmelink" rharmelink

Messages

Fri Aug 9, 2013 5:25 am (PDT) . Posted by:

"itrade4dough" itrade4dough


Thanks Randy. Your dedication is one to emulate.

However, it presents a challenge for me, as well as many others here, to find another site/location in which to gather 16 quarters of financial data other than edgar.

Do you think AdvFn will revert back to offering the data or is this it. Which resembles the competition of offering 4-5 quarters only.

Does there exist a database for the historical quarters for balance sheet and income statements? This way it can be built upon utilizing the last 5 quarters from this point on?

Thanks in advance.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It's now apparent that this is an AdvFN problem.
>
> Until AdvFN fixes things at the website, the most recent five quarters are
> the only ones available, either using a browser or the add-in.
>
> On Thu, Aug 8, 2013 at 3:23 PM, itrade4dough <itrade4dough@...> wrote:
>
> > I am having the same problem. I have a smfgetADFNelement going back 16
> > qtrs and it just repeats the current 5 qtrs over and over. I have tried the
> > smfforcerecalculation as well as properly setting the internet options, and
> > closing out excel and reopening, but yet it still gives me the same problem.
> >
> > Any other ideas???
> >
>

Fri Aug 9, 2013 5:44 am (PDT) . Posted by:

"MLawson" mlawson3

Should we inundate ADVFN w/ reports of the problem? Any +1s for that idea?

--- In smf_addin@yahoogroups.com, "itrade4dough&quot; <itrade4dough@...> wrote:
>
>
> Thanks Randy. Your dedication is one to emulate.
>
> However, it presents a challenge for me, as well as many others here, to find another site/location in which to gather 16 quarters of financial data other than edgar.
>
> Do you think AdvFn will revert back to offering the data or is this it. Which resembles the competition of offering 4-5 quarters only.
>
> Does there exist a database for the historical quarters for balance sheet and income statements? This way it can be built upon utilizing the last 5 quarters from this point on?
>
> Thanks in advance.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > It's now apparent that this is an AdvFN problem.
> >
> > Until AdvFN fixes things at the website, the most recent five quarters are
> > the only ones available, either using a browser or the add-in.
> >
> > On Thu, Aug 8, 2013 at 3:23 PM, itrade4dough <itrade4dough@> wrote:
> >
> > > I am having the same problem. I have a smfgetADFNelement going back 16
> > > qtrs and it just repeats the current 5 qtrs over and over. I have tried the
> > > smfforcerecalculation as well as properly setting the internet options, and
> > > closing out excel and reopening, but yet it still gives me the same problem.
> > >
> > > Any other ideas???
> > >
> >
>

Fri Aug 9, 2013 6:39 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm sure AdvFN will fix the problem. I did figure out how to get to the
data, but I'm hesitant to implement it for two reasons:

1. AdvFN is going to make another change.
2. I don't know how their rollout of changes works. It obviously takes a
few days.

On Fri, Aug 9, 2013 at 5:25 AM, itrade4dough <itrade4dough@yahoo.com> wrote:

>
> Thanks Randy. Your dedication is one to emulate.
>
> However, it presents a challenge for me, as well as many others here, to
> find another site/location in which to gather 16 quarters of financial data
> other than edgar.
>
> Do you think AdvFn will revert back to offering the data or is this it.
> Which resembles the competition of offering 4-5 quarters only.
>
> Does there exist a database for the historical quarters for balance sheet
> and income statements? This way it can be built upon utilizing the last 5
> quarters from this point on?
>
> Thanks in advance.
>

Fri Aug 9, 2013 9:27 am (PDT) . Posted by:

"Russell M" rerussellson

As I have mentioned in a previous post, ADVFN is working on it (their data feed vendor upgraded to a new platform).

This is ADVFN's latest response (August 6th):

"Our first prototype of the new financials was release this morning. It is not available in a menu, but here is a link to the page:

NYSE:AA - Alcoa
http://ih.advfn.com/common/financial/NYSE/alcoa-AA/full-financials

NYSE:IBM - IBM
http://ih.advfn.com/common/financial/NYSE/ibm-international-business-machines-IBM/full-financials

I tried nasdaq companies but the feed does not seem to be working for these. To see financials for NYSE companies, change the url symbol just before /full-financials. Hope this alpha release helps. We are working to get the rest of the financials running soon as we can."

I have not heard anything else since then.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'm sure AdvFN will fix the problem. I did figure out how to get to the
> data, but I'm hesitant to implement it for two reasons:
>
> 1. AdvFN is going to make another change.
> 2. I don't know how their rollout of changes works. It obviously takes a
> few days.
>
> On Fri, Aug 9, 2013 at 5:25 AM, itrade4dough <itrade4dough@...> wrote:
>
> >
> > Thanks Randy. Your dedication is one to emulate.
> >
> > However, it presents a challenge for me, as well as many others here, to
> > find another site/location in which to gather 16 quarters of financial data
> > other than edgar.
> >
> > Do you think AdvFn will revert back to offering the data or is this it.
> > Which resembles the competition of offering 4-5 quarters only.
> >
> > Does there exist a database for the historical quarters for balance sheet
> > and income statements? This way it can be built upon utilizing the last 5
> > quarters from this point on?
> >
> > Thanks in advance.
> >
>

Fri Aug 9, 2013 10:09 am (PDT) . Posted by:

"MLawson" mlawson3

I missed the previous response from Aug 6...my mistake. Nothing to do, but wait, then. Thanks for re-posting, though.

--- In smf_addin@yahoogroups.com, "Russell M" <ru88ell@...> wrote:
>
> As I have mentioned in a previous post, ADVFN is working on it (their data feed vendor upgraded to a new platform).
>
> This is ADVFN's latest response (August 6th):
>
> "Our first prototype of the new financials was release this morning. It is not available in a menu, but here is a link to the page:
>
> NYSE:AA - Alcoa
> http://ih.advfn.com/common/financial/NYSE/alcoa-AA/full-financials
>
> NYSE:IBM - IBM
> http://ih.advfn.com/common/financial/NYSE/ibm-international-business-machines-IBM/full-financials
>
> I tried nasdaq companies but the feed does not seem to be working for these. To see financials for NYSE companies, change the url symbol just before /full-financials. Hope this alpha release helps. We are working to get the rest of the financials running soon as we can."
>
> I have not heard anything else since then.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > I'm sure AdvFN will fix the problem. I did figure out how to get to the
> > data, but I'm hesitant to implement it for two reasons:
> >
> > 1. AdvFN is going to make another change.
> > 2. I don't know how their rollout of changes works. It obviously takes a
> > few days.
> >
> > On Fri, Aug 9, 2013 at 5:25 AM, itrade4dough <itrade4dough@> wrote:
> >
> > >
> > > Thanks Randy. Your dedication is one to emulate.
> > >
> > > However, it presents a challenge for me, as well as many others here, to
> > > find another site/location in which to gather 16 quarters of financial data
> > > other than edgar.
> > >
> > > Do you think AdvFn will revert back to offering the data or is this it.
> > > Which resembles the competition of offering 4-5 quarters only.
> > >
> > > Does there exist a database for the historical quarters for balance sheet
> > > and income statements? This way it can be built upon utilizing the last 5
> > > quarters from this point on?
> > >
> > > Thanks in advance.
> > >
> >
>

Fri Aug 9, 2013 12:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can get the full history on the company with:

http://ih.advfn.com/common/financial/NYSE/alcoa-AA/full-financials?isfull=1&bsfull=1&cffull=1

However, I see nothing for quarterly financial statements. Just the annuals.

On Fri, Aug 9, 2013 at 9:27 AM, Russell M <ru88ell@gmail.com> wrote:

> As I have mentioned in a previous post, ADVFN is working on it (their data
> feed vendor upgraded to a new platform).
>
> This is ADVFN's latest response (August 6th):
>
> "Our first prototype of the new financials was release this morning. It is
> not available in a menu, but here is a link to the page:
>
> NYSE:AA - Alcoa
> http://ih.advfn.com/common/financial/NYSE/alcoa-AA/full-financials
>
> NYSE:IBM - IBM
>
> http://ih.advfn.com/common/financial/NYSE/ibm-international-business-machines-IBM/full-financials
>
> I tried nasdaq companies but the feed does not seem to be working for
> these. To see financials for NYSE companies, change the url symbol just
> before /full-financials. Hope this alpha release helps. We are working to
> get the rest of the financials running soon as we can."
>
> I have not heard anything else since then.
>

Fri Aug 9, 2013 5:38 am (PDT) . Posted by:

"Tze Wei," tzewei_79

I tried to add in but all it gives are ?NAME in the cells. Not sure what happened. My 2007 is ok.

Fri Aug 9, 2013 6:40 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Check out the Location errors item in the LINKS area of the group.

Otherwise, I'll need more details.

On Fri, Aug 9, 2013 at 5:38 AM, Tze Wei, <tzewei_79@yahoo.com.sg> wrote:

> I tried to add in but all it gives are ?NAME in the cells. Not sure what
> happened. My 2007 is ok.
>

Fri Aug 9, 2013 6:19 am (PDT) . Posted by:

"Tze Wei," tzewei_79

Hi,

I just switched to Excel 2010 and realized that some the above commands shows error now.

Example:
This works:
=RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement/?symbol=ca",1,"OperatingIncome&quot;)

But this won't:
=RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement/?symbol="&A12,1,"Operating Income")

replacing the ticker with &A12 shows error now. Is there a work around for this?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That's because "Sector SPDR" is in the title of the web page, and elsewhere
> before you get to where you want it to be, so you end up getting the first
> table cell after that.
>
> You'll need to do something like:
>
> =RCHGetTableCell("http://www.sectorspdr.com/eqsnaps/?do=snapshot&symbol="&A67,0,">Sector
> SPDR")
>
> ...but then you'll need to parse it out because they have the label and the
> sector in the same table cell.
>
> You do sometimes need to look at the source code of the web page to see how
> things are coded, instead of just guessing what you might need.
>
> On Thu, Feb 21, 2013 at 6:06 AM, Tze Wei, <tzewei_79@...> wrote:
>
> >
> > I tried =RCHGetTableCell("
> > http://www.sectorspdr.com/eqsnaps/?do=snapshot&symbol="&A67,1,"Sector
> > SPDR") where A67 = WIN, and the results is "15,693,991Volume"
> >
> > Actually I wanted to capture the sector of a stock now but I can't get
> > this to work. Is there any way to display the Sector SPDR?
> >
>

Fri Aug 9, 2013 7:47 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

If the second one won't work, it's because you have something other than
"ca" in cell A12. For example, if you cut and paste ticker symbols from a
web page, you can sometimes get an invisible "non-breaking space" character
on the end of the ticker symbol.

On Fri, Aug 9, 2013 at 6:19 AM, Tze Wei, <tzewei_79@yahoo.com.sg> wrote:

>
> I just switched to Excel 2010 and realized that some the above commands
> shows error now.
>
> Example:
> This works:
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol=ca
> ",1,"OperatingIncome&quot;)
>
> But this won't:
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol="&A12,1,"Operating
> Income")
>
> replacing the ticker with &A12 shows error now. Is there a work around for
> this?
>

Fri Aug 9, 2013 1:42 pm (PDT) . Posted by:

"cfelix781" cfelix781

I missed this. Thanks Randy, really appreciate it.

-Christian

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Most have examples in the message archives, which you can find with a
> search. For example, I found these two right away:
>
> =smfGetTagContent("http://finance.yahoo.com/q/pr?s=MMM","p",1,">Business
> Summary")
> =smfGetTagContent("http://finance.yahoo.com/q/pr?s=KO","a",1,"Website:")
>
> On Sat, Aug 3, 2013 at 4:51 PM, cfelix781 <cfelix781@...> wrote:
>
> >
> > Staying on that same web page, how would I modify your formula to extract
> > the following:
> >
> > 1) Description
> > 2) Website
> > 3) Industry Classification
> > 4) Phone & Fax Number
> > 5) Email & Physical Addresses
> >
> > to distinct cells in my worksheet?
> >
> > I've been tinkering around with the formula you provided, but haven't been
> > able to find the right combination to allow me to extract the information
> > I'm looking for.
> >
>

Fri Aug 9, 2013 9:25 pm (PDT) . Posted by:

"Jacob Jose" pepecan47



I have an array defined A11:B11 to A143:B143 with the formula =RCHGetYahooHistory(A2,,,,,,,"v")
How can I get:

- the last dividend increase percentage and the date?
- The forward dividend yield? (the frequency of dividends could be monthly, quarterly, etc)

For example:

KEY.TO last dividend increase: 5.88% date: 2012-11-20 forward yield:  0.18*12/59.84=3.61%
MMM 7.63% 2013-02-13 0.635*4/118.31=2.15% 
ADI 13.33% 2013-02-27 0.34*4/49=2.78%

Regards,
Jose L. Jacob

Fri Aug 9, 2013 10:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Here's what I get:

B2: =MIN(IF(B12:B142>B13:B143,ROW(B12:B142),999))
C2: =INDEX(B:B,B2)/INDEX(B:B,B2+1)-1
D2: =INDEX(A:A,B2)
E2:
=SUMPRODUCT(--(A12:A143>A12-350),--(LEN(A12:A143)>1))*INDEX(B:B,B2)/RCHGetYahooQuotes(A2,"l1")

B2 finds the list time an increase occurred, and needs to be array-entered.
C2 divides the dividend from that date by the previous, although I think it
really should be the projected 12-month dividend over the prior 12-month
dividend.
D2 find the date of the last increase.
E2 finds out how many dividend payments were paid in the last year and
multiplies it against the latest paid dividend.

However, do note that special dividends will throw all of that out of whack.

Are the dividends adjusted for stock splits?

On Fri, Aug 9, 2013 at 9:25 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> I have an array defined A11:B11 to A143:B143 with the formula =
> RCHGetYahooHistory(A2,,,,,,,"v")
> How can I get:
>
> - the last dividend increase percentage and the date?
> - The forward dividend yield? (the frequency of dividends could be
> monthly, quarterly, etc)
>
> For example:
>
> KEY.TO last dividend increase: 5.88% date: 2012-11-20 forward yield:
> 0.18*12/59.84=3.61%
> MMM 7.63% 2013-02-13 0.635*4/118.31=2.15%
> ADI 13.33% 2013-02-27 0.34*4/49=2.78%
>
>

Tidak ada komentar:

Posting Komentar