Minggu, 08 November 2015

[smf_addin] Digest Number 3553

5 Messages

Digest #3553

Messages

Sat Nov 7, 2015 11:26 am (PST) . Posted by:

"John Hoel"

I am trying to get historical index quotes from BigCharts. I have searched
the element definitions in the RCHGetElementNumber documentation
spreadsheet and can find no mention of BigCharts. Does any SMF add-in
support historical quotes from BigCharts?

--
John Hoel

Sat Nov 7, 2015 11:33 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It just gives you data one day at a time, right? If so, just use the
RCHGetTableCell() function. For example:

=RCHGetTableCell("
http://bigcharts.marketwatch.com/historical/default.asp?symb=DJIA&closeDate=10/30/2014",1,"Closing
Price:")

On Sat, Nov 7, 2015 at 9:19 AM, John Hoel johnhoel1248@...wrote:

>
> I am trying to get historical index quotes from BigCharts. I have searched
> the element definitions in the RCHGetElementNumber documentation
> spreadsheet and can find no mention of BigCharts. Does any SMF add-in
> support historical quotes from BigCharts?
>

Sat Nov 7, 2015 6:43 pm (PST) . Posted by:

john_hoel

I would not have known to use the function that way from the function documentation, so many thanks!

This leaves me with one problem. I want to use cell references to construct the date. I have tried to use something like C language concatenations to build the URL but it doesn't work. This is what I tried:

=RCHGetTableCell("http://bigcharts.marketwatch.com/historical/default.asp?symb=WFBDC&closeDate="Month(A21)"/"Day(A21)"/"Year(A21)"",1,"Closing Price:")

Can you suggest a method to dynamically build a URL, or any quoted string for that matter, that can be substituted into a cell formula?

Thanks for your help.

Sat Nov 7, 2015 6:46 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

With both ticker symbol and date as referenced cells:

=RCHGetTableCell("
http://bigcharts.marketwatch.com/historical/default.asp?symb="&B7&"&closeDate="&TEXT(C7,"mm/dd/yyyy"),1,"Closing
Price:")

On Sat, Nov 7, 2015 at 7:39 PM, john@... wrote:

>
> I would not have known to use the function that way from the function
> documentation, so many thanks!
>
> This leaves me with one problem. I want to use cell references to
> construct the date. I have tried to use something like C language
> concatenations to build the URL but it doesn't work. This is what I tried:
>
> =RCHGetTableCell("
> http://bigcharts.marketwatch.com/historical/default.asp?symb=WFBDC&closeDate="Month(A21)"/"Day(A21)"/"Year(A21)"",1,"Closing
> Price:")
>
> Can you suggest a method to dynamically build a URL, or any quoted string
> for that matter, that can be substituted into a cell formula?
>

Sat Nov 7, 2015 6:52 pm (PST) . Posted by:

john_hoel

Your solution works! Thanks so much!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar