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


xls macro / vba programming
Updated: Views / Replies:537 / 3
Created: by adamov Attachments:0

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you dont need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • 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.

-- Big Mike, Site Administrator

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: 491 since May 2012
Thanks: 1,641 given, 1,126 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)

FuturesTrader71: TBA

Elite only

Al Brooks: TBA

Elite only

Jigsaw Trading: TBA

Oct 19

RandBots: TBA

Oct 24
     

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 06:35 PM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts
Page generated 2017-09-25 in 0.08 seconds with 26 queries on phoenix via your IP 54.81.44.140