7 Messages
Digest #3506
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
>
>
=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.
>
>
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.
>
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.
>
>
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
=RCHGetElementNumbe
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.
>
>
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@
>
> 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 "RCHGetElement
> 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
>
> =RCHGetElementNumbe
> 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:
Posting Komentar