xls macro / vba programming - Traders Hideout | futures.io
futures io futures trading


xls macro / vba programming
Started: by adamov Views / Replies:361 / 3
Last Reply: Attachments:0

Welcome to futures io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.


You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike

Reply
 
Thread Tools Search this Thread
 

xls macro / vba programming

  #1 (permalink)
Elite Member
Budapest, Hungary
 
Futures Experience: None
Platform: ninjatrader
Favorite Futures: FGBL / FESX / ES / ZN / ZB
 
adamov's Avatar
 
Posts: 84 since Jun 2012
Thanks: 37 given, 48 received

xls macro / vba programming

hey!

I am using excel solver tool to analyze/optimize something.
The problem is I should do this in over thousand of lines, and Id like to avoid it to make manually line by line. Unfortunately I am not familiar with vba.

the task would be to minimize the value at CM3 by changing AK3 and CM4 / AK4 up to CM3637 /AK3637.

Any help is appreciated!

Reply With Quote
 
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.

 
  #3 (permalink)
Elite Member
Luxembourg, Luxembourg
 
Futures Experience: Advanced
Platform: TWS
Broker/Data: Interactive Brokers
Favorite Futures: Stocks
 
Posts: 482 since May 2012
Thanks: 1,602 given, 1,078 received



adamov View Post
hey!

I am using excel solver tool to analyze/optimize something.
The problem is I should do this in over thousand of lines, and Id like to avoid it to make manually line by line. Unfortunately I am not familiar with vba.

the task would be to minimize the value at CM3 by changing AK3 and CM4 / AK4 up to CM3637 /AK3637.

Any help is appreciated!

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.

Reply With Quote
The following 2 users say Thank You to grausch for this post:
 
  #4 (permalink)
Elite Member
Budapest, Hungary
 
Futures Experience: None
Platform: ninjatrader
Favorite Futures: FGBL / FESX / ES / ZN / ZB
 
adamov's Avatar
 
Posts: 84 since Jun 2012
Thanks: 37 given, 48 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:

Reply



futures io > > > xls macro / vba programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)
 

Spring Grains Outlook w/Sean Lusk @ Walsh Trading

Elite only

FIO Video Journal Challenge featuring NinjaTrader ($2,000+ of prizes)

April

Process above all else w/Anthony Crudele @ Futures Radio Show

Elite only

Machine Learning - Quantitative Trading w/Martin Froehler @ Quantiacs

Elite only

Market Dynamics w/Peter Davies @ Jigsaw Trading

Elite only

Ask Me Anything w/Patrick Rooney @ Trading Technologies

Apr 18

Ask Me Anything w/FuturesTrader71

Apr 19

Machine Learning w/Kris Longmore

Elite only

Market Analysis w/Dave Forss

Apr 25

Introducing iSystems with Stage 5 Trading

Apr 27
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel and learning VBA and R for Trading and Analysis CobblersAwls Trading Journals 3 August 15th, 2016 12:00 PM
Ichimoku signals in Excel VBA lpsarathi Emini Index Futures Trading 5 July 23rd, 2016 09:50 AM
Quantitative Research Question: Which platform to use instead of EXCEL with VBA? Cogito ergo sum Platforms and Indicators 3 December 5th, 2013 05:30 PM
FiboHenryZone_Calculator_Sign.xls into an Indicator for NT? tdaman NinjaTrader 2 June 10th, 2013 05:30 AM
Trade Logger 3.03 XLS Webby Traders Hideout 6 February 17th, 2012 08:13 AM


All times are GMT -4. The time now is 09:06 PM.

no new posts
Page generated 2017-03-29 in 0.09 seconds with 25 queries on phoenix via your IP 54.157.3.92