Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computing > Computer Information > cost price calculation for a multi-currency trade

Thread Tools

cost price calculation for a multi-currency trade

Posts: n/a
scenario 1
transaction details:
date currency quantity price exchange rate as on date for EUR
in USD
1-Oct-03 eur 100 15 1.0294
2-Oct-03 usd -50 25 1.0415
10-Oct-03 usd 150 25 1.0412
15-Oct-03 eur -125 15 1.0413

I want to find out the average cost for the particular transacted
security and the method for the same in different currencies.

Will the cost price vary with change in exchange rate on particular
future dates on which the valuation is done.Please keep in mind that
actual data will have millions of such rows and the data will be
consolidated using a carry forward mechanism.If anyone has faced
similar problems please respond and tell me how you handled the

thanks in advance
deepak goyal
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
The World Trade Plaza - Free Trade Leads merwick.k Ruby 3 09-23-2008 08:21 PM
Trade Me - Price changes have begun Vista NZ Computing 7 03-28-2006 10:37 AM
Cost Calculation Function With Parsed Numbers to Currency: Need Help Combining Functions Neredbojias HTML 3 10-04-2005 12:55 AM
Computers at Trade Price Tony Higson Computer Support 4 04-16-2004 07:10 AM