Sabtu, 23 Mei 2015

[smf_addin] Digest Number 3414

10 Messages

Digest #3414

Messages

Fri May 22, 2015 8:02 am (PDT) . Posted by:

cgrauballe


Does anyone know if it is possible to extract data from this one for a given stock? Pretty need tool
Fama-French Calculator / Beta http://financetools.idc.ac.il/app/ff-calc-en


Fama-French Calculator / Beta http://financetools.idc.ac.il/app/ff-calc-en Fama-French Calculator /Beta



View on financetools.idc.ac.il http://financetools.idc.ac.il/app/ff-calc-en
Preview by Yahoo



Fri May 22, 2015 8:07 am (PDT) . Posted by:

"tikigod18" maybesew2001


I'm sure you could; I guess it's just one more tool in a box that I personally have full enough. I couldn't tell you how to use it...sorry.

Amy


-----Original Message-----
From: cgrauballe@yahoo.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, May 22, 2015 11:02 am
Subject: [smf_addin] Fama french factors

Does anyone know if it is possible to extract data from this one for a given stock? Pretty need tool

Fama-French Calculator / Beta















Fama-French Calculator / Beta
Fama-Fr ench Calculator /Beta










View on financetools.idc.ac.il



Preview by Yahoo


















Fri May 22, 2015 8:25 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, don't see a way...

On Fri, May 22, 2015 at 8:02 AM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Does anyone know if it is possible to extract data from this one for a
> given stock? Pretty need tool
>
> Fama-French Calculator / Beta
> <http://financetools.idc.ac.il/app/ff-calc-en>
>

Fri May 22, 2015 8:30 am (PDT) . Posted by:

"Peter Urbani" purbani1

Pretty easy to roll your own - see
http://www.efficientfrontier.com/ef/101/roll101.htm

*Peter Urbani*

[image: South Africa] +27 76 483 3919

[image: View my profile on LinkedIn]LinkedIn Profile
<http://nz.linkedin.com/in/peterurbani>

Skype peterurbani

On Fri, May 22, 2015 at 5:25 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Sorry, don't see a way...
>
> On Fri, May 22, 2015 at 8:02 AM, cgrauballe@yahoo.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>> Does anyone know if it is possible to extract data from this one for a
>> given stock? Pretty need tool
>>
>> Fama-French Calculator / Beta
>> <http://financetools.idc.ac.il/app/ff-calc-en>
>>
>
>
>

Fri May 22, 2015 11:11 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Any help will be greatly appreciated,

Thanks, Kermit

I am trying to pull the dividend yield from this webpage:

https://dividata.com/stock/AGNC

The dividend yield is in the first table and I have hilited it below.

Here is the formula I used in the past but the page appears to have changed:
Cell F7 has the symbol. In this case it is AGNC. But all symbols return
error in the cell E7

=IF(RCHGetTableCell("http://dividata.com/stock/"&F7,1,"Dividend
Yield:")="n/a",RCHGetTableCell("http://dividata.com/stock/"&F7,1,"52 Week
Div. Yield:"),RCHGetTableCell("http://dividata.com/stock/"&F7,1,"Dividend
Yield:"))


<table id="stocktopbody">
<tr>
<td class="descrip"><span title="Closing price of stock on prior
trading day.">Last Close:</span></td>
<td class="number">$20.72</td>
<td class="descrip"><span title="Value of latest dividend multipled
by number of times dividends are typically paid per year.">Annual
Dividend:</span></td>
<td class="number">$1.98</td>
</tr>
<tr>
<td class="descrip"><span title="Date on which dividend was last
paid, or date on which next one will be paid.">Pay Date:</span></td>
<td class="number">06/05/15</td>
<td class="descrip"><span title="Value of latest dividend multipled
by number of times dividends are typically paid per year, divided by closing
price of stock on prior trading day.">Dividend Yield:</span></td>
<td class="number">9.56%</td>
</tr>
<tr>
<td class="descrip"><span title="Stock must be purchased before this
date in order to receive current dividend or stock split.">Ex-Dividend
Date:</span></td>
<td class="number">05/27/15</td>
<td class="descrip"><span title="Number of consecutive years a stock
has paid dividends.">Years Paying:</span></td>
<td class="number">6</td>
</tr>
</table>

Fri May 22, 2015 11:39 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It looks like they've coded the web page to ignore the normal method I use
to retrieve the source code of a web page -- a zero length string is
returned.

This works on my machine, but I have no idea how reliable it would be on
other versions of EXCEL or IE:

=RCHGetTableCell("http://dividata.com/stock/"&F6,1,"Dividend
Yield:",,,,,,,,2)

On Fri, May 22, 2015 at 11:11 AM, 'Kermit W. Prather' kermitp@... wrote:

>
> Any help will be greatly appreciated,
>
>
>
> Thanks, Kermit
>
>
>
> I am trying to pull the dividend yield from this webpage:
>
>
>
> https://dividata.com/stock/AGNC
>
>
>
> The dividend yield is in the first table and I have hilited it below.
>
>
>
> Here is the formula I used in the past but the page appears to have
> changed: Cell F7 has the symbol. In this case it is AGNC. But all symbols
> return error in the cell E7
>
>
>
> =IF(RCHGetTableCell("http://dividata.com/stock/"&F7,1,"Dividend
> Yield:")="n/a",RCHGetTableCell("http://dividata.com/stock/"&F7,1,"52 Week
> Div. Yield:"),RCHGetTableCell("http://dividata.com/stock/"&F7,1,"Dividend
> Yield:"))
>
>
>
>
>
> <table id="stocktopbody">
>
> <tr>
>
> <td class="descrip"><span title="Closing price of stock on prior
> trading day.">Last Close:</span></td>
>
> <td class="number">$20.72</td>
>
> <td class="descrip"><span title="Value of latest dividend
> multipled by number of times dividends are typically paid per year.">Annual
> Dividend:</span></td>
>
> <td class="number">$1.98</td>
>
> </tr>
>
> <tr>
>
> <td class="descrip"><span title="Date on which dividend was last
> paid, or date on which next one will be paid.">Pay Date:</span></td>
>
> <td class="number">06/05/15</td>
>
> <td class="descrip"><span title="Value of latest dividend
> multipled by number of times dividends are typically paid per year,
> divided by closing price of stock on prior trading day.">Dividend Yield:</
> span></td>
>
> <td class="number">9.56%</td>
>
> </tr>
>
> <tr>
>
> <td class="descrip"><span title="Stock must be purchased before
> this date in order to receive current dividend or stock split.">Ex-Dividend
> Date:</span></td>
>
> <td class="number">05/27/15</td>
>
> <td class="descrip"><span title="Number of consecutive years a
> stock has paid dividends.">Years Paying:</span></td>
>
> <td class="number">6</td>
>
> </tr>
>
> </table>
>
>
>
>

Fri May 22, 2015 12:03 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Worked great

Thanks

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, May 22, 2015 2:39 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Error trying to pull Dividend yield from dividata.com


It looks like they've coded the web page to ignore the normal method I use to retrieve the source code of a web page -- a zero length string is returned.
This works on my machine, but I have no idea how reliable it would be on other versions of EXCEL or IE:

=RCHGetTableCell("http://dividata.com/stock/"&F6,1,"Dividend Yield:",,,,,,,,2)

On Fri, May 22, 2015 at 11:11 AM, 'Kermit W. Prather' kermitp@... wrote:

Any help will be greatly appreciated,

Thanks, Kermit

I am trying to pull the dividend yield from this webpage:

https://dividata.com/stock/AGNC

The dividend yield is in the first table and I have hilited it below.

Here is the formula I used in the past but the page appears to have changed: Cell F7 has the symbol. In this case it is AGNC. But all symbols return error in the cell E7

=IF(RCHGetTableCell("http://dividata.com/stock/"&F7,1,"Dividend Yield:")="n/a",RCHGetTableCell("http://dividata.com/stock/"&F7,1,"52 Week Div. Yield:"),RCHGetTableCell("http://dividata.com/stock/"&F7,1,"Dividend Yield:"))


<table id="stocktopbody">
<tr>
<td class="descrip"><span title="Closing price of stock on prior trading day.">Last Close:</span></td>
<td class="number">$20.72</td>
<td class="descrip"><span title="Value of latest dividend multipled by number of times dividends are typically paid per year.">Annual Dividend:</span></td>
<td class="number">$1.98</td>
</tr>
<tr>
<td class="descrip"><span title="Date on which dividend was last paid, or date on which next one will be paid.">Pay Date:</span></td>
<td class="number">06/05/15</td>
<td class="descrip"><span title="Value of latest dividend multipled by number of times dividends are typically paid per year, divided by closing price of stock on prior trading day.">Dividend Yield:</span></td>
<td class="number">9.56%</td>
</tr>
<tr>
<td class="descrip"><span title="Stock must be purchased before this date in order to receive current dividend or stock split.">Ex-Dividend Date:</span></td>
<td class="number">05/27/15</td>
<td class="descrip"><span title="Number of consecutive years a stock has paid dividends.">Years Paying:</span></td>
<td class="number">6</td>
</tr>
</table>




Fri May 22, 2015 8:56 pm (PDT) . Posted by:

sundeep_chadha

When I put in a ticker for the above template, I get Error in the following rows. I have the latest smf add in installed and use Excel 2013


Income statement -> Net Income (Row #29)

Cash Flow statement -> Other Cashflows from Investing Activities (Row #90)
Cash Flow Statement -> Effect Of Exchange Rate Changes (Row #98)


The values that get populated look ok though



Please help


Fri May 22, 2015 9:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. They changed the labels on those three line items
on their web page. I updated the formulas and uploaded the updated workbook
to the FILES area of the Yahoo group.

On Fri, May 22, 2015 at 8:54 PM, sundeep_chadha@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> When I put in a ticker for the above template, I get Error in the
> following rows. I have the latest smf add in installed and use Excel 2013
>
> Income statement -> Net Income (Row #29)
>
> Cash Flow statement -> Other Cashflows from Investing Activities (Row #90)
>
> Cash Flow Statement -> Effect Of Exchange Rate Changes (Row #98)
>
> The values that get populated look ok though
>
> Please help
>

Fri May 22, 2015 9:13 pm (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Templates and Examples/RCHGetTableCell/RCHGetTableCell-Template-Yahoo-Financial-Statements.xls
Uploaded by : rharmelink <rharmelink@gmail.com>
Description : A template that shows an example of using the RCHGetTableCell() function to retrieve the quarterly and annual financial statements data (Cash Flow, Balance Sheet, and Income Statement) from Yahoo Finance. Updated for several line item changes on the web page.

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-Yahoo-Financial-Statements.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

rharmelink <rharmelink@gmail.com>

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.41

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)