T24 : How to find Cross Currency Rate

[Ahmet Baysa]

Dear Members,

I would like to find a function which calculates the cross currency rates with the given two non local currency. Is there any core function available for this already?

Thanks in advance,

Ahmet Baysa

[Ali Javaid]

Dear Ahmet,

You can use EXCHRATE subroutine to Performs all the tasks involved in foreign exchange of two currencies.

Arguments:

CCY.MKT,BUY.CCY,BUY.AMT,SELL.CCY, SELL.AMT,BASE.CCY,EXCHANGE.RATE, DIFFERENCE,LCY.AMT,RETURN.CODE

Incoming:
CCY.MKT	The currency market in which the transaction will take place
BUY.CCY and SELL.CCY	The currencies that will be involved in the transaction
BUY.AMT and SELL.AMT	The amounts that will be involved in the transaction
BASE.CCY	The currency in terms of which the EXCHANGE.RATE will be expressed
EXCHANGE.RATE	The rate of exchange between the two currencies
	If any of these fields, with exception of BUY/SELL CCY and CCY.MKT are left blank, then they will be filled in by the routine if at all possible

Returned:
DIFFERENCE	The difference between the figures given above and the internally generated BASE.CCY amount
LCY.AMT	The amount of the transactions in terms of the local currency
RETURN.CODE	The status of various tests performed during the course of the routine. RETURN.CODE is a dynamic array composed of six fields, which are as follows: -
	1) Invalid input parameter - This is a fatal error and the routine will immediately terminate. In such a case, this field is set to 1 and an explanation of the error returned in ETEXT
	2) Tolerance error - This is the signed percentage value by which the input rate differs from the calculated rate to 2 decimal places.  This is only set if the error is greater than that permitted for the BASE.CCY.
	3) Negotiable amount exceeded - The field is set to 1 if the BUY.AMT exceeds the NEGOTIABLE AMOUNT for the BUY.CCY. It is set to 2 if this is true for the SELL.CCY and 3 if true for both currencies

 
--
Regards,
Ali Javaid Hussain
Cell # +92-300-2760352 | Cell # +92-321-8254352
Text:  +92-321-8254352 | E: aline...@gmail.com

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines
 
IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

--

[Ahmet Baysa]

Hi Ali,

I have tried this already but could not achieved it. I don't know the reason yet.

I used it like this :



Rate returns 0.5 which is the cross currency rate based on given amounts and not the actual cross currency rate drived from Currency table.

Thanks

Ahmet

[Ahmet Baysa]

this is the way how I used this call routine

CALL EXCHRATE(01,"USD", 10000,"GBP",5000,"GBP",RATE,DIFF,LCY.AMT,CODE)

...

On Thu, Sep 1, 2011 at 3:48 PM, Ahmet Baysa <ahmet...@gmail.com> wrote:

Hi Ali,

I have tried this already but could not achieved it. I don't know the reason yet.

I used it like this :

[Sem Nengomasha]

Do u have a currency market 01 generally its 1 check and advise

[Ahmed Ali Nisar]

Dear Ahmet,

   Please check your Currency Market, coz normally it is set to 1 instead of 01 as advised by Sem.

Ahmed Ali Nisar          

Temenos T24 Consultant

Sapphire Consulting Service

+92 345 330 6585

[Ali Javaid]

Dear Ahmet,

Check the currency market 01 for both currencies and what the value return in variables (DIFF), (LCY.AMT) and (CODE). 

--
Regards,
Ali Javaid Hussain
Cell # +92-300-2760352 | Cell # +92-321-8254352
Text:  +92-321-8254352 | E: aline...@gmail.com

On Thu, Sep 1, 2011 at 7:34 PM, Sem Nengomasha <humble...@gmail.com> wrote:

[Ahmet Baysa]

I

On Fri, Sep 2, 2011 at 10:50 AM, Ahmet Baysa <ahmet...@gmail.com> wrote:

CALL EXCHRATE(1,"USD", 10000,"GBP",5000,"GBP",RATE,DIFF,LCY.AMT,RETURN.CODE)


Result:

jsh limtest ~ -->RATETEST
DIFF 0.00
LCY.AMT 5676.66
RATE 2.000000000
RETURN.CODE þ22.59þþþþY
jsh limtest ~ -->

On Fri, Sep 2, 2011 at 10:46 AM, Ahmet Baysa <ahmet...@gmail.com> wrote:

 input param : EXCHANGE.RATE The rate of exchange between the two currencies

This is the value whcih I would like to get, but it seems that it is an input parameter? Strange, if I know the rate whay should I use this subroutine then?

Regards,

[Ahmet Baysa]

 input param : EXCHANGE.RATE The rate of exchange between the two currencies

This is the value whcih I would like to get, but it seems that it is an input parameter? Strange, if I know the rate whay should I use this subroutine then?

Regards,

[Ahmet Baysa]

I think I found th way.


CALL EXCHRATE(1,"USD", 0,"GBP",0,"GBP",RATE,DIFF,LCY.AMT,RETURN.CODE)

DIFF
LCY.AMT
RATE 1.631471390
CODE

RATE is the actual rate between two currencies.... The question is how to decide the BASE.CCY in between two currencies? Ranking?

Thanks

[Ahmet Baysa]

CALL EXCHRATE(1,"USD", 10000,"GBP",5000,"GBP",RATE,DIFF,LCY.AMT,RETURN.CODE)


Result:

jsh limtest ~ -->RATETEST
DIFF 0.00
LCY.AMT 5676.66
RATE 2.000000000
RETURN.CODE þ22.59þþþþY
jsh limtest ~ -->

On Fri, Sep 2, 2011 at 10:46 AM, Ahmet Baysa <ahmet...@gmail.com> wrote: