1 New Message
Digest #2284
Message
Thu Jul 19, 2012 3:15 pm (PDT) . Posted by:
"Doug" doug_kirkpatrick
I actually found the answer to my own question. I found the currency futures pricing on the CME website and used the GetTableCell equation to fetch the price. For those that come along later wanting to know how I did this, here is the equation I used to pull the price on the Sep12 EUR/USD futures contract price:
=RCHGetTableCell("http://www.cmegroup.com/trading/fx ",7,">Globex Volume",,,,5)
--- In smf_addin@yahoogroups.com , "Doug" <doug_kirkpatrick@...> wrote:
>
> Hi, I'm a newbie around here. I'm trying to link to CME currencies futures pricing but have failed so far.
>
> I have been able to get pricing from Yahoo but it appears to be wrong. For example, I am getting Sep12 euro/$ futures pricing with the following equation: =RCHGetYahooQuotes(ECU12.CME,last price,,,).
>
> I haven't found this pricing on CME yet but perhaps it's a case of me not being able to find it. If I were able to find it there, what would be the equation I would use.
>
> I used to have a full blown Bloomberg subscription that I used to get the currencies futures in the past, but alas, I no longer have that subscription. Is it possible to the these prices from Bloomberg.com and if so, what would be the equation I would use?
>
> Thanks for your help!
>
=RCHGetTableCell(
--- In smf_addin@yahoogrou
>
> Hi, I'm a newbie around here. I'm trying to link to CME currencies futures pricing but have failed so far.
>
> I have been able to get pricing from Yahoo but it appears to be wrong. For example, I am getting Sep12 euro/$ futures pricing with the following equation: =RCHGetYahooQuotes(
>
> I haven't found this pricing on CME yet but perhaps it's a case of me not being able to find it. If I were able to find it there, what would be the equation I would use.
>
> I used to have a full blown Bloomberg subscription that I used to get the currencies futures in the past, but alas, I no longer have that subscription. Is it possible to the these prices from Bloomberg.com and if so, what would be the equation I would use?
>
> Thanks for your help!
>
Tidak ada komentar:
Posting Komentar