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

Annullerat Publicerat 6 år sedan Betalades vid leverans

$30-250 AUD

Betalades vid leverans

Annullerat Betalades vid leverans

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.

Datainmatning Databehandling Excel Programvaruarkitektur Visual Basic

Projekt-id: #16015176

About the project

19 offerter Distansprojekt Aktivt 6 år sedan

Skulle du vilja tjäna pengar?

Fördelar med att lägga anbud på Freelancer

Ställ in budget och tidsram
Få betalt för ditt arbete
Skissa på ditt förslag
Det är gratis att registrera sig och lägga bud på jobb

19 frilansare har lagt bud på i genomsnitt $160 för det här jobbet

zu02s Profilbild
zu02

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

$250 AUD inom 3 dagar
(31 omdömen)
5.8
JonNxts Profilbild
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 Mer

$111 AUD inom 2 dagar
(38 omdömen)
5.1
WesleyJefthas Profilbild
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 Mer

$188 AUD inom 3 dagar
(5 omdömen)
4.2
Devotion20s Profilbild
Devotion20

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 Mer

$70 AUD inom 3 dagar
(8 omdömen)
3.7
vmadhavan15s Profilbild
vmadhavan15

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

$250 AUD inom 5 dagar
(7 omdömen)
3.4
ongskjasons Profilbild
ongskjason

I am an advanced user in Excel.

$200 AUD inom 3 dagar
(2 omdömen)
2.8
supper5guys Profilbild
supper5guy

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 Mer

$155 AUD inom 3 dagar
(2 omdömen)
1.6
B19s Profilbild
B19

Hi I have 10 years experience in programming Excel (and vba). I work in the IT telecommunications company. Relevant Skills and Experience Excel, VBA, Power BI. Visual Basic. SQL query. Proposed Milestones $144 AUD - Mer

$144 AUD inom 2 dagar
(2 omdömen)
1.0
FerriSoft1s Profilbild
FerriSoft1

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 Mer

$155 AUD inom 3 dagar
(0 omdömen)
0.0
rajushuklas Profilbild
rajushukla

A proposal has not yet been provided

$55 AUD inom 2 dagar
(0 omdömen)
0.0
wajahatvohra6s Profilbild
wajahatvohra6

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.

$277 AUD inom 15 dagar
(0 omdömen)
0.0
ranganath023s Profilbild
ranganath023

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 Mer

$155 AUD inom 3 dagar
(0 omdömen)
0.0
jsiebalts Profilbild
jsiebalt

There is little more tedious for a company to do than hunt for data across multiple platforms and documents. My appreciation for macros will ensure a set of useful scripts to reduce this tediousness. Relevant Skills a Mer

$94 AUD inom 3 dagar
(0 omdömen)
0.0
stephentyries Profilbild
stephentyrie

Very experienced in retrieving information from various workbooks to provide results

$55 AUD inom 2 dagar
(0 omdömen)
0.0
madurapras Profilbild
madurapra

I am a Graduate with subject Industrial Mathematics and I am Good in Excel Macros. You will definitely glad on your selection. Relevant Skills and Experience Currently I am working to a Leading Apparel company as a So Mer

$50 AUD inom 2 dagar
(0 omdömen)
0.0
RynRcfrts Profilbild
RynRcfrt

Hi I have 8 years VBA experience and mostly handled bank clients.

$222 AUD inom 10 dagar
(0 omdömen)
0.0
Lägg upp ett liknande projekt