anyone have one in excel?

Thank you for everyone's replies as I have a lot learn. The question which I cannot seem to get over is where the price value per point is included. For example if the mini-sp futures = $50/point and the Dow = $10/point, where does this come in to the equation.Thanks Thanks Thanks,Leonard

There is a strong feeling I will!Thanks again.

Johnny,Yes, that did clarify my question quite a bit. And whoa! that will take me quite some time to work on. Wait...wait...yes a slight pain in my head already.Here we go!Thanks,Leonard

SG,Two things...What is the eps in your equation?Also, this is for spreading index futures which is the reason I brought the pricing angle into it. (The two underlying have different point values)Thanks.Leonard

<t>Trust me I'm not 100% sure what I'm doing either. Though I do know what end result I'm looking for.I'm working my way off the CBOT floor, which has been my life, to something entirely new and foreign: electronic markets. This has been a real mental struggle for me so I realize this could be quite...

<t>Hello,If I were to construct a spread of two fairly correlated products, say buy A and sell B and I need to know the # of contracts to trade for product B with A being 1 could I take the R-Squared of the two and then...Take (1/R-squared) - (price value of product B/price value of product A)to get...

Solved....Thanks