Closed

Build a macro or script that can pull specific data from Excel or CSV workbooks and paste that data into other sheets or workbooks

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.

Skills: Data Entry, Data Processing, Excel, Software Architecture, Visual Basic

See more: excel macro to copy data from one sheet to another based on criteria, copy data from one excel workbook to another using macro, excel macro create new sheet copy data, excel macro to create new workbook based on value in cells, excel macro pull data from another workbook, excel macro create new workbook with name, macro to copy and paste from one workbook to another, excel vba create new workbook and copy data, macro script copy data internet paste excel, script php convert excel csv, excel vba update sheets projects workbooks, excel vba paste cell data, macro script insert cells excel, excel cut paste using macro script, excel code paste cut cell csv

About the Employer:
( 184 reviews ) Faridabad, India

Project ID: #16015056

25 freelancers are bidding on average $117 for this job

$116 AUD in 10 days
(39 Reviews)
5.7
abhinovpankaj

have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# us More

$116 AUD in 10 days
(56 Reviews)
5.5
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects which involved Excel, scripting, More

$111 AUD in 5 days
(41 Reviews)
5.2
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. Relevant Skills and Experience More

$111 AUD in 3 days
(38 Reviews)
5.1
tiaratechies

Hello, we are a team of certified excel experts that can write any kind of code and we are teaching excel since 2004, we can give you the best in very short span of time. Relevant Skills and Experience excel Proposed More

$200 AUD in 1 day
(36 Reviews)
5.2
WesleyJeftha

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

$166 AUD in 5 days
(12 Reviews)
4.9
aubrey03

A proposal has not yet been provided

$100 AUD in 3 days
(22 Reviews)
4.9
FerriSoft1

Hi, I love this kind of challenges! I'm willing to receive your excel and .csv files and do the work without you awarding me, just to show you that I can do this things accurately and fast. Relevant Skills and Experie More

$77 AUD in 10 days
(11 Reviews)
4.2
jhony1981

I am an expert in excel, VBA, macros and cost budgeting having more than 10 years of experience, I can surely do the job. Relevant Skills and Experience Excel, Finance, Accounting, VBA, Macros Proposed Milestones $11 More

$116 AUD in 10 days
(11 Reviews)
3.9
Carlosemadrizmor

I can work full time for.you. I have code VBA ready [login to view URL] project.

$133 AUD in 5 days
(3 Reviews)
3.1
berincg

I am not a finance data expert. Correct me if I am wrong. You have 3year*365 *.csv files with stock data with key fields(index) and need particular range of date from this files based on the index. Relevant Skills and More

$116 AUD in 10 days
(1 Review)
0.8
$116 AUD in 7 days
(0 Reviews)
0.0
umairfaiz

Experience in data entry and finance Relevant Skills and Experience Excel, Accounting, data entry, data analysis, fast learner, creative, detail oriented and have good English skills Proposed Milestones $55 AUD - Pro More

$55 AUD in 5 days
(0 Reviews)
0.0
chanduqtp

As a new freelancer, i would like to prove [login to view URL] for a chance... Relevant Skills and Experience I had hands on experience in excel macros/vb script and reading/writing data from/to excel sheets and csv files. More

$55 AUD in 3 days
(0 Reviews)
0.0
AlexeyGolyakov

7000 rows are not much. Recently I've built a script that worked with a billion of records in multiple CSV files. Excel may choke on that amount but I will use Python for data manipulation. Relevant Skills and Experie More

$116 AUD in 10 days
(0 Reviews)
0.0
manibagajo

A proposal has not yet been provided

$166 AUD in 4 days
(0 Reviews)
0.0
sdaigneault01

A proposal has not yet been provided

$111 AUD in 7 days
(0 Reviews)
0.0
$116 AUD in 10 days
(0 Reviews)
0.0
viniciusjovinno

Great experience in doing this type of service, a great power of business analysis, and very focused, also experience in financial and administrative analysis. Relevant Skills and Experience Analista de Negócios Excel More

$122 AUD in 10 days
(0 Reviews)
0.0
guoguang

I work in a treasury products middle office dealing with derivatives and structured products and this is similar to what i do in my day to day work. Will require your file samples for the relevant columns and a sample More

$55 AUD in 7 days
(0 Reviews)
0.0