The objective is to generate a P&L report for transacted and open securities trades for variable time periods. The start and end dates are entered by the user to determine the period.
A static excel file (DEE) holds the entry date , exit date and security id data. The script checks in DEE for the affected securities. The script accesses the associated security id Price series data file (SPF) for each affected security and extracts the price data for P&L calculation.
This is the basic objective. There is more potentially more development work foreseen on this project.
8 freelancers are bidding on average $176 for this job
Hi. I am a freelance programmer with quite good experience in Visual Basic. We can dicuss in depth and handle the project to produce correct results. Thanks.