I'm working on getting well acquainted with Python, but was wondering whether similar results could be achieved using Visual Basic (VBA) with Excel. It's a little more user friendly than Python, and I've seen people use it for data scraping before. Anyone have any advice/feedback on the positives and drawbacks between the two of them?
-
-
I am highly biased in favor of VBA/Excel and I don't know Python. That said, I have personally not come across data that I couldn't scrape using VBA. Some sites require more work than others but so far I have always found a way with VBA. As far as speed, the bottleneck I most often run into is that the web page is not responding fast enough, not that VBA is too slow.Comment -
I think Matlab's also worth a look; data scraping isn't too bad, and you can still view data as a spreadsheet.
Also, the language isn't too hard to pick up (but matlab object-oriented programming still befuddles me).Comment -
Depends what you're looking to do.
Python is far more powerful than VBA.
I wouldn't limit myself to only those two choices.Comment -
Matlab is most annoying to use. Recommend VBAComment -
I use php and have good luck with that... it's all about using what you know and learning something new if you have to.Comment -
I originally planned to start with vba and then move on to the next level, but now, after one year of messing around in vba, everything works great.
downside : vba is slower in bigger processes.Comment -
Matlab costs a shitload tooComment -
Python!Comment -
I'm not experienced with either of them, and have a fairly limited experience with Excel. I've done some preliminary work with Python and it doesn't seem difficult (as far as getting the basics down) to work with. I'd start wtih some basic data scraping and regression models (still learning more about the latter in school + on my own) but would hopefully like to get into more complicated modeling + back-testing as I go on...am I right in thinking that Python could be better for this? Or are the differences between them much more complex and specific than just "one is more powerful"?Comment -
There are very significant differences between VBA and Python.
Google is a wonderful tool.Comment -
If you are looking at web scraping then supposedly Python is much simpler, at least a friend of mine managed to write a pretty good scraper without too much difficulty.
Having said that, I have no experience with any other program, I have dabbled a little bit with Python in recent weeks and it seems alright - but at the moment am still at the stage of working out what the program can do following a book, so havent really tried to create something original using it yet...Comment
