Ditutup

Excel-based securities trading simulation program - VBA/Scripting likely required

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. We are seeking someone to build an Excel-based trade back-testing program. The Purpose of the Program is to simulate a series of daily trades (option credit spreads), whereby, on a daily basis, 4 credit spreads are initiated each trading day: 1 Weekly Put Spread, 1 Weekly Call Spread, 1 Monthly Put Spread and 1 Monthly Call Spread.

Key components of the program, or VBA Macro will be in-sheet calculations (relatively simple), pulling price data (each day's pricing for every Option resides in a separate CSV workbook (single sheet) and will need to be ‘pulled’ into the main workbook from a separate file) and V-lookup type functions based on data already contained in the main workbook. 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 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. If your bid is of interest we will provide a written document containing more detailed specs, a sample output sheet, a template for the Main Workbook and a sample CSV or ZIP file containing one day’s prices. We need this done within 2 to 3 days of awarding the project – so if you are too busy, please do not bid. We plan to award this project within 24 hours of posting. This project is an UPDATED version of an earlier posting (the earlier posting was cancelled). PLEASE DO NOT RE-POST THIS PROJECT.

Kemahiran: Pemprosesan Data, Excel, VB.NET, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: excel macros for trading, excel trading software, algorithmic trading using excel, build an automated stock trading system in excel pdf, build an automated stock trading system in excel free download, excel formulas for stock trading, algorithmic trading vba, excel trading spreadsheet, Excel based project , Excel Based work project, excel based inventory program, excel based database vba, excel based project, excel based project userform, excel based project management software, sort excel based project, excel based inventory management project, turn excel based project management software web based, form based project excel vba, time based simulation using vba

Tentang Majikan:
( 0 ulasan ) Brooklyn, United States

ID Projek: #16021163

30 pekerja bebas membida secara purata $263 untuk pekerjaan ini

schoudhary1553

Greeting, I have understood your Excel-based securities trading simulation program - VBA/Scripting likely required task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more Lagi

$250 USD dalam 5 hari
(226 Ulasan)
7.3
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$300 USD dalam 3 hari
(189 Ulasan)
6.8
shikhamehta

Hello there, I am an expert in Excel and have worked extensively on trading strategy backtesting spreadsheets. I would be able to send screenshots from some of them if you send a chat message to me (since uploads a Lagi

$500 USD dalam 10 hari
(130 Ulasan)
6.6
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Lagi

$233 USD dalam 10 hari
(56 Ulasan)
5.6
The24CarrotsInc

A proposal has not yet been provided

$250 USD dalam 3 hari
(56 Ulasan)
5.4
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Lagi

$233 USD dalam 10 hari
(39 Ulasan)
5.7
zu02

Hello, sir I saw your Excel/csv project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB Lagi

$277 USD dalam 3 hari
(29 Ulasan)
5.7
usmanhassan123

I am mphill in computer engineering. expert in Excel models. I am able to do this.

$322 USD dalam sehari
(21 Ulasan)
4.9
aubrey03

A proposal has not yet been provided

$200 USD dalam 3 hari
(19 Ulasan)
4.8
massm90s

Hi there, I am an Excel expert, please have a look at my reviews/profile. As far as I can tell, your project is not that complicated nor difficult. If you can send me the project details (before awarding anyone), I Lagi

$150 USD dalam 3 hari
(19 Ulasan)
3.8
jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing Lagi

$277 USD dalam 5 hari
(11 Ulasan)
3.9
ashitjha7

20+ years industry work experience in the area of IT, Finance & Banking. Also, I have 4+ years of experience in Economics, Business Analytics and Advanced statistics projects using software such as Python, R, Java, SPS Lagi

$340 USD dalam 7 hari
(3 Ulasan)
3.9
vivirain

Hi there, I'm interested in the job and can help get it well done within 2 days. I have knowledge of options and also worked out a VBA to get option price for Black-Scholes and the Greeks (Delta, Gamma, Vega, The Lagi

$160 USD dalam 2 hari
(10 Ulasan)
3.7
jhony1981

I am an expert in excel and macros having more than 10 years of experience, I can finish the job within few days, Please consider me for the job, Please do not hesitate to ask for any questions if you have. Looking for Lagi

$95 USD dalam 10 hari
(10 Ulasan)
3.5
JackieXu

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.

$233 USD dalam 5 hari
(14 Ulasan)
4.0
vmadhavan15

I am not a random bidder... I hope I can do this one... Please ping me if you are interested with my proposal and thank you..

$300 USD dalam 5 hari
(7 Ulasan)
3.4
point5nyble

Hello, I have been working as freelancer since last ~ 7 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Lagi

$233 USD dalam 10 hari
(5 Ulasan)
3.2
ongskjason

I am an advanced user in Excel, creating Macro and VBA.

$325 USD dalam 2 hari
(2 Ulasan)
2.8
ednriu

A proposal has not yet been provided

$277 USD dalam 7 hari
(2 Ulasan)
2.4
ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you an accurate job, full functionality and fast delivery, all this in ex Lagi

$220 USD dalam 3 hari
(9 Ulasan)
2.8