NexusFi: Find Your Edge


Home Menu

 





Option Premium max. V1 - with excel Solver


Discussion in Options

Updated
    1. trending_up 1,597 views
    2. thumb_up 0 thanks given
    3. group 1 followers
    1. forum 7 posts
    2. attach_file 0 attachments




View Poll Results: Options - max. premium
options covered call writing CC 1 100.00%
options covered call writing CC
1 100.00%
options premium maximise on CC 1 100.00%
options premium maximise on CC
1 100.00%
options symbol selection on CC 1 100.00%
options symbol selection on CC
1 100.00%
options and excel solver 1 100.00%
options and excel solver
1 100.00%
Multiple Choice Poll. Voters: 1. You may not vote on this poll

 
Search this Thread

Option Premium max. V1 - with excel Solver

  #1 (permalink)
driller
Frankfurt Germany
 
Posts: 8 since Jan 2015
Thanks Given: 0
Thanks Received: 0

How to maximize premium for a covered call writing options OTM (trading price < strike)
only applicable for users without such tools implemented in their trading softawre

one way to do so is to use excel capabilites web scraping and solver add-in
anyone experienced in this procedure?

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Looking for an MQL4 MetaTrader programmer/coder
The Elite Circle
Ninja Trader 8 Drawing Tools Wanted
NinjaTrader
Request for MACD with option to use different MAs for fa …
NinjaTrader
NexusFi Journal Challenge - May 2024
Feedback and Announcements
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Retail Trading As An Industry
48 thanks
NexusFi site changelog and issues/problem reporting
46 thanks
Battlestations: Show us your trading desks!
34 thanks
GFIs1 1 DAX trade per day journal
32 thanks
Friendly challenge question to vendors
19 thanks

  #3 (permalink)
driller
Frankfurt Germany
 
Posts: 8 since Jan 2015
Thanks Given: 0
Thanks Received: 0


How to get to a solution:

- scrap web pages and read-in tradinge price of share, strikes, ask and bid premium at strike and save data in excel sheet for all selected instruments.
- now find trading price next lower the strike for all selected instruments & create new table on excel new sheet
- now give all columns a headline like: symbol - trade price- strike - premium - sum of premium - sum of volume $
- call/activate excel add-in Solver
- start solver and fill-in conditions

Reply With Quote
  #4 (permalink)
driller
Frankfurt Germany
 
Posts: 8 since Jan 2015
Thanks Given: 0
Thanks Received: 0

conditions for excel solver:

Task for solver:
- give me max. premium out of all selected instruments ( ALV, DBK, DAI,..or US-symbols ..etc)
- max shares per instrument limited to 50 contracts
- without overriding giving purchase volume (i.e. 500K$) example shows DAX30 Instruments ($GER30)

..since I have too less posts no link or picture is allowed...sorry..see next post

Reply With Quote
  #5 (permalink)
driller
Frankfurt Germany
 
Posts: 8 since Jan 2015
Thanks Given: 0
Thanks Received: 0

set up excel for solver add-in

select in excel main menue ->extras....etc. and select solver to be activated

(more descriptiions are found in weg......sorry no links are allowed yet


now Solver should be found on main menue list Data...and sub menues

...now following data inputs for solver conditions

Reply With Quote
  #6 (permalink)
driller
Frankfurt Germany
 
Posts: 8 since Jan 2015
Thanks Given: 0
Thanks Received: 0

example for solver conditions are:

volume: 500.000

max shares per instruments:
50 contract per share
- on eurex in germany the number of contracts traded is much lower compared with numbers of contracts per share traded in the states

sum up in main table of excel sheet the colum
premium at a given strike
and volume (trading price * number od Instrument)

on next info i would like to show the results in excel sheet displayed after solver was running as a picturam allowed to do so now

key feature are marked in picture in blue "circles"


Reply With Quote
  #7 (permalink)
driller
Frankfurt Germany
 
Posts: 8 since Jan 2015
Thanks Given: 0
Thanks Received: 0

no a cutted picture shows results - need more details - just cont.



Prm2 (yellow) line 11 belongs to strike Strk2(blue) and
P2 (yellow) is the sum up of all stk2 (yellow) * P2 (yellow) lines from 11..line 48

so I would buy -->contracts- strike - Premium - Opt expiring
500 x ALV..................5........145....1.62.........Fr. 18.3.16
1.400 * BMW..............14.......80.....2.96..........same date
2.000 * CBK...............20.......7.8....0.26.........same
5.000 * DBK...............50.....16.5....0.84.........same
and so on..

Reply With Quote
  #8 (permalink)
driller
Frankfurt Germany
 
Posts: 8 since Jan 2015
Thanks Given: 0
Thanks Received: 0

this picture shows the solver condition for the optim. run of excel solver


Reply With Quote





Last Updated on March 6, 2016


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts