Selasa, 17 Mei 2016

[smf_addin] Digest Number 3700

6 Messages

Digest #3700
1a
Re: Macintosh by pdyson10
1b
Re: Macintosh by "Randy Harmelink" rharmelink
2a
The Street Quant Rating by nelsonmuntz1000
2b
Re: The Street Quant Rating by "Randy Harmelink" rharmelink
3a
Unadjusted prices by bebentrim
3b
Re: Unadjusted prices by "Randy Harmelink" rharmelink

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





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
>
>

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.

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.
>
>

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?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar