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 On Fri, Sep 2, 2011 at 11:00 AM, Ahmet Baysa <[email protected]> wrote: > I > > > On Fri, Sep 2, 2011 at 10:50 AM, Ahmet Baysa <[email protected]>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 <[email protected]>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, >>> >>> >>> >>> >>> On Thu, Sep 1, 2011 at 11:23 PM, Ali Javaid <[email protected]>wrote: >>> >>>> >>>> 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: [email protected] >>>> >>>> >>>> >>>> On Thu, Sep 1, 2011 at 7:34 PM, Sem Nengomasha >>>> <[email protected]>wrote: >>>> >>>>> Do u have a currency market 01 generally its 1 check and advise**** >>>>> >>>>> ** ** >>>>> >>>>> *From:* [email protected] [mailto:[email protected]] *On >>>>> Behalf Of *Ahmet Baysa >>>>> *Sent:* Thursday, September 01, 2011 4:50 PM >>>>> *To:* [email protected] >>>>> *Subject:* Re: T24 : How to find Cross Currency Rate**** >>>>> >>>>> ** ** >>>>> >>>>> >>>>> >>>>> 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 <[email protected]> >>>>> 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 : >>>>> >>>>> >>>>> >>>>> 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**** >>>>> >>>>> >>>>> >>>>> >>>>> **** >>>>> >>>>> On Thu, Sep 1, 2011 at 1:13 PM, Ali Javaid <[email protected]> >>>>> wrote:**** >>>>> >>>>> >>>>> 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: [email protected] >>>>> >>>>> **** >>>>> >>>>> On Thu, Sep 1, 2011 at 3:21 PM, Ahmet Baysa <[email protected]> >>>>> wrote:**** >>>>> >>>>> >>>>> 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**** >>>>> >>>>> -- >>>>> 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 [email protected] >>>>> To unsubscribe, send email to [email protected] >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/jBASE?hl=en**** >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> **** >>>>> >>>>> -- >>>>> 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 [email protected] >>>>> To unsubscribe, send email to [email protected] >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/jBASE?hl=en**** >>>>> >>>>> ** ** >>>>> >>>>> ** ** >>>>> >>>>> -- >>>>> 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 [email protected] >>>>> To unsubscribe, send email to [email protected] >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/jBASE?hl=en**** >>>>> >>>>> -- >>>>> 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 [email protected] >>>>> To unsubscribe, send email to [email protected] >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/jBASE?hl=en >>>>> >>>> >>>> >>>> >>>> >>>> -- >>>> 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 [email protected] >>>> To unsubscribe, send email to [email protected] >>>> For more options, visit this group at >>>> http://groups.google.com/group/jBASE?hl=en >>>> >>> >>> >> > -- 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 [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
