What it takes to develop a profitable trading system?

[userque]

I talked to someone familiar with Microsoft Office for Mac 2011. I can now get the circular iteration loop going by: press command and comma simultaneously to get into the options table, then click calculation to get the circular iteration function. Let me try a simple Monte Carlo and let you folks know how it works.

Thank you very much for your kindness.

Regards,

 

[Aquarians]

>> Thank you very much for your kindness.

Well Ironchef, you exceed by much the international math olympics I've seen in 10 years of competing with them and who could not say thank you if you sailed them a lake full of crocodiles on their way to conquering that mountain top and not only that, they'd purportedly kick you into that lake should you given them the slightest chance.

They've no doubtedly never encountered the Moscow Jews. Fuck these guys and the 1000+ years that brought them here.

 

[ironchef]

>> Thank you very much for your kindness.

Well Ironchef, you exceed by much the international math olympics I've seen in 10 years of competing with them and who could not say thank you if you sailed them a lake full of crocodiles on their way to conquering that mountain top and not only that, they'd purportedly kick you into that lake should you given them the slightest chance.

They've no doubtedly never encountered the Moscow Jews. Fuck these guys and the 1000+ years that brought them here.

????

 

[ironchef]

userque and Simples,

I tried it. It worked.

Really neat! To be able to calculate a do loop within Excel, priceless.

 

[ironchef]

What if you used an Option Calculator Program as the heart of this program and then create data inputs for the Option Calculator for:
C = call premium
S = Underlying price
K = Strike
IV= implied volatility
t = time to expiry
r = risk free rate
d = dividend rate

The F = function, e.g. for Black Scholes is already built into the Option Calculator.

Yes, that should work. I may just try it for fun.

Thanks.

 

[userque]

userque and Simples,

I tried it. It worked.

Really neat! To be able to calculate a do loop within Excel, priceless.

Really glad it works for you!!

 

[ironchef]

if we talking about trading for a living, using your own money - monumental task and your list of steps missing an extremely crucial component - finding the laws governing the market movements,

From your previous posts, I knew you found them.

 

[qxr1011]

From your previous posts, I knew you found them.

as i said earlier: this is not a thread about me

 

[userque]

@ironchef I had forgotten about the VBA EVALUATE function. It's better than worksheetfunction, for your purposes.

You can just about take the formulas you use in the sheet's cells, and copy/paste them into your VBA code. Very easy.

https://stackoverflow.com/questions/18625971/breaking-down-evaluate-in-vba

 

[ironchef]

@ironchef I had forgotten about the VBA EVALUATE function. It's better than worksheetfunction, for your purposes.

You can just about take the formulas you use in the sheet's cells, and copy/paste them into your VBA code. Very easy.

https://stackoverflow.com/questions/18625971/breaking-down-evaluate-in-vba

Thanks. I will give it a try.