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
