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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic

Näytä lisää: macro script copy data internet paste excel, script php convert excel csv, excel vba update sheets projects workbooks, 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, data entry, data processing, excel, excel vba paste cell data, macro script insert cells excel, excel cut paste using macro script, excel code paste cut cell csv, excel 2003 paste clipboard vba macro excel, excel top ten macro script visual basic

Tietoa työnantajasta:
( 184 arvostelua ) Faridabad, India

Projektin tunnus: #16015056

25 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$116 AUD 10 päivässä
(39 arvostelua)
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 Lisää

$116 AUD 10 päivässä
(56 arvostelua)
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, Lisää

$111 AUD 5 päivässä
(41 arvostelua)
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 Lisää

$111 AUD 3 päivässä
(38 arvostelua)
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 Lisää

$200 AUD 1 päivässä
(36 arvostelua)
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 Lisää

$166 AUD 5 päivässä
(12 arvostelua)
4.9
aubrey03

A proposal has not yet been provided

$100 AUD 3 päivässä
(22 arvostelua)
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 Lisää

$77 AUD 10 päivässä
(11 arvostelua)
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 Lisää

$116 AUD 10 päivässä
(11 arvostelua)
3.9
Carlosemadrizmor

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

$133 AUD 5 päivässä
(3 arvostelua)
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 Lisää

$116 AUD 10 päivässä
(1 arvostelu)
0.8
$116 AUD 7 päivässä
(0 arvostelua)
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 Lisää

$55 AUD 5 päivässä
(0 arvostelua)
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. Lisää

$55 AUD 3 päivässä
(0 arvostelua)
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 Lisää

$116 AUD 10 päivässä
(0 arvostelua)
0.0
manibagajo

A proposal has not yet been provided

$166 AUD 4 päivässä
(0 arvostelua)
0.0
sdaigneault01

A proposal has not yet been provided

$111 AUD 7 päivässä
(0 arvostelua)
0.0
$116 AUD 10 päivässä
(0 arvostelua)
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 Lisää

$122 AUD 10 päivässä
(0 arvostelua)
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 Lisää

$55 AUD 7 päivässä
(0 arvostelua)
0.0