Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co...
by murph-almighty on Friday December 01, 2017 @12:58AM
(#15822234)
>I've seen very sophisticated OMSs (Order Management Systems) built completely using excel workbooks, with 1 sheet containing orders and formula's to pull realtime pricing from bloomberg, reuters, another sheet for pre-trade analysis, another for the actual trades, and a summary sheet with pivot tables and charts to show the trade progress and summary.
Wait, people are making API calls in VBA to insert into Excel spreadsheets?
Wait, people are making API calls in VBA to insert into Excel spreadsheets?