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
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?
>
RCHGetTableCell() function. For example:
=RCHGetTableCell("
http://bigcharts.marketwatch.com/historical/default.asp?symb=DJIA&closeDate=10/30/2014",1,"
Price:"
On Sat, Nov 7, 2015 at 9:19 AM, John Hoel johnhoel1248@
>
> 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.
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(
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?
>
=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(
> 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?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar