News for hackers. Stuff that matters.

A comment on Finance Pros Say You’ll Have to Pry Excel Out of Their Cold, Dead Hands. Parent comment

Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by djtriptych on Thursday November 30, 2017 @05:07PM (#15820030)
I think pragmatic businesses that employ finance pros / quants are wise to include Excel as an essential part of their product development workflow. Excel is a great prototyping tool, and people are going to use it whether you want them to or not. These folks are motivated by money and don't give a shit about your tool if (they think) it costs them money (or time). Besides that, how many enterprise applications really offer opportunity for prototyping and running small experiments? Excel is to modeling as wireframing is to UI design.

Someone should write a book about productionizing excel models. It's not going away (and shouldn't).

[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by d--b on Thursday November 30, 2017 @05:22PM (#15820154)
> Someone should write a book

Nah, this is not gonna work... The only way out is to make something that's somewhat like a spreadsheet but with source control, a nicer language etc.

I was writing it and then the firm I was working out threatened to sue me for bullshit IP infringement...

[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by toomuchtodo on Thursday November 30, 2017 @07:26PM (#15820960)
Sounds like Excel needs a git extension!
[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by yosyp on Thursday November 30, 2017 @08:12PM (#15821180)
A quick google search shows some people are already working on that, including https://www.pathio.com
[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by uridium on Friday December 01, 2017 @02:57AM (#15822599)
Schematiq - https://www.schematiq.com also handles source control for spreadsheet and a lot more. The platform is about making sheets enterprise grade applications - regression, testing, CI etc and introduces new features to simplify spreadsheet logic.
[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by ccozan on Friday December 01, 2017 @07:04AM (#15823341)
I remember I wrote not long ago a VB Macro for Excel, where all the VB code inside was imported/exported, git pull/commit+push, etc, all of a button push.

It became an instant hit in that company and I short of a medal :).

[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by fzumstein on Friday December 01, 2017 @07:21AM (#15823394)
Note that Pathio has been relaunched as https://www.xltrail.com - it supports the standard Git workflow and every Git system (GitHub, Bitbucket, Gitlab etc.).
[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by jimmcslim on Thursday November 30, 2017 @06:14PM (#15820536)
Or seek greater adoption of standards around spreadsheets, such as FAST [1].. Flexible, Appropriate, Structured, Transparent.

[1] http://www.fast-standard.org/

[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by opportune on Thursday November 30, 2017 @06:51PM (#15820754)
Ehh I doubt most quants are interacting much with Excel except when they need to work with non-quants. There's not much of a reason to use Excel when you could use something like Pandas instead, plus the Python libraries/environment will make everything non-tabled better to deal with anyway.
[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by djtriptych on Thursday November 30, 2017 @08:51PM (#15821335)
it's different now but historically quants were not well versed in software engineering. If anything it would have been R 10-15 years ago.
[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by hardlianotion on Friday December 01, 2017 @07:13AM (#15823367)
10-15 years ago it was excel excel excel for quants in most investment banks.
[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by kgwgk on Friday December 01, 2017 @02:28AM (#15822517)
R was almost irrelevant in finance 10 years ago, Matlab was much more widely used. R may have more momentum now, but I’m not sure it has overtaken Matlab yet. And C++ was, and probably remains, king.
[ Parent | on HN ]
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co... by vostok on Friday December 01, 2017 @03:06AM (#15822610)
I think a lot of the discrepancy is explained by the fact that quant is a very widely applied title. There are quants who spend most of their day in Excel and quants who spend most of their day in C++.
[ Parent | on HN ]