NexusFi: Find Your Edge


Home Menu

 





PC-SPAN


Discussion in Options

Updated
      Top Posters
    1. looks_one Dudetooth with 218 posts (213 thanks)
    2. looks_two ron99 with 116 posts (55 thanks)
    3. looks_3 CafeGrande with 30 posts (4 thanks)
    4. looks_4 BlueRoo with 24 posts (5 thanks)
      Best Posters
    1. looks_one Dudetooth with 1 thanks per post
    2. looks_two SMCJB with 1 thanks per post
    3. looks_3 ron99 with 0.5 thanks per post
    4. looks_4 BlueRoo with 0.2 thanks per post
    1. trending_up 188,781 views
    2. thumb_up 317 thanks given
    3. group 75 followers
    1. forum 610 posts
    2. attach_file 159 attachments




 
Search this Thread

PC-SPAN

  #51 (permalink)
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785


Dudetooth View Post
I can add these symbols to the to-do list if you'd like.

I have mostly figured out how to add them myself. I added DA, CT & CC (Cocoa). I see that the added ones need to be in alphabetical order.

I see v1 is the factor to change price to dollars.

What is imm2?
What is stk1 used for?
What is d1?

But then I ran into a problem. I mistakenly tried to get a misspelled symbol to calculate. The program was stuck in a loop. I hit Esc twice and told it to end process. Now it won't work for any contract.

Edit: I went back to my saved original file and have things working again.

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Are there any eval firms that allow you to sink to your …
Traders Hideout
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
Exit Strategy
NinjaTrader
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
38 thanks
NexusFi site changelog and issues/problem reporting
25 thanks
GFIs1 1 DAX trade per day journal
19 thanks
The Program
18 thanks
  #52 (permalink)
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785

Am I correct that expiration date or DTE is not available in the disk arrays?

Started this thread Reply With Quote
  #53 (permalink)
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785


I am having problems adding SI, HO to the macro.

Got LN (Hogs) to work.

I'm guessing my stk1 is wrong or my v1 is wrong.

On the Single Position button the popup box says Select Row so I was trying to select the whole row. I changed the macro so it says "Select Cell in Option Row".

Started this thread Reply With Quote
  #54 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


kevinkdog View Post
Can you save a version in Excel 97 format? I am still way behind the times...

This one is 97/2003 compatible.

Attached Files
Elite Membership required to download: Margin without PC-SPAN-97.zip
Reply With Quote
Thanked by:
  #55 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


ron99 View Post
What is imm2?

When I found the line in the risk arrays that held the short option minimum I noticed that there were a few that didn't seem to work until I multiplied them by 2 (for currencies) and 5 (for grains) ... perhaps related to the size of the mini-contracts.


ron99 View Post
What is stk1 used for?

That is the strike of the option.


ron99 View Post
What is d1?

I found a similar issue with the delta that I found with SOM, but just with the currencies. Multiplying by 2 created the correct delta. Again, no idea why, but it works.

Reply With Quote
  #56 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


ron99 View Post
Am I correct that expiration date or DTE is not available in the disk arrays?

I'm not sure. I did a quick look, but didn't see anything. Have you ever seen the DTE displayed in any of the reports that PC-SPAN creates? If it's in a report we should be able to extract it.

****Good news ... I think I found it. There are lines in the risk array that appear to that the date that the option expires, so we should be in luck.

Reply With Quote
  #57 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


ron99 View Post
I am having problems adding SI, HO to the macro ... I'm guessing my stk1 is wrong or my v1 is wrong.

It is possible. Not sure when I'll get a chance to work the code for those. You can try stepping through the code in the VBA editor (F8 key) to see where it gets hung up. If it just that the search is not grabbing anything then it might be something like the strike.


ron99 View Post
On the Single Position button the popup box says Select Row so I was trying to select the whole row. I changed the macro so it says "Select Cell in Option Row".

I can see where that would be confusing. It is easy to understand when I am writing it ... doesn't always translate properly to others. I'll change that in the next build.

Reply With Quote
  #58 (permalink)
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785


Dudetooth View Post
I'm not sure. I did a quick look, but didn't see anything. Have you ever seen the DTE displayed in any of the reports that PC-SPAN creates? If it's in a report we should be able to extract it.

****Good news ... I think I found it. There are lines in the risk array that appear to that the date that the option expires, so we should be in luck.

I was thinking if I had the expiration date then I could then have your spreadsheet calculate monthly ROI when it does the margin.

Started this thread Reply With Quote
  #59 (permalink)
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785


Dudetooth View Post
That is the strike of the option.

For NG you have this line
stk1 = stk1 * 1000

Other ones have 10 or 100 instead of 1000. Or some don't have that line at all. What determines which multiplier you use?

Started this thread Reply With Quote
  #60 (permalink)
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785


Here's the code for silver to add to the macro for the spreadsheet in post #45.

ElseIf con1 = "SI" Then
stk1 = stk1 * 100
str1 = "CMXSO SI OOF" & cp1
str1 = str1 & "201" & yr1 & umo1 & " 201" & yr2 & omo1
strSearch = str1 & " " & Application.WorksheetFunction.Text(stk1, "0000000")
strSearch2 = "3 CX-SI"
strSearch3 = "4 CX-SI"
imm2 = 1
v1 = 0.5


Hogs

ElseIf con1 = "LN" Then
stk1 = stk1 * 10
str1 = "CMELN LN OOF" & cp1
str1 = str1 & "201" & yr1 & umo1 & " 201" & yr2 & omo1
strSearch = str1 & " " & Application.WorksheetFunction.Text(stk1, "0000000")
strSearch2 = "3 LN"
strSearch3 = "4 LN"
imm2 = 1
v1 = 0.4


Cocoa

If con1 = "CC" Then
stk1 = stk1 * 100
str1 = "NYBCC CC OOF" & cp1
str1 = str1 & "201" & yr1 & umo1 & " 201" & yr2 & omo1
strSearch = str1 & " " & Application.WorksheetFunction.Text(stk1, "0000000")
strSearch2 = "3 CC"
strSearch3 = "4 CC"
imm2 = 1
v1 = 10


Cocoa needs to be first in front of CL. I added Else in front of the If to start the CL code.

Cotton

ElseIf con1 = "CT" Then
stk1 = stk1 * 100
str1 = "NYBCT CT OOF" & cp1
str1 = str1 & "201" & yr1 & umo1 & " 201" & yr2 & omo1
strSearch = str1 & " " & Application.WorksheetFunction.Text(stk1, "0000000")
strSearch2 = "3 CT"
strSearch3 = "4 CT"
imm2 = 1
v1 = 5


Heating Oil

ElseIf con1 = "HO" Then
stk1 = stk1 * 10000
str1 = "NYMOH HO OOF" & cp1
str1 = str1 & "201" & yr1 & umo1 & " 201" & yr2 & omo1
strSearch = str1 & " " & Application.WorksheetFunction.Text(stk1, "0000000")
strSearch2 = "3 NY-HO"
strSearch3 = "4 NY-HO"
imm2 = 1
v1 = 4.2


RB

ElseIf con1 = "RB" Then
stk1 = stk1 * 10000
str1 = "NYMOB RB OOF" & cp1
str1 = str1 & "201" & yr1 & umo1 & " 201" & yr2 & omo1
strSearch = str1 & " " & Application.WorksheetFunction.Text(stk1, "0000000")
strSearch2 = "3 NY-RB"
strSearch3 = "4 NY-RB"
imm2 = 1
v1 = 4.2


These need to be added in alphabetical order.

Started this thread Reply With Quote
Thanked by:




Last Updated on September 23, 2021


© 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