2 Messages

Digest #4066

Starting Date of Data Series by bushpilote

Re: Starting Date of Data Series by "Randy Harmelink" rharmelink

Messages

1a

Hi Randy,
prior to the changes at Yahoo finance, the following formula retrieved the starting date
of closing prices for a given security (A3=ticker ^gspc) :

[=IFERROR(DATEVALUE(smfGetTagContent("http://finance.yahoo.com/q/hp?s="&A3,"option",0,"name=""a""","option selected")&" "
&smfstrExtr(RCHGetWebData("http://finance.yahoo.com/q/hp?s="&A3,"id=""startday""",100),"value=""","""")&", "
&smfstrExtr(RCHGetWebData("http://finance.yahoo.com/q/hp?s="&A3,"id=""startyear""",100),"value=""","""")),NA())]

Any suggestions how to get this work under their new set up?

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Starting Date of Data Series

Wed Jun 21, 2017 8:48 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfUNIX2Date(smfStrExtr(RCHGetWebData("https://finance.yahoo.com/quote/
"&F17&"/history","firstTradeDate",50),""":",","))

On Wed, Jun 21, 2017 at 6:30 AM, bushpilote@
...
wrote:

> prior to the changes at Yahoo finance, the following formula retrieved
> the starting date
>
> of closing prices for a given security (A3=ticker ^gspc) :
>
> [=IFERROR(DATEVALUE(smfGetTagContent("http://finance.yahoo.com/q/hp?s=
> "&A3,"option",0,"name=""a""","option selected")&" "
>
> &smfstrExtr(RCHGetWebData("http://finance.yahoo.com/q/hp?s="
> &A3,"id=""startday""",100),"value=""","""")&", "
>
> &smfstrExtr(RCHGetWebData("http://finance.yahoo.com/q/hp?s="
> &A3,"id=""startyear""",100),"value=""","""")),NA())]
>
> Any suggestions how to get this work under their new set up?
>