Find Jobs
Hire Freelancers

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

Closed
Posted about 6 years ago

$10-200 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: 16015056

About the project

25 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
25 freelancers are bidding on average $117 AUD for this job
User Avatar
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 in 1 day
5.0 (36 reviews)
5.2
5.2
User Avatar
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 in 10 days
4.9 (56 reviews)
5.5
5.5
User Avatar
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 in 3 days
5.0 (38 reviews)
5.1
5.1
User Avatar
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 in 5 days
5.0 (12 reviews)
4.9
4.9
User Avatar
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 in 5 days
4.9 (41 reviews)
5.2
5.2
User Avatar
A proposal has not yet been provided
$100 AUD in 3 days
4.7 (22 reviews)
4.9
4.9
User Avatar
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 in 10 days
5.0 (11 reviews)
4.2
4.2
User Avatar
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 in 10 days
4.7 (11 reviews)
3.9
3.9
User Avatar
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 in 10 days
5.0 (1 review)
0.8
0.8
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$166 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 Experience Excel, Python Proposed Milestones $50 AUD - one $50 AUD - two $16 AUD - three
$116 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Faridabad, India
5.0
184
Payment method verified
Member since Feb 21, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.