Build a macro or script that can pull specific data from Excel or CSV workbooks and paste that data into other sheets or workbooks -- 2
$30-250 AUD
Paid on delivery
We are a financial and securities firm. We are building an options trading model and need to test that model using historical options pricing. We have 3 years' of historical data on all Options relating to a specific stock index. Each day's pricing for every Option relating to that index resides in a separate CSV workbook (single sheet). For the specific Options that our model identifies (each Option is identified by Option type (Call or Put), Expiration date and Strike Price) we need to pull the daily Option prices for a handful of consecutive dates. This means pulling data from different workbooks or pasting several of the separate CSV workbooks into one sheet or workbook, and pasting it into an analysis sheet or workbook. This is made more difficult because each CSV file (each day's file) is 7000 rows and each contains only 6 or 7 relevant rows out of 7000. The macro or script will need to look at the Analysis sheet to identify the expiration and Strike price and then go to the relevant CSV file(s) and find the right row etc.
Project ID: #16015176
About the project
19 freelancers are bidding on average $160 for this job
Hi, there I can code your current project via Ms Access software Relevant Skills and Experience I'm programming in VB/SQL/Access since 1997 Proposed Milestones $250 AUD - default
I specialise in data extraction and data aggregation. My approach does not involved macros, I can achieve all the complex data transformation with standard excel capability. Relevant Skills and Experience 1. 17 years More
Hi there! I’m Bhakti from India &I’m really interested in the project you’ve posted. I would like to be contacted & get more details about this project. please attach example sheet to get better idea Relevant Skills a More
I am not a random bidder... I hope I can do this one.. Plesae ping me if you are interested with my proposal and thank you.. Relevant Skills and Experience VBA Proposed Milestones $250 AUD - final
with my more than 10 years experience working with Microsoft excel and my drive for excellence, i can develop the best and most accurate macro in less than your allocated time Relevant Skills and Experience Attention More
Hi, I apologize for my recommendation, but this is a proyect that I would rather do as an App and not as a Macro, because it will be time intesive. With an App it easy to show progress Relevant Skills and Experience More
Hi there I can help you with this task. I am working in this field for 2 years. looking forward to your reply to discuss further.
Hi there, I can complete the work in 2 to 3 days, or even before that depending on the data. But I can assure U that I would complete the work as per Ur expectation and the quality. Relevant Skills and Experience I ha More
