2 New Messages
Digest #2789
Messages
Fri Sep 27, 2013 12:49 pm (PDT) . Posted by:
"Michael Thomas" thomas91112
Let's use http://www.visionfinancialmarkets.com/futures/tools/quotes/
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, September 27, 2013 12:36 PM
Subject: Re: [smf_addin] Stock & Commodity Futures
Depends entirely on the source of the data...
On Fri, Sep 27, 2013 at 10:57 AM, <thomas91112@yahoo.com> wrote:
>Which function works best for retrieving futures pricing?
>
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Friday, September 27, 2013 12:36 PM
Subject: Re: [smf_addin] Stock & Commodity Futures
Depends entirely on the source of the data...
On Fri, Sep 27, 2013 at 10:57 AM, <thomas91112@
>Which function works best for retrieving futures pricing?
>
Fri Sep 27, 2013 1:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Note -- the data is actually put onto the page by an external JavaScript,
so it's from there that the data needs to be extracted.
To get an individual price:
=RCHGetTableCell("
http://vfm.websol.barchart.com/default.php?&domain=vfm&display_ice=&tz=0&ed=0",5,"
as of ",">EURO FX")
To get the whole table:
=RCHGetHTMLTable("
http://vfm.websol.barchart.com/default.php?&domain=vfm&display_ice=&tz=0&ed=0
","",2,"",2)
On Fri, Sep 27, 2013 at 12:49 PM, Michael Thomas <thomas91112@yahoo.com>wrote:
>
> Let's use http://www.visionfinancialmarkets.com/futures/tools/quotes/
>
>
so it's from there that the data needs to be extracted.
To get an individual price:
=RCHGetTableCell(
http://vfm.websol.
as of ","
To get the whole table:
=RCHGetHTMLTable(
http://vfm.websol.
","
On Fri, Sep 27, 2013 at 12:49 PM, Michael Thomas <thomas91112@
>
> Let's use http://www.visionfi
>
>
Tidak ada komentar:
Posting Komentar