I have my own VBA code in Excel, which I use to analyze stocks and options and it helps me with trades. I am not programmer, so my VBA code is not perfect and more important is, that I am not moving forward very fast. I'd like to find experienced VBA programmer, who knows what options are and can help me. I am willing to pay for services. Anyone? PM me. Or where would you look for a good VBA programmer?
Access, would be more efficent ?? I'm a VBA programmer, but not sure I want to turn a hobby into a job, can help with any small issues you have, although hate Excel programming so hmmm!!
Well, if you hate it... :-D Access might be solution, but the problem is, that i use Excel plugins (XLQ, QuoteLink) to load market data. I have IQ Feed, so I can use also DDE connection. Connecting directly to IQ feed is not as easy (that would be connecting to TCP / Socket connection) as using Excel with plugins.
I really do, takes me 20mins just to find where the code is, I use it that rarely! Access, gets you SQL's, which makes it way easier to manipulate the data, you can likely connect Access to your Excel and live update it maybe ?? Not messed, with programming for trading ever really. I'm a VB6,VB.NET and Access programmer mainly. What are you trying to do ??
If you get stuck, I can and do under extreme sufferance, code in Excel, so give me a PM, if it's only small no charge!
Try freelancer.com/freelancers/ ...do a search on something like: excel vba options ...for starters. HTH