Options Analysis in MySQL and R

The task is to create a MySQL DB to store daily data for option series, populate the database with data stores in a series of CSV format files, create stored procedures to access the DB from R. The data comprises the observed date, expiration date of the options and the option Greeks (delta, Gamma etc). The data comprises around 20M records in total.

We want to be able to retrieve option combinations (put and call) of a specified type (straddle, strange, call spread, put spread) with delta in a specified range, and maturity in a specified range (number of days from observed date to expiration). The procedure will then calculate the daily PnL of the selected option combinations over each specified period.

You must be expert in SQL database programming and R programming and have some experience and understanding of financial markets. Basic understanding of options would be an advantage.

Evner: Database Administration, Programmering af database, MySQL, Programmeringssproget R

Se mere: how to connect mysql database using r, r mysql tutorial, mysql vs r, import table from mysql to r, how to install mysql package in r, r odbc mysql, how to import mysql database in r, rmysql tutorial, mysql count business days period, cluster analysis mysql, mysql data add days, mysql select closed days reservation, javascript dynamic options php mysql, analysis mysql backend, command mysql datas fro days, mysql add business days, php mysql set time days, mysql select within days, mysql auto partitioning days, mysql select date days

Om arbejdsgiveren:
( 0 bedømmelser ) Arlington, United States

Projekt ID: #18955776

Tildelt til:


Hi, Thank you for considering my Proposal. About me, I have worked with a hedge fund for nearly 10 years and for the past 2 years, I am working independently for myself. I understand Stock Markets and have developed Flere

$600 USD in 10 dage
(1 bedømmelse)

9 freelancere byder i gennemsnit $518 på dette job


Hello, I have good working experience on MYSQL and R languages . I have read the complete job post and i would like to discuss with you further as i can do your project work very well. Please let me know your availa Flere

$457 USD in 10 dage
(49 bedømmelser)

I would like to assist you. Kindly advice me further instructions. Thank you very much. Will be waiting your message...

$500 USD in 5 dage
(21 bedømmelser)

1.I am an expert in R programming,My SQL programming(optical analysis),Statistics, regression analysis, using R, Excel and SPSS, also expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tabl Flere

$250 USD in 3 dage
(5 bedømmelser)

mphill in computer science having seven years of experience in database development and statistical analysis by using different tools like R programming, spss, weka and Excel. I already done many R programming analysi Flere

$250 USD på 1 dag
(19 bedømmelser)

Dear sir, I'm sure that I can complete your project 'Options Analysis in MySQL and R' as soon as possible. I am senior software developer and always provide fast service. I promise a high quality and punctual work :) Flere

$555 USD in 3 dage
(1 bedømmelse)

Greetings I have gone through the project description and i have great expertise with Database Administration, Database Programming, MySQL, R Programming Language. You are welcome to chat with me so that we can discuss Flere

$555 USD in 17 dage
(0 bedømmelser)

Respected Sir, Greetings of the Day ! I am Subham Das. I have 9+ years of competitive experience in web application development using .net and SQL server. I have 7+ years of experience in Database developme Flere

$666 USD in 15 dage
(0 bedømmelser)

I am a postgraduate in Statistics and Informatics from IIT Kharagpur with an overall professional experience of 6 yrs in applied Machine Learning and Deep Learning solutions to meet real-world needs, leveraging leading Flere

$833 USD in 20 dage
(0 bedømmelser)