10 Messages
Digest #3100
Messages
Sun Jun 22, 2014 2:56 am (PDT) . Posted by:
holmberg_tommy
Hi Randy,
Hopefully you could help me. I would like to add info the type of the industry from FT.com business. You may already know but it's showed on business profile tab (example please see http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AAL:NSQ http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AAL:NSQ ).
What kind of text should I input to my table?
Thanks in advance.
Tommy
Hopefully you could help me. I would like to add info the type of the industry from FT.com business. You may already know but it's showed on business profile tab (example please see http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AAL:NSQ http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AAL:NSQ ).
What kind of text should I input to my table?
Thanks in advance.
Tommy
Sun Jun 22, 2014 9:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The data isn't in a table. Try:
=smfGetTagContent("
http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AAL:NSQ
","span",1,">Industry")
On Sun, Jun 22, 2014 at 2:56 AM, holmberg_tommy@... wrote:
> Hopefully you could help me. I would like to add info the type of the
> industry from FT.com business. You may already know but it's showed on
> business profile tab (example please see
> http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AAL:NSQ
> ).
>
> What kind of text should I input to my table?
>
=smfGetTagContent("
http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AAL:NSQ
","span",1,">Industry")
On Sun, Jun 22, 2014 at 2:56 AM, holmberg_tommy@... wrote:
> Hopefully you could help me. I would like to add info the type of the
> industry from FT.com business. You may already know but it's showed on
> business profile tab (example please see
> http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AAL:NSQ
> ).
>
> What kind of text should I input to my table?
>
Sun Jun 22, 2014 11:18 am (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
I have no idea how to reference this number on the webpage. Trying to pull
the Institutional Ownership and there's only one place I can find it clearly
stated.
The webpage is: www.gurufocus.com/ShortInterest/mmm
There are 3 boxes with the number I want "above" the descriptor.
How would you get that?
Thanks!
Jim
I have no idea how to reference this number on the webpage. Trying to pull
the Institutional Ownership and there's only one place I can find it clearly
stated.
The webpage is: www.gurufocus.
There are 3 boxes with the number I want "above" the descriptor.
How would you get that?
Thanks!
Jim
Sun Jun 22, 2014 12:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
No worries. Try:
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Short
Percentage"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Institutional
Ownership"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Insider
Ownership"))
On Sun, Jun 22, 2014 at 11:18 AM, 'Jim Ranum' amt2100@... wrote:
>
>
> I have no idea how to reference this number on the webpage. Trying to pull
> the *Institutional Ownership* and there's only one place I can find it
> clearly stated.
>
> The webpage is: www.gurufocus.com/ShortInterest/mmm
>
> There are 3 boxes with the number I want "above" the descriptor.
>
> How would you get that?
>
>
>
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Short
Percentage"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Institutional
Ownership"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/ShortInterest/mmm","
Ownership"
On Sun, Jun 22, 2014 at 11:18 AM, 'Jim Ranum' amt2100@... wrote:
>
>
> I have no idea how to reference this number on the webpage. Trying to pull
> the *Institutional Ownership* and there's only one place I can find it
> clearly stated.
>
> The webpage is: www.gurufocus.
>
> There are 3 boxes with the number I want "above" the descriptor.
>
> How would you get that?
>
>
>
Sun Jun 22, 2014 12:58 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Very cool. I figured it would require the "-1", but what does "h1" do?
I don't see an h1 on the page.
Thanks!
Jim
On Jun 22, 2014 3:26 PM, "Randy Harmelink rharmelink@gmail.com
[smf_addin]" <smf_addin@yahoogroups.com> wrote:
>
>
> No worries. Try:
>
> =smfConvertData(smfGetTagContent("
> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Short Percentage"))
> =smfConvertData(smfGetTagContent("
> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Institutional
> Ownership"))
> =smfConvertData(smfGetTagContent("
> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Insider Ownership"))
>
> On Sun, Jun 22, 2014 at 11:18 AM, 'Jim Ranum' amt2100@... wrote:
>
>>
>>
>> I have no idea how to reference this number on the webpage. Trying to
>> pull the *Institutional Ownership* and there's only one place I can find
>> it clearly stated.
>>
>> The webpage is: www.gurufocus.com/ShortInterest/mmm
>>
>> There are 3 boxes with the number I want "above" the descriptor.
>>
>> How would you get that?
>>
>>
>>
>
>
I don't see an h1 on the page.
Thanks!
Jim
On Jun 22, 2014 3:26 PM, "Randy Harmelink rharmelink@gmail.com
[smf_addin]" <smf_addin@yahoogroups.com> wrote:
>
>
> No worries. Try:
>
> =smfConvertData(smfGetTagContent("
> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Short Percentage"))
> =smfConvertData(smfGetTagContent("
> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Institutional
> Ownership"))
> =smfConvertData(smfGetTagContent("
> http://www.gurufocus.com/ShortInterest/mmm","
>
> On Sun, Jun 22, 2014 at 11:18 AM, 'Jim Ranum' amt2100@... wrote:
>
>>
>>
>> I have no idea how to reference this number on the webpage. Trying to
>> pull the *Institutional Ownership* and there's only one place I can find
>> it clearly stated.
>>
>> The webpage is: www.gurufocus.
>>
>> There are 3 boxes with the number I want "above" the descriptor.
>>
>> How would you get that?
>>
>>
>>
>
>
Sun Jun 22, 2014 1:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's the HTML tag the data is within:
<h1 style="font-family: 'steelfish';font-size: 36px;letter-spacing: 3px;">
77%</h1>
<h4><a class="modally popup_window" alt="InstitutionalOwnership"
id="InstitutionalOwnership" href="#">Institutional Ownership</a></h4>
On Sun, Jun 22, 2014 at 12:58 PM, Jim Ranum amt2100@... wrote:
> Very cool. I figured it would require the "-1", but what does "h1" do?
> I don't see an h1 on the page.
> On Jun 22, 2014 3:26 PM, "Randy Harmelink rharmelink@..."
> <rharmelink@gmail.com> wrote:
>
>> No worries. Try:
>>
>> =smfConvertData(smfGetTagContent("
>> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Short Percentage"))
>> =smfConvertData(smfGetTagContent("
>> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Institutional
>> Ownership"))
>> =smfConvertData(smfGetTagContent("
>> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Insider
>> Ownership"))
>>
>
<h1 style="font-family: 'steelfish';font-size: 36px;letter-spacing: 3px;">
77%</h1>
<h4><a class="modally popup_window" alt="InstitutionalOwnership"
id="InstitutionalOwnership" href="#">Institutional Ownership</a></h4>
On Sun, Jun 22, 2014 at 12:58 PM, Jim Ranum amt2100@... wrote:
> Very cool. I figured it would require the "-1", but what does "h1" do?
> I don't see an h1 on the page.
> On Jun 22, 2014 3:26 PM, "Randy Harmelink rharmelink@..."
> <rharmelink@gmail.com> wrote:
>
>> No worries. Try:
>>
>> =smfConvertData(smfGetTagContent("
>> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Short Percentage"))
>> =smfConvertData(smfGetTagContent("
>> http://www.gurufocus.com/ShortInterest/mmm","h1",-1,">Institutional
>> Ownership"))
>> =smfConvertData(smfGetTagContent("
>> http://www.gurufocus.com/ShortInterest/mmm","
>> Ownership"
>>
>
Sun Jun 22, 2014 2:21 pm (PDT) . Posted by:
"अनन्त:" ritchemie
Hello everyone,
I am planning to buy AAII Data service "Stock Investor Pro"
would this service be anyway compatible with SMF-add in to get 10 years
worth of financial and some other automation?
I would appreciate your help
Aku
I am planning to buy AAII Data service "Stock Investor Pro"
would this service be anyway compatible with SMF-add in to get 10 years
worth of financial and some other automation?
I would appreciate your help
Aku
Sun Jun 22, 2014 2:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I was fooling around with functions to get the data from SI Pro back when I
used to get their data, but decided I didn't need the database any more.
There are snippets of the VBA code on the Yahoo group message archives.
Basically, just SQL calls.
Otherwise, take a look at XLQ (which I've never used):
http://www.qmatix.com/XLQ.htm
On Sun, Jun 22, 2014 at 2:20 PM, अनन्त: 1998chemie@... wrote:
>
> I am planning to buy AAII Data service "Stock Investor Pro"
> would this service be anyway compatible with SMF-add in to get 10 years
> worth of financial and some other automation?
>
>
used to get their data, but decided I didn't need the database any more.
There are snippets of the VBA code on the Yahoo group message archives.
Basically, just SQL calls.
Otherwise, take a look at XLQ (which I've never used):
http://www.qmatix.com/XLQ.htm
On Sun, Jun 22, 2014 at 2:20 PM, अनन्त: 1998chemie@.
>
> I am planning to buy AAII Data service "Stock Investor Pro"
> would this service be anyway compatible with SMF-add in to get 10 years
> worth of financial and some other automation?
>
>
Sun Jun 22, 2014 3:24 pm (PDT) . Posted by:
"अनन्त:" ritchemie
Thank Randy,
XLQ seems like a powerful too with lot of flexibility. You said you don't
need it anymore? what do you use now?
On Sun, Jun 22, 2014 at 5:31 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I was fooling around with functions to get the data from SI Pro back when
> I used to get their data, but decided I didn't need the database any more.
> There are snippets of the VBA code on the Yahoo group message archives.
> Basically, just SQL calls.
>
> Otherwise, take a look at XLQ (which I've never used):
>
> http://www.qmatix.com/XLQ.htm
>
>
> On Sun, Jun 22, 2014 at 2:20 PM, अनन्त: 1998chemie@... wrote:
>
>>
>> I am planning to buy AAII Data service "Stock Investor Pro"
>> would this service be anyway compatible with SMF-add in to get 10 years
>> worth of financial and some other automation?
>>
>>
>
>
XLQ seems like a powerful too with lot of flexibility. You said you don't
need it anymore? what do you use now?
On Sun, Jun 22, 2014 at 5:31 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I was fooling around with functions to get the data from SI Pro back when
> I used to get their data, but decided I didn't need the database any more.
> There are snippets of the VBA code on the Yahoo group message archives.
> Basically, just SQL calls.
>
> Otherwise, take a look at XLQ (which I've never used):
>
> http://www.qmatix.com/XLQ.htm
>
>
> On Sun, Jun 22, 2014 at 2:20 PM, अनन्त: 1998chemie@.
>
>>
>> I am planning to buy AAII Data service "Stock Investor Pro"
>> would this service be anyway compatible with SMF-add in to get 10 years
>> worth of financial and some other automation?
>>
>>
>
>
Sun Jun 22, 2014 4:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I never used XLQ.
Instead of SIPro, I prefer getting my ad hoc data from the Internet these
days. It's readily accessible. And a lot more variety.
For screening and backtesting, I use Portfolio123.com. I got rid of SIPro
back when I used StockScreen123.com. SS123 was only $15 per month,
comparable to SIPro in price, and superior to SIPro for screening, plus it
had point-in-time backtesting. When P123 shut down SS123, I got
grandfathered in on a plan that is a mix of features from their $29/month
and $83/month plans, for $29/month.
On Sun, Jun 22, 2014 at 3:24 PM, अनन्त: 1998chemie@.. wrote:
>
> XLQ seems like a powerful too with lot of flexibility. You said you don't
> need it anymore? what do you use now?
>
>
Instead of SIPro, I prefer getting my ad hoc data from the Internet these
days. It's readily accessible. And a lot more variety.
For screening and backtesting, I use Portfolio123.
back when I used StockScreen123.
comparable to SIPro in price, and superior to SIPro for screening, plus it
had point-in-time backtesting. When P123 shut down SS123, I got
grandfathered in on a plan that is a mix of features from their $29/month
and $83/month plans, for $29/month.
On Sun, Jun 22, 2014 at 3:24 PM, अनन्त: 1998chemie@.
>
> XLQ seems like a powerful too with lot of flexibility. You said you don't
> need it anymore? what do you use now?
>
>
Tidak ada komentar:
Posting Komentar