3 Messages
Digest #4000
Messages
Mon May 8, 2017 9:48 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
Thanks for the update. Working great once again.
I was wondering if you could help me extract something. I'd like to grab the latest 4 entries on Institutional Ownership. I found the page and the source, but it doesn't look like the regular page. Not sure how to do it.
https://www.gurufocus.com/ownership/AQMS
name : 'AQMS Institutional Ownership History (%)',
data :[[1443589200000,17.07,"3.15"],[1451541600000,17.01,"2.40"],[1459400400000,17.6,"2.49"],[1467262800000,25.69,"4.01"],[1475211600000,27.91,"4.34"],[1483164000000,31.36,"5.61"],[1490936400000,34.31,"6.68"]]};seriesOptions[1] = {
animation:false,
lineWidth: 2,
Obviously looking for a trend. Their screener only give the latest number. Like to use this to fine-tune.
I'm going to put in a request with them to add this to their screener, but who knows if or when that will happen.
Thanks!
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, May 08, 2017 2:11 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus. Kaput?
Did you miss last week's update? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31957
On Mon, May 8, 2017 at 10:39 AM, 'Jim Ranum' amt2100@
...wrote:
All my links to Gurufocus stopped working. Did they do something to disable the SMF addin?
Specifically, I was grabbing PE, PS, etc. off of the "stock" page.
But I also need to revamp a couple requests off of the Financials page, which has the complication of multiple columns that change according to the individual stock.
Say Revenue, for the TTM column.
None of my links are working. I don't like the new built-in add-in they have. It's REALLY slow and requires constant and repetitive logins.
I'm wondering if they are now blocking other add-ins?
Thanks for the update. Working great once again.
I was wondering if you could help me extract something. I'd like to grab the latest 4 entries on Institutional Ownership. I found the page and the source, but it doesn't look like the regular page. Not sure how to do it.
https://www.gurufocus.com/ownership/AQMS
name : 'AQMS Institutional Ownership History (%)',
data :[[1443589200000,17.07,"3.15"],[1451541600000,17.01,"2.40"],[1459400400000,17.6,"2.49"],[1467262800000,25.69,"4.01"],[1475211600000,27.91,"4.34"],[1483164000000,31.36,"5.61"],[1490936400000,34.31,"6.68"]]};seriesOptions[1] = {
animation:false,
lineWidth: 2,
Obviously looking for a trend. Their screener only give the latest number. Like to use this to fine-tune.
I'm going to put in a request with them to add this to their screener, but who knows if or when that will happen.
Thanks!
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, May 08, 2017 2:11 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus. Kaput?
Did you miss last week's update? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31957
On Mon, May 8, 2017 at 10:39 AM, 'Jim Ranum' amt2100@
...wrote:
All my links to Gurufocus stopped working. Did they do something to disable the SMF addin?
Specifically, I was grabbing PE, PS, etc. off of the "stock" page.
But I also need to revamp a couple requests off of the Financials page, which has the complication of multiple columns that change according to the individual stock.
Say Revenue, for the TTM column.
None of my links are working. I don't like the new built-in add-in they have. It's REALLY slow and requires constant and repetitive logins.
I'm wondering if they are now blocking other add-ins?
Tue May 9, 2017 1:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try something like:
=smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("
https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History
(%)'"),"[","]};"),$B8,"["),"~",",")/86400/1000+25569
=smfConvertData(smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("
https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History
(%)'"),"[","]};"),$B8,"["),",",","))
=smfConvertData(smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("
https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History
(%)'"),"[","]};"),$B8,"["),"""",""""))
....where the $B8 value needs to vary from 2 to n, depending on how many
entries they have. Unfortunately, the nth entry is the most current one. If
they always have 7 quarters of value, it would be easy to just grab the
last 4.
Basically, a four step process for each item, where the first three steps
are the same.
1. Grab the data from script data from the web page:
C4: =RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Insider
Ownership (%)'")
2. Pull the table from that script data:
C5: =smfStrExtr(C4,"[","]};")
3. Extract each trio of data items, dragging B8:C8 down, incrementing the B
column:
B8: 2
C8 =smfWord(C$5,$B8,"[")
4. Pull each of the three items for the above word, and drag F8:H8 downward:
F8: =smfStrExtr($C8,"~",",")/86400/1000+25569
G8: =smfConvertData(smfStrExtr($C8,",",","))
H8: =smfConvertData(smfStrExtr($C8,"""",""""))
The math in cell F8 is because the "date" they use is a UNIX date (number
of milliseconds since 1970-01-01 and needs to be converted into an EXCEL
serial date value.
On Mon, May 8, 2017 at 9:42 PM, 'Jim Ranum' amt2100@
...wrote:
>
>
> I was wondering if you could help me extract something. I'd like to grab
> the latest 4 entries on Institutional Ownership. I found the page and the
> source, but it doesn't look like the regular page. Not sure how to do it.
>
> https://www.gurufocus.com/ownership/AQMS
>
>
>
> name : 'AQMS Institutional Ownership History (%)',
>
> data :[[1443589200000,17.07,"3.15"],[1451541600000,17.01,"2.40"],
> [1459400400000,17.6,"2.49"],[1467262800000,25.69,"4.01"],[
> 1475211600000,27.91,"4.34"],[1483164000000,31.36,"5.61"],[
> 1490936400000,34.31,"6.68"]]};seriesOptions[1] = {
>
> animation:false,
>
> lineWidth: 2,
>
>
>
> Obviously looking for a trend. Their screener only give the latest number.
> Like to use this to fine-tune.
>
> I'm going to put in a request with them to add this to their screener, but
> who knows if or when that will happen.
>
>
=smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("
https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History
(%)'"),"[","]};"),$B8,"["),"~",",")/86400/1000+25569
=smfConvertData(smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("
https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History
(%)'"),"[","]};"),$B8,"["),",",","))
=smfConvertData(smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("
https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History
(%)'"),"[","]};"),$B8,"["),"""",""""))
....where the $B8 value needs to vary from 2 to n, depending on how many
entries they have. Unfortunately, the nth entry is the most current one. If
they always have 7 quarters of value, it would be easy to just grab the
last 4.
Basically, a four step process for each item, where the first three steps
are the same.
1. Grab the data from script data from the web page:
C4: =RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Insider
Ownership (%)'")
2. Pull the table from that script data:
C5: =smfStrExtr(C4,"[","]};")
3. Extract each trio of data items, dragging B8:C8 down, incrementing the B
column:
B8: 2
C8 =smfWord(C$5,$B8,"[")
4. Pull each of the three items for the above word, and drag F8:H8 downward:
F8: =smfStrExtr($C8,"~",",")/86400/1000+25569
G8: =smfConvertData(smfStrExtr($C8,",",","))
H8: =smfConvertData(smfStrExtr($C8,"""",""""))
The math in cell F8 is because the "date" they use is a UNIX date (number
of milliseconds since 1970-01-01 and needs to be converted into an EXCEL
serial date value.
On Mon, May 8, 2017 at 9:42 PM, 'Jim Ranum' amt2100@
...wrote:
>
>
> I was wondering if you could help me extract something. I'd like to grab
> the latest 4 entries on Institutional Ownership. I found the page and the
> source, but it doesn't look like the regular page. Not sure how to do it.
>
> https://www.gurufocus.com/ownership/AQMS
>
>
>
> name : 'AQMS Institutional Ownership History (%)',
>
> data :[[1443589200000,
> [1459400400000,
> 1475211600000,
> 1490936400000,
>
> animation:false,
>
> lineWidth: 2,
>
>
>
> Obviously looking for a trend. Their screener only give the latest number.
> Like to use this to fine-tune.
>
> I'm going to put in a request with them to add this to their screener, but
> who knows if or when that will happen.
>
>
Tue May 9, 2017 1:44 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Thanks so much Randy. That was a lot more work than I anticipated.
You are a very generous soul.
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, May 09, 2017 4:23 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus. Kaput?
Try something like:
=smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History (%)'"),"[","]};"),$B8,"["),"~",",")/86400/1000+25569
=smfConvertData(smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History (%)'"),"[","]};"),$B8,"["),",",","))
=smfConvertData(smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History (%)'"),"[","]};"),$B8,"["),"""",""""))
....where the $B8 value needs to vary from 2 to n, depending on how many entries they have. Unfortunately, the nth entry is the most current one. If they always have 7 quarters of value, it would be easy to just grab the last 4.
Basically, a four step process for each item, where the first three steps are the same.
1. Grab the data from script data from the web page:
C4: =RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Insider Ownership (%)'")
2. Pull the table from that script data:
C5: =smfStrExtr(C4,"[","]};")
3. Extract each trio of data items, dragging B8:C8 down, incrementing the B column:
B8: 2
C8 =smfWord(C$5,$B8,"[")
4. Pull each of the three items for the above word, and drag F8:H8 downward:
F8: =smfStrExtr($C8,"~",",")/86400/1000+25569
G8: =smfConvertData(smfStrExtr($C8,",",","))
H8: =smfConvertData(smfStrExtr($C8,"""",""""))
The math in cell F8 is because the "date" they use is a UNIX date (number of milliseconds since 1970-01-01 and needs to be converted into an EXCEL serial date value.
On Mon, May 8, 2017 at 9:42 PM, 'Jim Ranum' amt2100@
...wrote:
I was wondering if you could help me extract something. I'd like to grab the latest 4 entries on Institutional Ownership. I found the page and the source, but it doesn't look like the regular page. Not sure how to do it.
https://www.gurufocus.com/ownership/AQMS
name : 'AQMS Institutional Ownership History (%)',
data :[[1443589200000,17.07,"3.15"],[1451541600000,17.01,"2.40"],[1459400400000,17.6,"2.49"],[1467262800000,25.69,"4.01"],[1475211600000,27.91,"4.34"],[1483164000000,31.36,"5.61"],[1490936400000,34.31,"6.68"]]};seriesOptions[1] = {
animation:false,
lineWidth: 2,
Obviously looking for a trend. Their screener only give the latest number. Like to use this to fine-tune.
I'm going to put in a request with them to add this to their screener, but who knows if or when that will happen.
You are a very generous soul.
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, May 09, 2017 4:23 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus. Kaput?
Try something like:
=smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History (%)'"),"[","]};"),$B8,"["),"~",",")/86400/1000+25569
=smfConvertData(smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History (%)'"),"[","]};"),$B8,"["),",",","))
=smfConvertData(smfStrExtr(smfWord(smfStrExtr(RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Institutional Ownership History (%)'"),"[","]};"),$B8,"["),"""",""""))
....where the $B8 value needs to vary from 2 to n, depending on how many entries they have. Unfortunately, the nth entry is the most current one. If they always have 7 quarters of value, it would be easy to just grab the last 4.
Basically, a four step process for each item, where the first three steps are the same.
1. Grab the data from script data from the web page:
C4: =RCHGetWebData("https://www.gurufocus.com/ownership/AQMS","Insider Ownership (%)'")
2. Pull the table from that script data:
C5: =smfStrExtr(C4,"[","]};")
3. Extract each trio of data items, dragging B8:C8 down, incrementing the B column:
B8: 2
C8 =smfWord(C$5,$B8,"[")
4. Pull each of the three items for the above word, and drag F8:H8 downward:
F8: =smfStrExtr($C8,"~",",")/86400/1000+25569
G8: =smfConvertData(smfStrExtr($C8,",",","))
H8: =smfConvertData(smfStrExtr($C8,"""",""""))
The math in cell F8 is because the "date" they use is a UNIX date (number of milliseconds since 1970-01-01 and needs to be converted into an EXCEL serial date value.
On Mon, May 8, 2017 at 9:42 PM, 'Jim Ranum' amt2100@
...wrote:
I was wondering if you could help me extract something. I'd like to grab the latest 4 entries on Institutional Ownership. I found the page and the source, but it doesn't look like the regular page. Not sure how to do it.
https://www.gurufocus.com/ownership/AQMS
name : 'AQMS Institutional Ownership History (%)',
data :[[1443589200000,
animation:false,
lineWidth: 2,
Obviously looking for a trend. Their screener only give the latest number. Like to use this to fine-tune.
I'm going to put in a request with them to add this to their screener, but who knows if or when that will happen.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar