Before deciding to trade foreign exchange or any other financial instrument or cryptocurrencies you should carefully consider your investment objectives, level of experience, and risk appetite. Cryptocurrencies are not suitable for all investors. Prices of cryptocurrencies are extremely volatile and may be affected by external factors such as financial, regulatory or political events. Trading or investing in cryptocurrencies carries with its potential risks. Currency trading on margin involves high risk and is not suitable for all investors. Please be fully informed regarding the risks and costs associated with trading the financial markets, it is one of the riskiest investment forms possible. step5: Divide USD Amount with result from step 4Īny help is appreciated.Risk Disclosure: Fusion Media will not accept any liability for loss or damage as a result of reliance on the information contained within this website including data, quotes, charts and buy/sell signals. step4: Get conversion rate for **DestinationCurrency** step3 : Multiply with amount (Here we have USD value for amount) step2 : Get conversition rate for **Amountcurrency** using select query to table2 I was thinking to have a loop like, While (Select Count(*) From Table1) > 0 What is the best way to iterate Table1 rows and do the conversion and update it in CalculateAmountInDestinationCurrency column. My Table1 has around 10000 rows and Table2 has conversion rate for all the currencies for all dates till now.
Since we want to convert it to CAD get conversion rate for 1 CAD on given conversion_date, 1 CAD = 0.9399380000 USD, now we need to convert 1.60752 USD to CAD that can be done by dividing it with CAD rate i.e 1.60752/1.60752 = 1.71024 CAD. something like, select Rate from Table1 where converstion_Date = '' and Currency = 'INR'.Ībove query will give me 0.0160752000 and we will convert INR TO USD i.e As per math I will get conversation rate for 1 INR on given conversion_date from Table2 multiple it by AmountCurrency. Ĭonvert Amount from amountCurrency to destination currency and update it in last column of Table1Įxample : Amount in row one of Table1 is in INR and I want to convert it to CAD.
I have two tables, Table1 with amount, amountCurrency and destination currency and Table2 have the conversion rate(As mentioned in image conversation rate are in terms of USD).
0 kommentar(er)
