Ok I need a crash course in VBA for excel. Does anyone have any good Intro books or websites that they would recommend? I would like to start as simple as possible; however i'm a very quick learner so i am hoping that i could have a good grasp of VBA in a couple months. Thanks in advance for the advice.
I learned excel vba with "excel vba programming for dummies". As for website, you can check out the forums at exceltip.com.
Excel Programming by Jinjer Simon - you can get it at Books A Million http://www.mrexcel.com/board2/search.php http://groups.yahoo.com/group/xltraders/
You can look for the article series I did not Excel in 1999, in Futures Magazine. It's a very good primer with a Trading slant. We wrote a system backtester in Excel during this series.
Go to www.visualbasicforum.com That is where I got started. There are a couple of samples, then tons of people to ask questions when you are stuck.
The best book I have seen is "VBA Developer's Handbook" by Getz and Gilbert. I also have "Excel 2002 Power Programming with VBA" by Walkenbach, which is more current than the Getz book. There is a Excel traders discussion group at: http://groups.yahoo.com/group/xltraders/?yguid=165643948
Hi. Is there a way to use Excel's VBA to get last quotes from IB's TWS? I currently use Visual Basic 6.0 to get quotes by using the TWX Active X control in VB and then write it onto my Excel Sheets. I would rather just code in VBA inside Excel to speed things up, but can't figure out a way to get TWS Active X control into my VBA code . Is it even possible? I would rather use Active X than DDE. Thanks