You can specify the currency as an option like this:
bdh(conn, "SX5E Index", "PX_LAST", start_date=as.Date("2013-12-01"),
option_names="currency", option_values="USD")
-John
On Fri, Dec 13, 2013 at 1:22 PM, Pierre Lapointe <[email protected]>wrote:
> In Excel, I can download a European index and translate the price in USD by
> adding "FX=USD" at the end of the BDH request.
>
> =BDH("SX5E Index","PX_LAST","12/1/2013","","FX=USD")
>
> How can I change the currency with "FX=USD" in R?
>
> I have hundreds of series to download and it's not always obvious what
> currency they trade in (it's not always stocks). Also I know I can do that
> in Matlab, but I would prefer to use R.
>
> Pierre
>
> [[alternative HTML version deleted]]
>
> _______________________________________________
> [email protected] mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only. If you want to post, subscribe first.
> -- Also note that this is not the r-help list where general R questions
> should go.
>
[[alternative HTML version deleted]]
_______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-sig-finance
-- Subscriber-posting only. If you want to post, subscribe first.
-- Also note that this is not the r-help list where general R questions should
go.
