6 Messages
Digest #3700
Messages
Mon May 16, 2016 4:27 am (PDT) . Posted by:
pdyson10
Randy, that's great to hear - I think it will help many people.
I will tidy up my code so that it is in one module and send it to you. How is it best to send it to you.
Regards
Paul
I will tidy up my code so that it is in one module and send it to you. How is it best to send it to you.
Regards
Paul
Mon May 16, 2016 9:02 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Attach it to a message sent to my main address: rharmelink@gmail.com.
Be sure to add a section of comments to the top of the module to indicate
you wrote it, what it's for, and whether or not you care if other people
copy it (because the add-in is open source).
On Mon, May 16, 2016 at 4:27 AM, pdysonuk@
...wrote:
>
> Randy, that's great to hear - I think it will help many people.
>
> I will tidy up my code so that it is in one module and send it to you. How
> is it best to send it to you.
>
> Regards
>
> Paul
>
>
Be sure to add a section of comments to the top of the module to indicate
you wrote it, what it's for, and whether or not you care if other people
copy it (because the add-in is open source).
On Mon, May 16, 2016 at 4:27 AM, pdysonuk@
...wrote:
>
> Randy, that's great to hear - I think it will help many people.
>
> I will tidy up my code so that it is in one module and send it to you. How
> is it best to send it to you.
>
> Regards
>
> Paul
>
>
Mon May 16, 2016 10:49 am (PDT) . Posted by:
nelsonmuntz1000
Hi Randy
The Street changed their website recently. I was using the following formula to extract letter grade and buy recommendation but it no longer works:
=smfStrExtr(RCHGetWebData("http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html","LetterGradeRating",100),":""","""")&" "&smfStrExtr(RCHGetWebData("http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html","CurrentRating",100),":""","""")
Webpage link https://www.thestreet.com/quote/aapl https://www.thestreet.com/quote/aapl
I'm a bit stumped in finding a new way to extract this data. Any help would be appreciated. Thanks in advance.
The Street changed their website recently. I was using the following formula to extract letter grade and buy recommendation but it no longer works:
=smfStrExtr(RCHGetWebData("http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html","LetterGradeRating",100),":""","""")&" "&smfStrExtr(RCHGetWebData("http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html","CurrentRating",100),":""","""")
Webpage link https://www.thestreet.com/quote/aapl https://www.thestreet.com/quote/aapl
I'm a bit stumped in finding a new way to extract this data. Any help would be appreciated. Thanks in advance.
Mon May 16, 2016 12:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("https://www.thestreet.com/quote/aapl","span",1,"Quant
Rating:",,,,1)
You can use the smfStrExtr() function to extract either piece.
On Mon, May 16, 2016 at 10:48 AM, ccoupe300@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The Street changed their website recently. I was using the following
> formula to extract letter grade and buy recommendation but it no longer
> works:
>
> =smfStrExtr(RCHGetWebData("
> http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html","LetterGradeRating",100),":""","""")&"
> "&smfStrExtr(RCHGetWebData("
> http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html
> ","CurrentRating",100),":""","""")
>
> Webpage link https://www.thestreet.com/quote/aapl
>
> I'm a bit stumped in finding a new way to extract this data. Any help
> would be appreciated. Thanks in advance.
>
>
=smfGetTagContent("https://www.thestreet.com/quote/aapl","span",1,"Quant
Rating:",,,,1)
You can use the smfStrExtr() function to extract either piece.
On Mon, May 16, 2016 at 10:48 AM, ccoupe300@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The Street changed their website recently. I was using the following
> formula to extract letter grade and buy recommendation but it no longer
> works:
>
> =smfStrExtr(RCHGetWebData("
> http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html","LetterGradeRating",100),":""","""")&"
> "&smfStrExtr(RCHGetWebData("
> http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html
> ","CurrentRating",100),":""","""")
>
> Webpage link https://www.thestreet.com/quote/aapl
>
> I'm a bit stumped in finding a new way to extract this data. Any help
> would be appreciated. Thanks in advance.
>
>
Mon May 16, 2016 1:41 pm (PDT) . Posted by:
bebentrim
is there any element number to get unadjusted historicalprices?
Mon May 16, 2016 4:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nope.
You need to use the RCHGetYahooHistory() function for those.
On Mon, May 16, 2016 at 1:41 PM, brent@
...wrote:
>
> is there any element number to get unadjusted historicalprices?
>
You need to use the RCHGetYahooHistory(
On Mon, May 16, 2016 at 1:41 PM, brent@
...wrote:
>
> is there any element number to get unadjusted historicalprices?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar