Kamis, 26 Februari 2015

[smf_addin] Digest Number 3338

8 Messages

Digest #3338

Messages

Wed Feb 25, 2015 5:21 am (PST) . Posted by:

hashky

Have you tried The DRiP Investing Resource Center - DRiP Information, Tools, And Forms http://www.dripinvesting.org/tools/tools.asp

Ron

Wed Feb 25, 2015 8:55 am (PST) . Posted by:

"Richard Milley" raminsj

Check with David Fish on Seeking Alpha (
http://seekingalpha.com/author/david-fish). He produces a monthly
spreadsheet "U.S.DividendsChampions" available here...
http://www.dripinvesting.org/tools/tools.asp.

This spreadsheet contains the info you are requesting for about 560
companies. Check with him for his sources.

Richard...

<richard.in.lacruz@gmail.com>

On Wed, Feb 25, 2015 at 1:46 AM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> er....I need something that I can grab with smf. Something that presents
> like dividata on the number of years it has pay dividend and the number of
> years it has increase in dividend.
>
>

Wed Feb 25, 2015 12:59 pm (PST) . Posted by:

daringler

Good info...Grab spreadsheet, then spend some time setting up a power query to combine the tabs, then slice and dice all you want!

Wed Feb 25, 2015 4:42 pm (PST) . Posted by:

taillear2

Hi,


Using the sample syntax and the function smfGetOptionQuotes :


IBM Mar 2015 ITM1 Call
IBM Mar 2015 ITM2 Call
IBM Mar 2015 ITM3 Call
IBM Mar 2015 ITM4 Call


I've noticed that in months where there is more than one expiration date (i.e. weekly expirations), the expirations will be indiscriminately mixed together. In the sample above, for instance, you will get the following expirations:


3/27/15, 3/13/15, 3/6/15, 3/27/15


On the other hand, the function will throw an error for months where there is only one expiration date available.


Is anyone aware of this and is there a workaround besides change the "ITMx" to an actual strike?


Thanks!




Wed Feb 25, 2015 4:46 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The ITMx and OTMx issue with the mixing of expiration dates is mentioned in
the documentation. In my version of the add-in, I've removed that
functionality. Instead, the smfGetOptionStrikes() function should be used.

Also, the "Mar" designation will not work unless you have a later version
of the add-in, because as of February of this year, they changed the
monthly expiration dates from Saturdays to Fridays, so that they align with
the weekly options.

On Wed, Feb 25, 2015 at 5:11 PM, cheval66@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Using the sample syntax and the function smfGetOptionQuotes :
>
> IBM Mar 2015 ITM1 Call
>
> IBM Mar 2015 ITM2 Call
>
> IBM Mar 2015 ITM3 Call
>
> IBM Mar 2015 ITM4 Call
>
> I've noticed that in months where there is more than one expiration date
> (i.e. weekly expirations), the expirations will be indiscriminately mixed
> together. In the sample above, for instance, you will get the following
> expirations:
>
> 3/27/15, 3/13/15, 3/6/15, 3/27/15
>
> On the other hand, the function will throw an error for months where there
> is only one expiration date available.
>
> Is anyone aware of this and is there a workaround besides change the
> "ITMx" to an actual strike?
>
>

Wed Feb 25, 2015 5:46 pm (PST) . Posted by:

rharmelink

Some updated files on the "Works in Progress" web page (http://ogres-crypt.com/SMF/Works-In-Progress http://ogres-crypt.com/SMF/Works-In-Progress/):


Filename Last Uploaded Description 0-Change-log.html 2015-02-25 05:00 PM Log of changes made to the add-in or other files. RCH_Stock_Market_Functions-2.1.2015.02.21.zip 2015-02-25 05:00 PM Beta copy of the add-in. This contains all the add-in files that I am currently using in my day-to-day processing. RCHGetElementNumber-Element-Definitions.xls 2015-02-25 05:00 PM Documentation of element definitions, as of 2015-02-07 smf-elements-1.txt 2015-02-25 05:00 PM Obsoleted all MSN data elements due to MSN dropping the data smf-elements-9.txt 2015-02-06 08:45 AM Fixed elements #701-703/709/715; Added elements #718-721
Fixed elements #1195-1214 (Barchart Momentum)

There are mostly option-related changes:
smfGetOptionQuotes, smfGetYahooOptionQuote, smfGetOptionExpirations, and smfGetOptionStrikes have all been reset back to the old Yahoo format.

smfGetOptionExpiry has some additions Mx and Wx designations, as well as an update for the Friday alignment of the monthly option expirations. However, note that an expiration like 4/3/2015 is still incorrect, because I don't have any holiday coding to account for things like Good Friday causing the expiration to revert to Thursday. I don't ever forsee adding something like that.

smfGetOptionExpirations for OptionsXPress has been updated, because of changes they made to their web page layout So now, functions like these should work:


=smfGetOptionExpirations("SPY","Y")
=smfGetOptionStrikes("SPY";,DATE(2015,2,27),"C","Y",1)
=smfGetOptionQuotes("SPY 2/27 2015 $209.50 Call","lbax")
=smfGetOptionQuotes("SPY Mar 2015 $210 Call","lbax")


Let me know if you run into any issues.

Wed Feb 25, 2015 6:19 pm (PST) . Posted by:

cruel_toad

Is there any logic in the SMF itself to cache web pages that are retrieved via RCHGetTableCell? I had an odd problem where I was getting old data from GuruFocus, and nothing I could do - not even clearing the IE cache (just in case that was being used under the hood) could force SMF to go to the server to retrieve the page. Interestingly enough, cells that used RCHGetElementNumber did trigger a request to the server when refreshed.


I finally got SMF to hit the server by adding the port number to the URL, thus technically changing the URL and causing a cache miss. If push comes to shove, I can always add something like "var=" & rand() to the URL to force a new get on each re-evaluation, but I'd like to avoid that if possible.

Wed Feb 25, 2015 6:27 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yes, there is.

There are 1000 web page storage slots in the add-in. When you extract data
from a web page, it first retrieves the web page and saves it. Then it
extracts the data from the saved copy of the web page.

If you extract something else from that web page, it extracts it from the
saved copy of the web page. I did it this way so that the web page wouldn't
need to be continuously retrieved. The Internet access is typically the
biggest bottleneck of the extraction process.

You can purge the 1000 web page slots by either:

1. Exiting and restarting EXCEL
2. Running the smfForceRecalculation macro (see "Tips and FAQs" web page
for information on this macro)

On Wed, Feb 25, 2015 at 7:19 PM, baseball@reverenddave.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is there any logic in the SMF itself to cache web pages that are
> retrieved via RCHGetTableCell? I had an odd problem where I was getting old
> data from GuruFocus, and nothing I could do - not even clearing the IE
> cache (just in case that was being used under the hood) could force SMF to
> go to the server to retrieve the page. Interestingly enough, cells that
> used RCHGetElementNumber did trigger a request to the server when
> refreshed.
>
> I finally got SMF to hit the server by adding the port number to the URL,
> thus technically changing the URL and causing a cache miss. If push comes
> to shove, I can always add something like "var=" & rand() to the URL to
> force a new get on each re-evaluation, but I'd like to avoid that if
> possible.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.30

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)