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

$10-200 AUD

Закрито

Опублікований

over 6 years ago

$10-200 AUD

Оплачується при отриманні

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.

Data Entry

Data Processing

Excel

Software Architecture

Visual Basic

ID проекту: 16015056

Про проект

24 пропозицій(-ї)

Дистанційний проект

Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

24 фрілансерів(-и) готові виконати цю роботу у середньому за $117 AUD

@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 Milestones $200 AUD - milestone

$200 AUD за 1 день

5,0

(108 відгуки(-ів))

7,6

@aubrey03

A proposal has not yet been provided

$100 AUD за 3 дні(-в)

4,9

(244 відгуки(-ів))

7,1

@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 Experience Lots of VBA experience Proposed Milestones $77 AUD - Project You can award me after I show you the results, no strings attach, you can choose any other freelancer at any time, no questions ask Price might change depending on the final description of the challenge.

$77 AUD за 10 дні(-в)

5,0

(29 відгуки(-ів))

6,9

@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, web scraping. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards

$111 AUD за 5 дні(-в)

4,8

(84 відгуки(-ів))

6,2

@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# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 Proposed Milestones $116 AUD - Macro

$116 AUD за 10 дні(-в)

4,9

(70 відгуки(-ів))

5,6

@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 I have previously done similar VBA applications and/or automations based on Excel and VBA Proposed Milestones $111 AUD - on completion Additional Services Offered $5 AUD - post delivery support I am a professional and I can do a very good job. Also an accurate one. Do not hesitate to contact me for further details.

$111 AUD за 3 дні(-в)

5,0

(38 відгуки(-ів))

5,1

@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 Excel experience 2. 12 years corporate business experience 3. Fluent in English 4. Available immediately 5. Professional and Accurate Proposed Milestones $80 AUD - 50% of agreed scope according to requirements $86 AUD - 100% completion of the project and client totally satisfied with end result

$166 AUD за 5 дні(-в)

5,0

(13 відгуки(-ів))

4,9

@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 $116 AUD - Complete Excel Workooks with Macros and Push Buttons

$116 AUD за 10 дні(-в)

4,8

(11 відгуки(-ів))

3,9

@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 Experience Microsoft excel certified Proposed Milestones $116 AUD - Give me a sample data or upload sample *.csv in the freelance task

$116 AUD за 10 дні(-в)

5,0

(1 відгук)

0,8

@degaray1

I understand very well how to extract the information from the csv. I can either create a macro you can hit on Excel or a command line type of program that will take a path to a file or files. Relevant Skills and Experience I am a senior software engineer and I have an MBA so I understand both programming and finance. Proposed Milestones $166 AUD - Final script and tested

$166 AUD за 1 день

0,0

(0 відгуки(-ів))

0,0

@Nusky40

I've the relevant knowledge as a University student and as an ACCA student with Advanced Financial Management(P4) Contact through chat for more assistance Thank You Relevant Skills and Experience ACCA Financial Management Option Pricing Proposed Milestones $50 AUD - Initial Milestone $10 AUD - Second $10 AUD - Third $10 AUD - Fourth $10 AUD - Fifth $20 AUD - Sixth $20 AUD - Final Additional Services Offered $100 AUD - Financial Management $60 AUD - Accounting

$130 AUD за 7 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@birapoguramya43

I have interested in this work so we can hire for so i will try to this work. Relevant Skills and Experience i have to worked in ms excel in accounting & data entry purpose jobs. Proposed Milestones $118 AUD - i will proved in a my work in 4 Days i have to do interested in this we can proved my self.

$116 AUD за 10 дні(-в)

0,0

(0 відгуки(-ів))

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 of the required output. Can finish within a day over the weekend and pass over the code back to you which you can copy and pass off as your own work.

$55 AUD за 7 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@manibagajo

A proposal has not yet been provided

$166 AUD за 4 дні(-в)

0,0

(0 відгуки(-ів))

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 Avançado Bacharel em Administração Gestão empresarial Proposed Milestones $30 AUD - Organizar o Arquivo CSV - 3 dias $10 AUD - Excluir Arquivos Duplicados -1 dia $60 AUD - Criar os critérios e Formulas para Busca - 4 dias $22 AUD - TEstar Projeto - dias Additional Services Offered $50 AUD - Consultoria de Negócio

$122 AUD за 10 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@sdaigneault01

A proposal has not yet been provided

$111 AUD за 7 дні(-в)

0,0

(0 відгуки(-ів))

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 - Project completion

$55 AUD за 5 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@dlopezanglero

I have an extensive experience on building useful Excel spreadsheets for identification or tracking data purposes. My open availability will ensure fast delivery.

$116 AUD за 10 дні(-в)