10 Messages
Digest #3098
Messages
Fri Jun 20, 2014 10:16 am (PDT) . Posted by:
"Jim Ranum" amt2100
How would you get this to populate with a pure number vs. "48 Billion"? (so it can be used in a formula)
And another question connected to this data point, does anyone know a good source for an average daily volume that can be pulled with this SMF tool?
Thank you,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, June 19, 2014 1:10 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
This works for me:
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding")
On Thu, Jun 19, 2014 at 1:30 AM, sri.yanto@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
hoho ..sori..bro, i forgot it
=smfConvertData(smfStrExtr(smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding"),"~","<"))
ASII the ticker bro
http://quotes.wsj.com/ID/XIDX/ASII
And another question connected to this data point, does anyone know a good source for an average daily volume that can be pulled with this SMF tool?
Thank you,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, June 19, 2014 1:10 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
This works for me:
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding")
On Thu, Jun 19, 2014 at 1:30 AM, sri.yanto@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
hoho ..sori..bro, i forgot it
=smfConvertData(smfStrExtr(smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding"),"~","<"))
ASII the ticker bro
http://quotes.wsj.com/ID/XIDX/ASII
Fri Jun 20, 2014 10:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The add-in does a number of conversions automatically for the
RCHGetTableCell(), for "B", "Bil" and "Bill", but not "Billion". I'll have
to add that. The next version of the add-in will have the ability to tell
smfGetTagContent() to automatically do a conversion process on returned
data.
However, as is, you'd have to do a nasty nested IF() with the various
possibilities. Then multiply by the correct amount, whether it be millions
or billions (the add-in assumes such things will be in thousands).
On Fri, Jun 20, 2014 at 10:16 AM, 'Jim Ranum' amt2100@... wrote:
>
> How would you get this to populate with a pure number vs. "48 Billion"?
> (so it can be used in a formula)
>
>
>
> And another question connected to this data point, does anyone know a good
> source for an average daily volume that can be pulled with this SMF tool?
>
RCHGetTableCell(
to add that. The next version of the add-in will have the ability to tell
smfGetTagContent(
data.
However, as is, you'd have to do a nasty nested IF() with the various
possibilities. Then multiply by the correct amount, whether it be millions
or billions (the add-in assumes such things will be in thousands).
On Fri, Jun 20, 2014 at 10:16 AM, 'Jim Ranum' amt2100@... wrote:
>
> How would you get this to populate with a pure number vs. "48 Billion"?
> (so it can be used in a formula)
>
>
>
> And another question connected to this data point, does anyone know a good
> source for an average daily volume that can be pulled with this SMF tool?
>
Fri Jun 20, 2014 10:43 am (PDT) . Posted by:
"Jim Ranum" amt2100
Thanks Randy. That's what I thought on the IF() statement solution. Didn't know about your other auto conversion ability. Let us know about updates to that please?
Thanks again,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 1:27 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
The add-in does a number of conversions automatically for the RCHGetTableCell(), for "B", "Bil" and "Bill", but not "Billion". I'll have to add that. The next version of the add-in will have the ability to tell smfGetTagContent() to automatically do a conversion process on returned data.
However, as is, you'd have to do a nasty nested IF() with the various possibilities. Then multiply by the correct amount, whether it be millions or billions (the add-in assumes such things will be in thousands).
On Fri, Jun 20, 2014 at 10:16 AM, 'Jim Ranum' amt2100@... wrote:
How would you get this to populate with a pure number vs. "48 Billion"? (so it can be used in a formula)
And another question connected to this data point, does anyone know a good source for an average daily volume that can be pulled with this SMF tool?
Thanks again,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 1:27 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
The add-in does a number of conversions automatically for the RCHGetTableCell(
However, as is, you'd have to do a nasty nested IF() with the various possibilities. Then multiply by the correct amount, whether it be millions or billions (the add-in assumes such things will be in thousands).
On Fri, Jun 20, 2014 at 10:16 AM, 'Jim Ranum' amt2100@... wrote:
How would you get this to populate with a pure number vs. "48 Billion"? (so it can be used in a formula)
And another question connected to this data point, does anyone know a good source for an average daily volume that can be pulled with this SMF tool?
Fri Jun 20, 2014 11:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I added the "Billion" and "Million" to the conversion routine, and this
(note the last parameter of "1"):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock
Data","Shares Outstanding",,,1)
...now returns this for me:
40480000000
...while this (basically the only choice you have in your version of the
add-in):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock
Data","Shares Outstanding",,,0)
...still returns:
40.48 Billion
So any release from 2014.06.20 and on should include that ability.
On Fri, Jun 20, 2014 at 10:42 AM, 'Jim Ranum' amt2100@... wrote:
>
> Thanks Randy. That's what I thought on the IF() statement solution. Didn't
> know about your other auto conversion ability. Let us know about updates to
> that please?
>
(note the last parameter of "1"):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock
Data","Shares Outstanding",,,1)
...now returns this for me:
40480000000
...while this (basically the only choice you have in your version of the
add-in):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","
Data","
...still returns:
40.48 Billion
So any release from 2014.06.20 and on should include that ability.
On Fri, Jun 20, 2014 at 10:42 AM, 'Jim Ranum' amt2100@... wrote:
>
> Thanks Randy. That's what I thought on the IF() statement solution. Didn't
> know about your other auto conversion ability. Let us know about updates to
> that please?
>
Fri Jun 20, 2014 11:36 am (PDT) . Posted by:
"Jim Ranum" amt2100
So sorry to ask, but where do I find this updated release? I just looked through all the Files section. I would think it should be under the "Add-In Files" folder, but no.
Thanks again,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 2:05 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
I added the "Billion" and "Million" to the conversion routine, and this (note the last parameter of "1"):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding",,,1)
...now returns this for me:
40480000000
...while this (basically the only choice you have in your version of the add-in):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding",,,0)
...still returns:
40.48 Billion
So any release from 2014.06.20 and on should include that ability.
On Fri, Jun 20, 2014 at 10:42 AM, 'Jim Ranum' amt2100@... wrote:
Thanks Randy. That's what I thought on the IF() statement solution. Didn't know about your other auto conversion ability. Let us know about updates to that please?
Thanks again,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 2:05 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
I added the "Billion" and "Million" to the conversion routine, and this (note the last parameter of "1"):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding",,,1)
...now returns this for me:
40480000000
...while this (basically the only choice you have in your version of the add-in):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","
...still returns:
40.48 Billion
So any release from 2014.06.20 and on should include that ability.
On Fri, Jun 20, 2014 at 10:42 AM, 'Jim Ranum' amt2100@... wrote:
Thanks Randy. That's what I thought on the IF() statement solution. Didn't know about your other auto conversion ability. Let us know about updates to that please?
Fri Jun 20, 2014 11:41 am (PDT) . Posted by:
"Jim Ranum" amt2100
Also, per my other question related to this, I found the Avg Vol(3m): on Yahoo Finance, but haven't used the Yahoo smf for so long, can't remember what the instruction is to extract this.
Can you remind me please?
Thanks,
Jim
I am using the formula of Avg Volume to Shares Outstanding to gauge the relative turnover time for stock price movement. In case anyone is interested.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 2:05 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
I added the "Billion" and "Million" to the conversion routine, and this (note the last parameter of "1"):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding",,,1)
...now returns this for me:
40480000000
...while this (basically the only choice you have in your version of the add-in):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding",,,0)
...still returns:
40.48 Billion
So any release from 2014.06.20 and on should include that ability.
On Fri, Jun 20, 2014 at 10:42 AM, 'Jim Ranum' amt2100@... wrote:
Thanks Randy. That's what I thought on the IF() statement solution. Didn't know about your other auto conversion ability. Let us know about updates to that please?
Can you remind me please?
Thanks,
Jim
I am using the formula of Avg Volume to Shares Outstanding to gauge the relative turnover time for stock price movement. In case anyone is interested.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 2:05 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
I added the "Billion" and "Million" to the conversion routine, and this (note the last parameter of "1"):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding",,,1)
...now returns this for me:
40480000000
...while this (basically the only choice you have in your version of the add-in):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","
...still returns:
40.48 Billion
So any release from 2014.06.20 and on should include that ability.
On Fri, Jun 20, 2014 at 10:42 AM, 'Jim Ranum' amt2100@... wrote:
Thanks Randy. That's what I thought on the IF() statement solution. Didn't know about your other auto conversion ability. Let us know about updates to that please?
Fri Jun 20, 2014 12:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't upload every change. I've been fooling around with asynchronous
Internet calls, so I don't really have a stable release at the moment.
Sorry.
Normally, interim (i.e. "Beta") updates would be on the "Works in Progress"
web page:
http://ogres-crypt.com/SMF/Works-In-Progress/
On Fri, Jun 20, 2014 at 11:36 AM, 'Jim Ranum' amt2100@... wrote:
>
> So sorry to ask, but where do I find this updated release? I just looked
> through all the Files section. I would think it should be under the "Add-In
> Files" folder, but no.
>
>
Internet calls, so I don't really have a stable release at the moment.
Sorry.
Normally, interim (i.e. "Beta") updates would be on the "Works in Progress"
web page:
http://ogres-crypt.com/SMF/Works-In-Progress/
On Fri, Jun 20, 2014 at 11:36 AM, 'Jim Ranum' amt2100@... wrote:
>
> So sorry to ask, but where do I find this updated release? I just looked
> through all the Files section. I would think it should be under the "Add-In
> Files" folder, but no.
>
>
Fri Jun 20, 2014 12:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't trust Yahoo on such calculated items. Not since I found out their
50-day and 200-day moving averages were based on calendar days instead of
trading days. I prefer to use BarChart, if only for the wide variety of
items they have available. For example, the 100-day average volume would be
either of:
=RCHGetElementNumber("MMM", 1234)
=RCHGetTableCell("http://www.barchart.com/technicals/MMM",4,">Average
Volume","100-day")
This template shows all of the BarChart technical items:
http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Technical-Indicators.xls
On Fri, Jun 20, 2014 at 11:41 AM, 'Jim Ranum' amt2100@... wrote:
>
> Also, per my other question related to this, I found the Avg Vol(3m): on
> Yahoo Finance, but haven't used the Yahoo smf for so long, can't remember
> what the instruction is to extract this.
>
> Can you remind me please?
>
> Thanks,
>
> Jim
>
>
>
> I am using the formula of Avg Volume to Shares Outstanding to gauge the
> relative turnover time for stock price movement. In case anyone is
> interested.
>
50-day and 200-day moving averages were based on calendar days instead of
trading days. I prefer to use BarChart, if only for the wide variety of
items they have available. For example, the 100-day average volume would be
either of:
=RCHGetElementNumber("MMM", 1234)
=RCHGetTableCell("http://www.barchart.com/technicals/MMM",4,">Average
Volume","100-day")
This template shows all of the BarChart technical items:
http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Technical-Indicators.xls
On Fri, Jun 20, 2014 at 11:41 AM, 'Jim Ranum' amt2100@... wrote:
>
> Also, per my other question related to this, I found the Avg Vol(3m): on
> Yahoo Finance, but haven't used the Yahoo smf for so long, can't remember
> what the instruction is to extract this.
>
> Can you remind me please?
>
> Thanks,
>
> Jim
>
>
>
> I am using the formula of Avg Volume to Shares Outstanding to gauge the
> relative turnover time for stock price movement. In case anyone is
> interested.
>
Fri Jun 20, 2014 12:13 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Also looked on the ogres site and the latest version is 5/25/2014.
From: Jim Ranum [mailto:amt2100@gmail.com]
Sent: Friday, June 20, 2014 2:36 PM
To: 'smf_addin@yahoogroups.com'
Subject: RE: [smf_addin] put "share outstanding" data on WSJ
So sorry to ask, but where do I find this updated release? I just looked through all the Files section. I would think it should be under the "Add-In Files" folder, but no.
Thanks again,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 2:05 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
I added the "Billion" and "Million" to the conversion routine, and this (note the last parameter of "1"):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding",,,1)
...now returns this for me:
40480000000
...while this (basically the only choice you have in your version of the add-in):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding",,,0)
...still returns:
40.48 Billion
So any release from 2014.06.20 and on should include that ability.
On Fri, Jun 20, 2014 at 10:42 AM, 'Jim Ranum' amt2100@... wrote:
Thanks Randy. That's what I thought on the IF() statement solution. Didn't know about your other auto conversion ability. Let us know about updates to that please?
From: Jim Ranum [mailto:amt2100@gmail.com]
Sent: Friday, June 20, 2014 2:36 PM
To: 'smf_addin@yahoogroups.com'
Subject: RE: [smf_addin] put "share outstanding" data on WSJ
So sorry to ask, but where do I find this updated release? I just looked through all the Files section. I would think it should be under the "Add-In Files" folder, but no.
Thanks again,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 2:05 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
I added the "Billion" and "Million" to the conversion routine, and this (note the last parameter of "1"):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding",,,1)
...now returns this for me:
40480000000
...while this (basically the only choice you have in your version of the add-in):
=smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","
...still returns:
40.48 Billion
So any release from 2014.06.20 and on should include that ability.
On Fri, Jun 20, 2014 at 10:42 AM, 'Jim Ranum' amt2100@... wrote:
Thanks Randy. That's what I thought on the IF() statement solution. Didn't know about your other auto conversion ability. Let us know about updates to that please?
Fri Jun 20, 2014 12:25 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Very good. Also thanks for previous response.
Thanks very much,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 3:08 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
I don't trust Yahoo on such calculated items. Not since I found out their 50-day and 200-day moving averages were based on calendar days instead of trading days. I prefer to use BarChart, if only for the wide variety of items they have available. For example, the 100-day average volume would be either of:
=RCHGetElementNumber("MMM", 1234)
=RCHGetTableCell("http://www.barchart.com/technicals/MMM",4,">Average Volume","100-day")
This template shows all of the BarChart technical items:
http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Technical-Indicators.xls
On Fri, Jun 20, 2014 at 11:41 AM, 'Jim Ranum' amt2100@... wrote:
Also, per my other question related to this, I found the Avg Vol(3m): on Yahoo Finance, but haven't used the Yahoo smf for so long, can't remember what the instruction is to extract this.
Can you remind me please?
Thanks,
Jim
I am using the formula of Avg Volume to Shares Outstanding to gauge the relative turnover time for stock price movement. In case anyone is interested.
Thanks very much,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 20, 2014 3:08 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] put "share outstanding" data on WSJ
I don't trust Yahoo on such calculated items. Not since I found out their 50-day and 200-day moving averages were based on calendar days instead of trading days. I prefer to use BarChart, if only for the wide variety of items they have available. For example, the 100-day average volume would be either of:
=RCHGetElementNumber("MMM", 1234)
=RCHGetTableCell("http://www.barchart.com/technicals/MMM",4,">Average Volume","100-day")
This template shows all of the BarChart technical items:
http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Technical-Indicators.xls
On Fri, Jun 20, 2014 at 11:41 AM, 'Jim Ranum' amt2100@... wrote:
Also, per my other question related to this, I found the Avg Vol(3m): on Yahoo Finance, but haven't used the Yahoo smf for so long, can't remember what the instruction is to extract this.
Can you remind me please?
Thanks,
Jim
I am using the formula of Avg Volume to Shares Outstanding to gauge the relative turnover time for stock price movement. In case anyone is interested.
Tidak ada komentar:
Posting Komentar