https://support.office.com/en-us/ar...mulation-64c0ba99-752a-4fa8-bbd3-4450d8db16f1 Here's a google. It might help. I have adjusted programs, not Excel.
Thank you for your help. I am studying it now to see if I can understand what it is and if I can use it. Regards,
Margin(haircut) is much easier to figure out even with simulations. MonteCarlo will take a few days to figure out. I think I might know of one program that costs like $20 you could run. I'll have to dig it up, but it can help. Have you ever considered going professional? There are tools available to professionals that retail customers cannot access.
Mostly I agree. However you should outperform the 1)expense(commission) + 2)index change(not just breaking even account) + 3)tax rate (yearly 1040). Probably the difficulty comes from 1)and 3) is easy. In order to follow just 2) to track the index without outperforming, then simply buy SPY and hold long time.
I studied the article last night. Yes, it will do Monte-Carlo using a random number generator. The problem is they did not discuss how to make large number of runs. A typical financial simulation requires 100,000 of runs. Anyway, it gives me something to work on. Thanks again.
1 and 3 make sense. I will add those in to my simulation. But I don't think a strategy should necessarily be required to outperform an index. For example, say I have a strategy that is only in the market 15% of the trading days in a year. It's absolute returns may be lower than an indesx but it allows me 85% of the trading days to allocate my trading capital to something else. I think a better comparison would be to compare the sharpe ratios of the strategy vs index but add to the equation somehow "time in market".
Hardly a programming wizard, though I have been writing software for my day job for the past 16 years. For the past 10 months I have be writing a machine learning backtesting platform in GoLang. I hope to make it commercially available within six months. The idea for the service is it will be able to do all the heavy lifting in terms of finding profitable trading strategies but the user will have to tell it what features to test (indicators, price, events, etc). The user will then be able to generate platform specific code (EasyLanguage, NinjaScript, ThinkScript, etc) for the strategies they are interested in. fan27