News for hackers. Stuff that matters.
Re:Show HN: Stock Trading from Google Spreadsheet by laminar_flow on Wednesday December 05, 2018 @09:36AM (#18608498)
Also worked for some large financial firms, and can confirm that there is a disconnect between Excel models created by traders and IT. One interesting development was the acquisition of ClearFactr by Goldman [1]. Seems like they hope it will centralize some of these models into one sytem, making them accessible across the firm (Excel sheets can even be imported).

GS has had a centralized risk/pricing system for over 20 years now that is pretty powerful [2]. Fun fact: GS was able to calculate their total exposure to the Lehman collapse 12 hours after it happened using this.

1. https://www.businessinsider.com/goldman-sachs-buy-financial-... 2. https://news.efinancialcareers.com/uk-en/276170/secdb-quartz...

Re:Show HN: Stock Trading from Google Spreadsheet by mruts on Wednesday December 05, 2018 @01:42PM (#18611132)
I worked at a financial services company that created portfolio analytics software. My job pretty much consisted of turning our analysts' excel models into high performance Scala code.

The company wasn't very successful, we just couldn't convince portfolio managers to pay for our software. Even the analysts at hedge funds didn't like to use our software. My theory is that a bunch of analysts need to justify their jobs with incredibly inefficient and error-prone excel workflows. Our software would have eliminated a lot of what they do in a day, and therefore, would eliminate their jobs as well.

It is terrifying that trillions of dollars of assets are run on excel, but the inertia is too strong.

Re:Show HN: Stock Trading from Google Spreadsheet by doctorpangloss on Wednesday December 05, 2018 @04:08PM (#18612567)
> My theory is that a bunch of analysts need to justify their jobs with incredibly inefficient and error-prone excel workflows.

Even if you're right, pretty much any company whose customers aren't 100%, unimpeachably good is going to fail.

Another way of thinking of it is, as soon as they became even slightly an antagonist (think Disney rivals, less Autobots), it was doomed.

As an aside, an alternative interpretation would be that Excel workflows are more intellectually stimulating, so as a side effect they come up with better models. So even if your software had a superior UX for the task at hand, the objective of making money is better served by people using their brains harder generally.

After all, a lot of people practice violin and play chess because it feels good, and then those people make a bajillion dollars on the stock market. Consider that if Excel even remotely reenacts the patterns of those activities, which is almost certainly does, it makes money in ways besides calculating numbers in a user-accessible way.

Re:Show HN: Stock Trading from Google Spreadsheet by mruts on Wednesday December 05, 2018 @04:41PM (#18612885)
I think your last paragraph is really spot on. Being an expert at excel makes you feel like a wizard, just like how emacs or vi or the bloomberg terminal makes you feel.

Our software didn’t have that feeling, it didn’t make you feel powerful in the same way that excel does (I lobbied hard for us to make a desktop app, no one likes how web apps feel. But nobody listened)

Re:Show HN: Stock Trading from Google Spreadsheet by sct202 on Wednesday December 05, 2018 @03:56PM (#18612456)
Excel also gives people the comfort that they can track what goes in and out and adjust easily.

Giving up that control is hard.

Re:Show HN: Stock Trading from Google Spreadsheet by ackbar03 on Sunday December 09, 2018 @07:00PM (#18644161)
I don't think it's the fear of losing jobs, it's more because of the flexibility it offers. There's a lot of adhoc adjustments / corrections to data / formulas that require a lot of flexibility and a coded program won't be able to manage it that well. I used to do a lot of my stuff with vba but in the end I would still use excel formulas when I could
Re:Show HN: Stock Trading from Google Spreadsheet by sticazzi on Wednesday December 05, 2018 @05:59PM (#18613616)
No, it would be terrifying that trillions of dollars are run by programmers. If the hedge fund guy says that Excel is fine, then Excel is fine.
Re:Show HN: Stock Trading from Google Spreadsheet by mruts on Thursday December 06, 2018 @06:44AM (#18617170)
Well considering their terrible returns net of fees and the massive outflows into passive, I think it's about time the industry did some soul-searching.
Re:Show HN: Stock Trading from Google Spreadsheet by umitanuki on Wednesday December 05, 2018 @11:50PM (#18615505)
Principal number one; don’t overcomplicate yourself. Keep it simple, stupid
Re:Show HN: Stock Trading from Google Spreadsheet by 3pt14159 on Wednesday December 05, 2018 @04:28PM (#18612763)
I have a humorous thought. Maybe it's that excel models require humans to run. The code and data is way messier and it's partially locked up in the heads of the people running the sheets. It's harder to copy, so it's harder to steal.

One cyber-breach and all that really nice clean code is readily understandable to your competitors.

Re:Show HN: Stock Trading from Google Spreadsheet by anoncoward111 on Wednesday December 05, 2018 @02:22PM (#18611526)
Sounds about right to me! One of the companies I consulted for had a billing department that insisted people pay their utility bills by check. They said "this is the way most of our customers like to pay".

But what they really wanted to say is "we will have to repurpose 200 staff who process these checks and mail out statements, and they're all 30 year veterans, and I don't have the heart to tell them they're fired even though they are the sole reason we lose money"

Re:Show HN: Stock Trading from Google Spreadsheet by saganus on Wednesday December 05, 2018 @09:54AM (#18608666)
The SecDB article [2], is very interesting!