15 Messages
Digest #2993
4a
How to easily retrieve information in a UL/LI series of statements by "Kermit W. Prather" kermitpra
4b
Re: How to easily retrieve information in a UL/LI series of statemen by "Randy Harmelink" rharmelink
4c
Re: How to easily retrieve information in a UL/LI series of statemen by "Kermit W. Prather" kermitpra
4d
Re: How to easily retrieve information in a UL/LI series of statemen by "Randy Harmelink" rharmelink
Messages
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 : /Documentation/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Documentation/0-READ-ME.html
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>
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 : /Documentation/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Documentation/0-READ-ME.html
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>
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 : /Add-In Files/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Add-In%20Files/0-READ-ME.html
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>
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 : /Add-In Files/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Add-In%20Files/0-READ-ME.html
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>
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 : /Works-In-Progress/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Works-In-Progress/0-READ-ME.html
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>
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 : /Works-In-Progress/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Works-In-Progress/0-READ-ME.html
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>
Thu Mar 6, 2014 6:52 am (PST) . Posted by:
"Henry Weber" hank_571
Hi Randy...
Thanks for your help (and prompt reply). Your suggested reference was
just what I was looking for.
Hank
P.S.
Your code (in RCHGetYahooHistory) is beautiful !! It should be framed
and hung on a wall.
Thanks for your help (and prompt reply). Your suggested reference was
just what I was looking for.
Hank
P.S.
Your code (in RCHGetYahooHistory) is beautiful !! It should be framed
and hung on a wall.
Thu Mar 6, 2014 9:27 am (PST) . Posted by:
ttizzle2
That's *miles* simpler than what I was thinking! Had to put the Sheets and Windows within a Workbooks With block and it works great!
I see a lot of recoding in my future...
Thanks a ton.
a.
I see a lot of recoding in my future...
Thanks a ton.
a.
Thu Mar 6, 2014 12:45 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, which SMF ADDIN function would I use to place the dividend
information from this link?
I have looked at the smfGetTagContent function but I don't know if that is
the best function to use because I am not sure how many row there will be.
It depends on how long the symbol has been paying dividends.
Thanks, Kermit
I have looked through the documentation and could not spot a function to
easily retrieve the below information into
a 2 column table like below. The information is in a User List (UL)
EX-Dividend Dates
Payout Amount
2/6/2014
$0.95
11/6/2013
$0.95
8/7/2013
$0.95
URL - http://dividata.com/stock/IBM/dividend
Part of the webpage I want to retrieve.
<div id="divhisbotleft">
<p class="divhistitle">Dividend Payment History for <a
href="/stock/IBM">International Business Machines Corporation (IBM)</a>:</p>
<div class="histhead">
<p>Ex-Dividend Date</p>
<p>Dividend Amount</p>
</div>
<ul class="histdetail">
<li><p>Feb 06, 2014</p> <p>$0.95</p></li>
<li><p>Nov 06, 2013</p> <p>$0.95</p></li>
<li><p>Aug 07, 2013</p> <p>$0.95</p></li>
<li><p>May 08, 2013</p> <p>$0.95</p></li>
<li><p>Feb 06, 2013</p> <p>$0.85</p></li>
<li><p>Nov 07, 2012</p> <p>$0.85</p></li>
<li><p>Aug 08, 2012</p> <p>$0.85</p></li>
<li><p>May 08, 2012</p> <p>$0.85</p></li>
<li><p>Feb 08, 2012</p> <p>$0.75</p></li>
<li><p>Nov 08, 2011</p> <p>$0.75</p></li>
<li><p>Aug 08, 2011</p> <p>$0.75</p></li>
<li><p>May 06, 2011</p> <p>$0.75</p></li>
<li><p>Feb 08, 2011</p> <p>$0.65</p></li>
<li><p>Nov 08, 2010</p> <p>$0.65</p></li>
<li><p>Aug 06, 2010</p> <p>$0.65</p></li>
<li><p>May 06, 2010</p> <p>$0.65</p></li>
<li><p>Feb 08, 2010</p> <p>$0.55</p></li>
<li><p>Nov 06, 2009</p> <p>$0.55</p></li>
<li><p>Aug 06, 2009</p> <p>$0.55</p></li>
<li><p>May 06, 2009</p> <p>$0.55</p></li>
<li><p>Feb 06, 2009</p> <p>$0.50</p></li>
<li><p>Nov 06, 2008</p> <p>$0.50</p></li>
<li><p>Aug 06, 2008</p> <p>$0.50</p></li>
<li><p>May 07, 2008</p> <p>$0.50</p></li>
<li><p>Feb 06, 2008</p> <p>$0.40</p></li>
<li><p>Nov 07, 2007</p> <p>$0.40</p></li>
<li><p>Aug 08, 2007</p> <p>$0.40</p></li>
<li><p>May 08, 2007</p> <p>$0.40</p></li>
<li><p>Feb 07, 2007</p> <p>$0.30</p></li>
<li><p>Nov 08, 2006</p> <p>$0.30</p></li>
<li><p>Aug 08, 2006</p> <p>$0.30</p></li>
<li><p>May 08, 2006</p> <p>$0.30</p></li>
<li><p>Feb 08, 2006</p> <p>$0.20</p></li>
<li><p>Nov 08, 2005</p> <p>$0.20</p></li>
<li><p>Aug 08, 2005</p> <p>$0.20</p></li>
<li><p>May 06, 2005</p> <p>$0.20</p></li>
<li><p>Feb 08, 2005</p> <p>$0.18</p></li>
<li><p>Nov 08, 2004</p> <p>$0.18</p></li>
<li><p>Aug 06, 2004</p> <p>$0.18</p></li>
<li><p>May 06, 2004</p> <p>$0.18</p></li>
<li><p>Feb 06, 2004</p> <p>$0.16</p></li>
<li><p>Nov 06, 2003</p> <p>$0.16</p></li>
<li><p>Aug 06, 2003</p> <p>$0.16</p></li>
<li><p>May 07, 2003</p> <p>$0.16</p></li>
<li><p>Feb 06, 2003</p> <p>$0.15</p></li>
<li><p>Nov 06, 2002</p> <p>$0.15</p></li>
<li><p>Aug 07, 2002</p> <p>$0.15</p></li>
<li><p>May 08, 2002</p> <p>$0.15</p></li>
<li><p>Feb 06, 2002</p> <p>$0.14</p></li>
<li><p>Nov 07, 2001</p> <p>$0.14</p></li>
<li><p>Aug 08, 2001</p> <p>$0.14</p></li>
<li><p>May 08, 2001</p> <p>$0.14</p></li>
<li><p>Feb 07, 2001</p> <p>$0.13</p></li>
<li><p>Nov 08, 2000</p> <p>$0.13</p></li>
<li><p>Aug 08, 2000</p> <p>$0.13</p></li>
<li><p>May 08, 2000</p> <p>$0.13</p></li>
<li><p>Feb 08, 2000</p> <p>$0.12</p></li>
<li><p>Nov 08, 1999</p> <p>$0.12</p></li>
<li><p>Aug 06, 1999</p> <p>$0.12</p></li>
<li><p>May 06, 1999</p> <p>$0.12</p></li>
<li><p>Feb 08, 1999</p> <p>$0.11</p></li>
<li><p>Nov 06, 1998</p> <p>$0.11</p></li>
<li><p>Aug 06, 1998</p> <p>$0.11</p></li>
<li><p>May 06, 1998</p> <p>$0.11</p></li>
<li><p>Feb 06, 1998</p> <p>$0.10</p></li>
<li><p>Nov 06, 1997</p> <p>$0.10</p></li>
<li><p>Aug 07, 1997</p> <p>$0.10</p></li>
<li><p>Feb 06, 1997</p> <p>$0.09</p></li>
<li><p>Nov 06, 1996</p> <p>$0.09</p></li>
<li><p>Aug 07, 1996</p> <p>$0.09</p></li>
<li><p>May 08, 1996</p> <p>$0.09</p></li>
<li><p>Feb 07, 1996</p> <p>$0.06</p></li>
<li><p>Nov 08, 1995</p> <p>$0.06</p></li>
<li><p>Aug 08, 1995</p> <p>$0.06</p></li>
<li><p>May 04, 1995</p> <p>$0.06</p></li>
<li><p>Feb 06, 1995</p> <p>$0.06</p>
information from this link?
I have looked at the smfGetTagContent function but I don't know if that is
the best function to use because I am not sure how many row there will be.
It depends on how long the symbol has been paying dividends.
Thanks, Kermit
I have looked through the documentation and could not spot a function to
easily retrieve the below information into
a 2 column table like below. The information is in a User List (UL)
EX-Dividend Dates
Payout Amount
2/6/2014
$0.95
11/6/2013
$0.95
8/7/2013
$0.95
URL - http://dividata.com/stock/IBM/dividend
Part of the webpage I want to retrieve.
<div id="divhisbotl
<p class="
href="/
<div class="
<p>Ex-
<p>Dividend Amount</p>
</div>
<ul class="
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><
<li><