Suoritettu

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.

Taidot: Tietokannan hallinto, Tietokantaohjelmointi, MySQL, R-ohjelmointikieli

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Arlington, United States

Projektin tunnus: #18955776

Myönnetty käyttäjälle:

mandalpu

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 Lisää

$600 USD 10 päivässä
(1 arvostelu)
3.8

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

pointlogic

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 Lisää

$457 USD 10 päivässä
(49 arvostelua)
6.6
tbrifki64

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

$500 USD 5 päivässä
(21 arvostelua)
4.6
citijayamala

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 Lisää

$250 USD 3 päivässä
(5 arvostelua)
4.3
usmanhassan123

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 Lisää

$250 USD 1 päivässä
(19 arvostelua)
4.4
SecureForYou

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 :) Lisää

$555 USD 3 päivässä
(1 arvostelu)
2.7
ZawnTechnologies

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 Lisää

$555 USD 17 päivässä
(0 arvostelua)
0.0
udalcorpo

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 Lisää

$666 USD 15 päivässä
(0 arvostelua)
0.0
guruarjun1

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 Lisää

$833 USD 20 päivässä
(0 arvostelua)
0.0