building a list of options name by month/type/year/price
$10-30 USD
Terminado
Publicado hace más de 10 años
$10-30 USD
Pagado a la entrega
1. get historical "SPY" prices from [login to view URL] starting 01/2005 till today
2. for every day, calculate all options strikes in 10% range of SPY price and round it to XX.00 or XX.5 (you can read more here [login to view URL])
3. find expiration dates from 2005 till today. expiration date is the 3rd Friday of the month +1.
4. build in xls the name for each options + strike + expiration date + type (call or put) as shown here [login to view URL]
for example:
1. the price of SPY now is 183.64
2. 10% of 183.64 = 18.364 than strikes will start at (183.64-18.364=)165.276 = 165 and will end at (183.64+18.364=)202.004 = 202 and the full strike is 165,166,167,168,169,170,171,172,173,....183....202
3. find the 3rd firday for each month since 2005 so this month 3rd friday will be 1/17/2014 and +1 = 1/18/2014 and translate the month to the code in the above link
4. SPY1418A184 = SPY +14 + 18 + C + 184 = symbol (same for all) + 14 (year) + 18 (expiration date) + month + strike
need to have only 1 time each name. you will need to clean double entries.
output should be xls file
hello
respected sir i m interested
i m ready to start work right now
i can do ur project fast, i m expert in excel, word, data entry. copy paste.
i m waiting for ur reply
thanks
Dear Sir/Madam,
I am a precise & highly qualified Data Entry Specialist with more than 8 years experienced & am capable to execute all kind of works that related to MS Office applications (Excel, Word, and Power Point etc), Internet Research and Document related works. I have worked as a Document Controller and Quality Assurance Engineer in the same company & I created all Quality Procedures/Working Instructions/All company Templates/ Formats. I am psyched if you could give me an opportunity to work with you & your consideration would be appreciated. I look forward to hearing from you soon.
Thanks/Regards
Danu
Hello,
You explained the procedures so clearly.
There will be no problem to do this task.
I am an internet savvy freelancer and I have good knowledge in Mathematics.
I know that you don't need a mathematician here but to do this task, I think someone should have a good knowledge of mathematics.
I have a great MS office skill too.
Thanks
Hello,
I'm Ali Hossain. I'm expert for data entry. I have done lots of similar work.
I have checked your work description carefully and clearly and able to complete it within your satisfaction. Though I have no feedback here on but I have lots of feedback on different marketplace.
Hence I am assuring you for 100% accurate work with your expected time.
I hope you would be able to award me the job.
Best regards
Ali
Hello, I am the expert you need for this job!
I am new to this site but I have been working professionally for the last three years. This has taught me to not only create and submit high quality work but also be fast and meet deadlines.
Looking forward to working with you.
Greeting Sir,
Sir i read your requirements, i m sure i can do this work easily, Please provide me more details of your project so more easy to understand and can start work ASAP.
We can over skype seodotcom or gmail gj1285.
Thanks and regards
Shaun
Hi Sir/Madam
I looked at your project details and I understand your project needs and I have a good experience for doing the data entry jobs. So, if our bid is good for your project needs then you can hire me.
Thanking You
Yours Sincerely
Jack Dounal