Using TRY Currency in Excel

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Using TRY Currency in Excel

ElMariachi
I am having an error using TRY Currency when constructing an Ibor index in Excel. I am using the qlIborIndex function with Currency = "TRY"

The error returned is: "Unknown id for Type: TRY"

I noticed that TRYCurrency is defined in the source code, so what could be going wrong here? How can I work around this error?
Reply | Threaded
Open this post in threaded view
|

Re: Using TRY Currency in Excel

Andrew Downes
Hi,

You need to define it in the file enumeratedtypes.xml, in the project
qlgensrc. Look for the EnumeratedTypeGroup QuantLib::Currency and add
that currency in the same way as the rest of them.

Cheers,

Andrew


-----Original Message-----
From: ElMariachi [mailto:[hidden email]]
Sent: Wednesday, 29 September 2010 3:52 AM
To: [hidden email]
Subject: [Quantlib-users] Using TRY Currency in Excel


I am having an error using TRY Currency when constructing an Ibor index
in Excel. I am using the qlIborIndex function with Currency = "TRY"

The error returned is: "Unknown id for Type: TRY"

I noticed that TRYCurrency is defined in the source code, so what could
be going wrong here? How can I work around this error?
--
View this message in context:
http://old.nabble.com/Using-TRY-Currency-in-Excel-tp29831121p29831121.ht
ml
Sent from the quantlib-users mailing list archive at Nabble.com.




"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."

------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: Using TRY Currency in Excel

Ferdinando M. Ametrano-3
> You need to define it in the file enumeratedtypes.xml, in the project
> qlgensrc. Look for the EnumeratedTypeGroup QuantLib::Currency and add
> that currency in the same way as the rest of them.

fixed in the code repository. Look for it in the next release or
update your build

ciao -- Nando

------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: Using TRY Currency in Excel

ElMariachi
Thanks for the fixes guys - sorry i've been rather quiet, got laid off :( i'll probably return to activity over the next few months - i really like this project and would love to learn it inside and out.  

On Wed, Sep 29, 2010 at 4:11 AM, Ferdinando Ametrano <[hidden email]> wrote:
> You need to define it in the file enumeratedtypes.xml, in the project
> qlgensrc. Look for the EnumeratedTypeGroup QuantLib::Currency and add
> that currency in the same way as the rest of them.

fixed in the code repository. Look for it in the next release or
update your build

ciao -- Nando


------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users