4 ms·
How about getting rid of VBA entirely and replacing it with a visually designed workflow? EasyMorph[1] does data transformation outside Excel (so it's not a plu
by dgudkov 10y ago
How about getting rid of VBA entirely and replacing it with a visually designed workflow? EasyMorph[1] does data transformation outside Excel (so it's not a plugin or add-on), but then results can be inserted into a sheet of existing spreadsheet.
[1] http://easymorph.com http://easymorph.com (I'm the founder).
- artmageddon 10y agoPart of the issue is that the team I'm on consists of a majority of finance majors who only know VBA, and maybe just a few C++ devs (I'm pretty much the only non-finance person on the team). This is sort of those "when all you have is a hammer, everything looks like a nail" issues. Simple one-off VBA tools find a little bit of traction and then, through patchwork, evolve into something critical yet lack proper up-front and long-term-planning design. They're all smart folks of course, but I feel like so much more could be accomplished with better tooling. Your product looks really cool; I've actually been looking for something that will do ETL tasks and I've only used Informatica and SSIS, which obv aren't free. Will be checking it out!
- Chris2048 10y agoThis might be changing though. I'm following a CQF program, and while the tools are traditionally excel, VBA and C++ - Yves from Python Quants is there lecturing about using python.
- deleted 10y ago[deleted]
- Chris2048 10y agoIs EasyMorph similar to OpenRefine?
- dgudkov 10y agoYes, it's somewhat similar. EasyMorph is a hybrid tool -- you can do data preparation like with OpenRefine, but at the same time you can re-run the same transformation process for another file or with a different parameter, which makes EasyMorph similar to ETL.