8 Messages
Digest #3863
Messages
Sun Dec 11, 2016 8:58 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I've looked at it several times, but just decided it wasn't worth the
effort...
That may change. Thanks for the update. Let me know if it still looks good
to you after a few months with it.
On Sun, Dec 11, 2016 at 2:15 AM, marco.deen@
...wrote:
> Randy, another yahoogroup I am member of is migrating to groups.io .
> Transfer is supposed to be seamless and features are said to be the same or
> better. The only issue found so far is that the free service has a storage
> limit for files of 1GB. Maybe this is something you'll want to consider?
>
effort...
That may change. Thanks for the update. Let me know if it still looks good
to you after a few months with it.
On Sun, Dec 11, 2016 at 2:15 AM, marco.deen@
...wrote:
> Randy, another yahoogroup I am member of is migrating to groups.io .
> Transfer is supposed to be seamless and features are said to be the same or
> better. The only issue found so far is that the free service has a storage
> limit for files of 1GB. Maybe this is something you'll want to consider?
>
Mon Dec 12, 2016 6:22 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
This group has been working for years.
What is the advantage of moving to another site.
I looked at it and yes it has more features but I doubt they are ones this group needs.
I'm all for "Keep it Simple Stupid"
KISS method works well for this group
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, December 11, 2016 11:52 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] groups.io
I've looked at it several times, but just decided it wasn't worth the effort...
That may change. Thanks for the update. Let me know if it still looks good to you after a few months with it.
On Sun, Dec 11, 2016 at 2:15 AM, marco.deen@
...wrote:
Randy, another yahoogroup I am member of is migrating to groups.io . Transfer is supposed to be seamless and features are said to be the same or better. The only issue found so far is that the free service has a storage limit for files of 1GB. Maybe this is something you'll want to consider?
What is the advantage of moving to another site.
I looked at it and yes it has more features but I doubt they are ones this group needs.
I'm all for "Keep it Simple Stupid"
KISS method works well for this group
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, December 11, 2016 11:52 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] groups.io
I've looked at it several times, but just decided it wasn't worth the effort...
That may change. Thanks for the update. Let me know if it still looks good to you after a few months with it.
On Sun, Dec 11, 2016 at 2:15 AM, marco.deen@
...wrote:
Randy, another yahoogroup I am member of is migrating to groups.io . Transfer is supposed to be seamless and features are said to be the same or better. The only issue found so far is that the free service has a storage limit for files of 1GB. Maybe this is something you'll want to consider?
Sun Dec 11, 2016 5:55 pm (PST) . Posted by:
lutherkinchen
Randy, I have been using a formula, that Doug Robertson shared. It provided Earnings Release Date and announcement time. It quit working a couple weeks ago.
Here they are (earnings release date, and time of announcement):
=IF(IF(NOT(G11="N/A"),G11-TODAY(),0)>=0,G11-TODAY(),"Unknown")
=CLEAN(RCHGetTableCell("http://old.earningswhispers.com/stocks.asp?symbol="&A7,1,"Release Date:",""))
Any idea, on why they would quit working? Or do you have a different location/method to obtain.
1) Earnings release date
2) Time of Announcement
Many thanks and Merry Christmas,
Luther
Here they are (earnings release date, and time of announcement):
=IF(IF(NOT(G11="N/A"),G11-TODAY(),0)>=0,G11-TODAY(),"Unknown")
=CLEAN(RCHGetTableCell("http://old.earningswhispers.com/stocks.asp?symbol="&A7,1,
Any idea, on why they would quit working? Or do you have a different location/method to obtain.
1) Earnings release date
2) Time of Announcement
Many thanks and Merry Christmas,
Luther
Sun Dec 11, 2016 7:23 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The add-in is returning the "N/A" I see on the web page when I use ticker
symbol "MMM"...so the formula is working. I suspect the page is going away
permanently. They probably kept the "old" version of the page for a while
so people could convert.
It looks like the easiest way to extract it from their new page is via the
twitter component:
=smfStrExtr(SUBSTITUTE(RCHGetWebData("
https://www.earningswhispers.com/stocks/"&$D16,"twitter.com",150),"%20","
")," on "," at ")
=smfStrExtr(SUBSTITUTE(RCHGetWebData("
https://www.earningswhispers.com/stocks/"&$D16,"twitter.com",150),"%20","
")," at "," via")
...or maybe:
=smfGetTagContent("https://www.earningswhispers.com/stocks/
"&$D16,"div",-2,"id=""earningstime""")
=smfGetTagContent("https://www.earningswhispers.com/stocks/
"&$D16,"div",-1,"id=""earningstime""")
On Sun, Dec 11, 2016 at 6:55 PM, lutherkinchen@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I have been using a formula, that Doug Robertson shared. It provided
> Earnings Release Date and announcement time. It quit working a couple
> weeks ago.
>
> Here they are (earnings release date, and time of announcement):
> =IF(IF(NOT(G11="N/A"),G11-TODAY(),0)>=0,G11-TODAY(),"Unknown")
> =CLEAN(RCHGetTableCell("http://old.earningswhispers.com/stocks.asp?symbol=
> "&A7,1,"Release Date:",""))
>
> Any idea, on why they would quit working? Or do you have a different
> location/method to obtain.
> 1) Earnings release date
> 2) Time of Announcement
>
>
symbol "MMM"...so the formula is working. I suspect the page is going away
permanently. They probably kept the "old" version of the page for a while
so people could convert.
It looks like the easiest way to extract it from their new page is via the
twitter component:
=smfStrExtr(SUBSTITUTE(RCHGetWebData("
https://www.earningswhispers.com/stocks/"&$D16,"twitter.com",150),"%20","
")," on "," at ")
=smfStrExtr(SUBSTITUTE(RCHGetWebData("
https://www.earningswhispers.com/stocks/"&$D16,"twitter.com",150),"%20","
")," at "," via")
...or maybe:
=smfGetTagContent("https://www.earningswhispers.com/stocks/
"&$D16,"div",-2,"id=""earningstime""")
=smfGetTagContent("https://www.earningswhispers.com/stocks/
"&$D16,"div",-1,"id=""earningstime""")
On Sun, Dec 11, 2016 at 6:55 PM, lutherkinchen@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I have been using a formula, that Doug Robertson shared. It provided
> Earnings Release Date and announcement time. It quit working a couple
> weeks ago.
>
> Here they are (earnings release date, and time of announcement):
> =IF(IF(NOT(G11="N/A"),G11-TODAY(),0)>=0,G11-TODAY(),"Unknown")
> =CLEAN(RCHGetTableCell("http://old.earningswhispers.com/stocks.asp?symbol=
> "&A7,1,
>
> Any idea, on why they would quit working? Or do you have a different
> location/method to obtain.
> 1) Earnings release date
> 2) Time of Announcement
>
>
Mon Dec 12, 2016 12:02 pm (PST) . Posted by:
pigletmc
Hi Randy,
Would you be able to provide the new code to replace the following formula:
=RCHGetTableCell("https://www.barchart.com/options/stocks/"&A1,1,">Strike",,,,1)
I am trying to pull the strike prices for calls and puts from the website.
MNST | Stocks Options Quotes for Monster Beverage Cp https://www.barchart.com/stocks/quotes/MNST/options
MNST | Stocks Options Quotes for Monster Beverage Cp https://www.barchart.com/stocks/quotes/MNST/options Stocks Option prices for MNST with MNST option quotes and option chains.
View on www.barchart.com https://www.barchart.com/stocks/quotes/MNST/options
Preview by Yahoo
Would you be able to provide the new code to replace the following formula:
=RCHGetTableCell("https://www.barchart.com/options/stocks/"&A1,1,">Strike",,,,1)
I am trying to pull the strike prices for calls and puts from the website.
MNST | Stocks Options Quotes for Monster Beverage Cp https://www.barchart.com/stocks/quotes/MNST/options
MNST | Stocks Options Quotes for Monster Beverage Cp https://www.barchart.com/stocks/quotes/MNST/options Stocks Option prices for MNST with MNST option quotes and option chains.
View on www.barchart.com https://www.barchart.com/stocks/quotes/MNST/options
Preview by Yahoo
Mon Dec 12, 2016 12:32 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The RCHGetTableCell() process won't be able to extract the data from that
web page, because there is no HTML table in the source code of the web
page. They do a JSON call to get the data and then build the table
dynamically. So you'd need to parse it out of the JSON code. Besides, the
URL you cite only shows "near the money" and current expiration date. There
are more strike prices for "all" rather than "near the money" and available
strike prices vary by expiration date.
However, just to get strike prices, this is the JSON call you'd need to do:
https://core-api.barchart.com/v1/options/chain?fields=optionType,strikePrice&groupBy=optionType&raw=0&symbol=MNST&expirationDate=2016-12-16
The returned data looks something like this:
{"count":2,"total":0,"data":{"Call":[{"optionType":"Call","strikePrice":"21.67"},{"optionType":"Call","strikePrice":"23.33"},
...
Now, the big question -- what do you plan to do with those strike prices? I
ask, because the JSON call could return all of the other data items at the
same time. No reason to do multiple calls for data. Fastest method would be
one Internet access per expiration date. For example, these are all the
"fields" that the new smfGetBarChartOptionQuote() function uses:
https://core-api.barchart.com/v1/options/chain?fields=optionType,strikePrice,lastPrice,percentFromLast,priceChange,percentChange,bidPrice,midpoint,askPrice,theoretical,volatility,delta,gamma,rho,theta,vega,volume,openInterest,daysToExpiration,expirationDate&groupBy=optionType&raw=0&symbol=MNST&expirationDate=2016-12-16
On Mon, Dec 12, 2016 at 12:54 PM, pigletmc@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Would you be able to provide the new code to replace the following formula:
> =RCHGetTableCell("https://www.barchart.com/options/stocks/"&
> A1,1,">Strike",,,,1)
>
> I am trying to pull the strike prices for calls and puts from the website.
>
> MNST | Stocks Options Quotes for Monster Beverage Cp
> <https://www.barchart.com/stocks/quotes/MNST/options>
>
>
web page, because there is no HTML table in the source code of the web
page. They do a JSON call to get the data and then build the table
dynamically. So you'd need to parse it out of the JSON code. Besides, the
URL you cite only shows "near the money" and current expiration date. There
are more strike prices for "all" rather than "near the money" and available
strike prices vary by expiration date.
However, just to get strike prices, this is the JSON call you'd need to do:
https://core-api.barchart.com/v1/options/chain?fields=optionType,strikePrice&groupBy=optionType&raw=0&symbol=MNST&expirationDate=2016-12-16
The returned data looks something like this:
{"count":2,"total":0,"data":{"Call":[{"optionType":"Call","strikePrice":"21.67"},{"optionType":"Call","strikePrice":"23.33"},
...
Now, the big question -- what do you plan to do with those strike prices? I
ask, because the JSON call could return all of the other data items at the
same time. No reason to do multiple calls for data. Fastest method would be
one Internet access per expiration date. For example, these are all the
"fields" that the new smfGetBarChartOptionQuote() function uses:
https://core-api.barchart.com/v1/options/chain?fields=optionType,strikePrice,lastPrice,percentFromLast,priceChange,percentChange,bidPrice,midpoint,askPrice,theoretical,volatility,delta,gamma,rho,theta,vega,volume,openInterest,daysToExpiration,expirationDate&groupBy=optionType&raw=0&symbol=MNST&expirationDate=2016-12-16
On Mon, Dec 12, 2016 at 12:54 PM, pigletmc@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Would you be able to provide the new code to replace the following formula:
> =RCHGetTableCell("https://www.barchart.com/options/stocks/"&
> A1,1,">Strike",,,,1)
>
> I am trying to pull the strike prices for calls and puts from the website.
>
> MNST | Stocks Options Quotes for Monster Beverage Cp
> <https://www.barchart.com/stocks/quotes/MNST/options>
>
>
Mon Dec 12, 2016 3:36 pm (PST) . Posted by:
"Al Eaton" aleaton93309
I have tried to get a quote for the Dow Jones Industrial Average from Yahoo
using the RCHGetYahooQuotes.xls spreadsheet. I tried the ticker ^DJI and
INDU which both work on the Yahoo web site but not in the spreadsheet. I
can get other index quotes, just not the Dow. What am I doing wrong?
Al Eaton
aleaton48@gmail.com <mailto:aleaton48@gmail.com>
using the RCHGetYahooQuotes.xls spreadsheet. I tried the ticker ^DJI and
INDU which both work on the Yahoo web site but not in the spreadsheet. I
can get other index quotes, just not the Dow. What am I doing wrong?
Al Eaton
aleaton48@gmail.com <mailto:aleaton48@gmail.com>
Mon Dec 12, 2016 3:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You're not doing anything wrong. Several years ago, the Dow Jones Company
enforced their licensing and prevented Yahoo from provided their index
quotes in the current quotes CSV interface, which is what the
RCHGetYahooQuotes() function uses. So that function can't retrieve any
quotes for the Dow Jones Indexes.
On Mon, Dec 12, 2016 at 4:37 PM, 'Al Eaton' aleaton48@ wrote:
>
> I have tried to get a quote for the Dow Jones Industrial Average from
> Yahoo using the RCHGetYahooQuotes.xls spreadsheet. I tried the ticker
> ^DJI and INDU which both work on the Yahoo web site but not in the
> spreadsheet. I can get other index quotes, just not the Dow. What am I
> doing wrong?
>
>
>
>
enforced their licensing and prevented Yahoo from provided their index
quotes in the current quotes CSV interface, which is what the
RCHGetYahooQuotes(
quotes for the Dow Jones Indexes.
On Mon, Dec 12, 2016 at 4:37 PM, 'Al Eaton' aleaton48@ wrote:
>
> I have tried to get a quote for the Dow Jones Industrial Average from
> Yahoo using the RCHGetYahooQuotes.
> ^DJI and INDU which both work on the Yahoo web site but not in the
> spreadsheet. I can get other index quotes, just not the Dow. What am I
> doing wrong?
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar