2 Messages
Digest #3504
Messages
Sun Sep 6, 2015 4:45 am (PDT) . Posted by:
rjemery7
For a given symbol, is it possible to retrieve the dates of the 52-Week Low and High?
Sun Sep 6, 2015 5:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
BarChart.com has the data:
=smfStrExtr(RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/"&$C6,1,">Historical
Highs and Lows","12-Month")," on ","~")
=smfStrExtr(RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/"&$C6,2,">Historical
Highs and Lows","12-Month")," on ","~")
You could also use the smfPricesBetween() function.
On Sun, Sep 6, 2015 at 4:45 AM, rjemery@... wrote:
>
> For a given symbol, is it possible to retrieve the dates of the 52-Week
> Low and High?
>
=smfStrExtr(RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/"&$C6,1,">Historical
Highs and Lows","12-Month")," on ","~")
=smfStrExtr(RCHGetTableCell("http://www.barchart.com/detailedquote/stocks/"&$C6,2,
Highs and Lows","
You could also use the smfPricesBetween(
On Sun, Sep 6, 2015 at 4:45 AM, rjemery@... wrote:
>
> For a given symbol, is it possible to retrieve the dates of the 52-Week
> Low and High?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar