xls macro / vba programming | Traders Hideout

futures.io - futures trading strategies, market news, trading charts and platforms

Traders Hideout

Discuss day trading practices and futures trading strategies on this forum for all markets. This forum is also for discussing and reviews for brokers, data feeds, and commercial or third party add-ons


xls macro / vba programming

  #4 (permalink)

Budapest, Hungary
Trading Experience: None
Platform: ninjatrader
Favorite Futures: FGBL / FESX / ES / ZN / ZB
adamov's Avatar
Posts: 84 since Jun 2012
Thanks: 37 given, 49 received

grausch View Post
When you say that you are using the solver tool do you mean you are using the Goal Seek function or are you using something else?

When wanting to use VBA in excel the best way would be to see if the specific function in Excel can be recorded using the "Record a Macro" function at your disposal. This will give you an indication of whether it can be done.

If it can not be done using the "Record A Macro" function, then you could write a macro that changes cells AK3 and CM4 / AK4 in the way you desire and just keep track of the numbers that provide the minimum value for CM3. This should not be too difficult to do, but depending on the amount of data it can take a little while.

If you are not familiar with the VBA in excel basics, try finding a couple of online videos or lessons to explain them. If you have some programming experience and using the recorder, you should be up and running in less than a day.

Thank you for your replay.
It seems I managed to find a mathematical way to solve my equation.
Using solver wouldn't have been resource efficient and elegant anyway.

Have a nice day!

Reply With Quote
The following user says Thank You to adamov for this post: