Rabu, 09 September 2015

[smf_addin] Digest Number 3506[1 Attachment]

7 Messages

Digest #3506
1a
Re: ETF.com data by "Randy Harmelink" rharmelink
2a
Option Liquidity by chrishervochon
2b
Re: Option Liquidity by "Randy Harmelink" rharmelink
2c
Re: Option Liquidity by "Randy Harmelink" rharmelink
2d
Re: Option Liquidity by "Chris Hervochon" chrishervochon
3a
Update to the RCH Index by "George Toscano" gtoscano2005
3b
Re: Update to the RCH Index by "Randy Harmelink" rharmelink

Messages

Tue Sep 8, 2015 2:00 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfConvertData(smfGetTagContent("http://www.etf.com/"&A1,"span",1,">Assets
under Management"))

On Tue, Sep 8, 2015 at 12:21 AM, thomas777crown@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Just wanted to ask something on this question already asked what if you
> had a Ticker in A1 and wanted to pull data from etf.com on Assets Under
> Management
>
>

Tue Sep 8, 2015 4:33 pm (PDT) . Posted by:

chrishervochon

Is there an easy way to get the 100 highest open interest underlyings? The Yahoo Finance site has the list, and using a web query in Excel doesn't work. Thinking there has to be an easy way to use the add-in to get this.

Tue Sep 8, 2015 7:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not easy, because the data is all within JavaScript code. It required a
cascading extraction -- finding easy successive item is based on the
previous item. However, I tried a "quick and dirty" extraction and have
attached the worksheet. Check it for accuracy.

On Tue, Sep 8, 2015 at 4:32 PM, chervochon@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is there an easy way to get the 100 highest open interest underlyings? The
> Yahoo Finance site has the list, and using a web query in Excel doesn't
> work. Thinking there has to be an easy way to use the add-in to get this.
>
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)

Tue Sep 8, 2015 7:47 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

PS: If you want to convert the Yahoo option ticker symbol into one that can
be used with smfGetOptionQuotes(), something like this should do the trick:

=LEFT($B3,LEN($B3)-15)&"
"&LEFT(RIGHT($B3,13),2)&"/"&LEFT(RIGHT($B3,11),2)&"
20"&LEFT(RIGHT($B3,15),2)&TEXT(RIGHT($B3,8)/1000," $0.00
")&IF(LEFT(RIGHT($B3,9),1)="C","Call","Put")

On Tue, Sep 8, 2015 at 4:32 PM, chervochon@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is there an easy way to get the 100 highest open interest underlyings? The
> Yahoo Finance site has the list, and using a web query in Excel doesn't
> work. Thinking there has to be an easy way to use the add-in to get this.
>

Tue Sep 8, 2015 8:17 pm (PDT) . Posted by:

"Chris Hervochon" chrishervochon

That's awesome. Thanks, Randy!

Sent from my iPhone

> On Sep 8, 2015, at 10:47 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> PS: If you want to convert the Yahoo option ticker symbol into one that can be used with smfGetOptionQuotes(), something like this should do the trick:
>
> =LEFT($B3,LEN($B3)-15)&" "&LEFT(RIGHT($B3,13),2)&"/"&LEFT(RIGHT($B3,11),2)&" 20"&LEFT(RIGHT($B3,15),2)&TEXT(RIGHT($B3,8)/1000," $0.00 ")&IF(LEFT(RIGHT($B3,9),1)="C","Call","Put")
>
>> On Tue, Sep 8, 2015 at 4:32 PM, chervochon@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>> Is there an easy way to get the 100 highest open interest underlyings? The Yahoo Finance site has the list, and using a web query in Excel doesn't work. Thinking there has to be an easy way to use the add-in to get this.
>
>

Tue Sep 8, 2015 6:39 pm (PDT) . Posted by:

"George Toscano" gtoscano2005

HI Randy,I am running Microsoft Excel 2007 on Windows 7 Home Premium. Ioriginally downloaded this SMF about 4 years ago The version I have has "RCHGetElementNumber()Element Definitions as of 2012-02-12" at the top of the spreadsheet.  I know some of these lookups do not workanymore.  Do you have a more recentupdate to this lookup key (index) that we can download?Examples of what not no longer work
=RCHGetElementNumber(B5,342) 333-342 no longer work. In cell B5 I have T

Thisused to work but maybe the MSN page no longer works.

Specifically I am looking to get full year EPS ideally for the last 10 years.Any advice is helpful and thank you for building this tool and helping us with our questions.
Kindly,

George

Tue Sep 8, 2015 7:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Updated files are in the "Works in Progress" folder on the add-in web site:

http://ogres-crypt.com/SMF/Works-In-Progress/

If you install the 2.1.2015.08.03 version from there, you should get all
the element definition updates that have been made, as well as the
corresponding XLS file that documents the latest definitions of the
elements.

As far as EPS for 10 years, you could go to AdvFN for that. However, over
the past few years, they have had some reliability problems. I've moved
over to GuruFocus as my "go to" web site. I'm a subscriber. However,
non-subscribers are limited as to which data items and how many years or
quarters of data they can retrieve.

Another option is to use the MorningStar CSV files, such as:

=smfGetCSVFile("
http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")

However, there too, I think non-members are limited to 5 years, while
members can access 10 years.

On Tue, Sep 8, 2015 at 5:58 PM, George Toscano gtoscano2005@... wrote:

>
> HI Randy,
> I am running Microsoft Excel 2007 on Windows 7 Home Premium. I originally
> downloaded this SMF about 4 years ago The version I have has "RCHGetElementNumber()
> Element Definitions as of 2012-02-12" at the top of the spreadsheet. I
> know some of these lookups do not work anymore. Do you have a more recent
> update to this lookup key (index) that we can download?
> Examples of what not no longer work
>
> =RCHGetElementNumber(B5, 342) 333-342 no longer work. In cell B5 I have T
> This used to work but maybe the MSN page no longer works.
>
> Specifically I am looking to get full year EPS ideally for the last 10
> years.
> Any advice is helpful and thank you for building this tool and helping us
> with our questions.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar