Option Chain Analysis Revised

$30-250 USD

Completed

Posted

over 3 years ago

$30-250 USD

Paid on delivery

I trade option contracts and I want to be able to analyze option chains. I need a macro for Excel to start at the beginning of column A and subtract each successive row, Subtract Row 2 of column B from Row 1 of Column B then subtract result of B from the result of column A and if the result is greater than a number in B4(? User Input) write A1, A2,B1,B2, and the result on the screen. Start with Column A, Row 1 and subtract each successive row and move to Column A, Row 2 and repeat the entire process. The columns of data are downloaded from [login to view URL] and there are several cells for user input at the top of worksheet, Instrument symbol, Expiration Date, Number of lines of data, and the minimum profit number. I will always download the data so that it starts with Row 10. I am leaving space for other possible user input.

Software Architecture

Software Testing

Engineering

Project ID: 27041846

About the project

2 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@kevivu

Hi Sir, I have reviewed your requirements carefully and I can definitely start immediately. But I have couple of questions on requirements, please ping me on chat to discuss more on that. I am expert in EXCEL/ACCESS/Google Sheet/Google AppScript/PYTHON/VBA/VB/.NET/SOAP/REST/API, SQL, MS Office, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts/graphs, formatting, templates, dashboard, etc. Around 16 years of experience in software development / architecture and worked on several complex enterprise level projects, Webscrapping (Facebook/ LinkedIn / Amazon / Aliexpress / eBay), Complex VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Looking forward to work with you.. Have a nice day Thank you

$140 USD in 2 days

4.9

(20 reviews)

5.0

2 freelancers are bidding on average $120 USD for this job

@finecodervw

Hi, As I understand you will like Excel macro for option chain analysis. It would help to do a quick discussion on the requirement. With my experience on Excel macro, I am keen to work on this project. I will be happy to answer any queries that you may have. Looking forward to your response. Thanks

$100 USD in 2 days