Live data from Hacker News

Show HN: Stock Trading from Google Spreadsheet

news.ycombinator.com

51–60 of 90 posts

Re: Show HN: Stock Trading from Google Spreadsheet

#51
post #27

Earlier quoted context omitted.

Edit: before I read the article I wasn't sure if you meant: https://www.alpaca.ai or https://alpaca.markets

Alpaca.markets is great! What are other alternative for personal solution?

Have you looked at Interactive Brokers? They seem to support more complex order types than Alpaca, which can meaningfully impact returns of a automated trading strategy.

Re: Show HN: Stock Trading from Google Spreadsheet

#52

I worked for one of the largest financials services companies in the world and they STILL use excel to drive their trading activities. They are so large and so complex that it's impossible to convert them because no one completely understands how it all works. They were developed by traders/market experts with no help from IT, for years IT didn't even knew they existed. These spreadsheets are truly amazing, I've only…

I can see that. Traders in Wall Street are too practical to build something maintainable. Now G Sheet brings the same power but to software developers this time.

> Traders in Wall Street are too practical to build something maintainable. Now G Sheet brings the same power but to software developers this time.

When did software devs lack the power to write trading tools? The issue is that the traders had the knowledge and wrote their ideas into a spreadsheet which was not only maintainable for them but easily extensible. I cannot overstate that second part. They become spreadsheet behemoths because it's trivial to make them do that one extra thing (at least for the first fifty or so features).

Re: Show HN: Stock Trading from Google Spreadsheet

#53
post #42

Does something like this exist in Europe? Free trading would be a dream. Paying 7,5 EUR to 15 EUR or more for each transaction gets old quick. Free : Or paying a very little amount compared with what is considered the norm.

https://stocks.getbux.com/ we will be launching it next year! Disclaimer: I work at BUX.

Any plans for trading API? I presume you are from Netherlands, what exchanges you'll cover? What are limits to EU vs non-EU residents?

EDIT: formatting...

Re: Show HN: Stock Trading from Google Spreadsheet

#54

Earlier quoted context omitted.

I can see that. Traders in Wall Street are too practical to build something maintainable. Now G Sheet brings the same power but to software developers this time.

all IT peeps need to stop whining about spreadsheets use in finance world... When will y'all grow up and grow balls to make spreadsheets FASTER than it is today...we need CORE LEVEL computer scientists to look into problem of scalability of spreadsheets....

> When will y'all grow up and grow balls to make spreadsheets FASTER than it is today

Probably when the IT peeps in finance believe that the problem with spreadsheets is their speed. As the fundamental problem of spreadsheets in finance has absolutely nothing to do with their speed, this may take a while.

Re: Show HN: Stock Trading from Google Spreadsheet

#55

I worked for one of the largest financials services companies in the world and they STILL use excel to drive their trading activities. They are so large and so complex that it's impossible to convert them because no one completely understands how it all works. They were developed by traders/market experts with no help from IT, for years IT didn't even knew they existed. These spreadsheets are truly amazing, I've only…

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…

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

#56
post #41
post #40

Earlier quoted context omitted.

Should be ready for beta release very shortly. Focus is on improving communications between small businesses and their customers. I thought about building out a standalone web app, but Google Sheets was easy enough for a MVP. Spreadsheets are generally well known and familiar enough for small business owners/operators to use so it could always live as a sheet. There are a few competitors right now, but they lack a ce…

So it's a CRM? Or a single CRM feature? Does it use any proprietary or other APIs outside of the sheets scripts? Ping me when it's ready for beta testers Brian at angularjobs.com

No not a CRM. It's likely a feature in many CRMs though.

It uses an outside API and that's a big change from existing solutions. Sorry for being cryptic, but if I shared the API it would be obvious. I just want to put final touches on it before doing a Show HN. At that point it'll be obvious :)

Re: Show HN: Stock Trading from Google Spreadsheet

#57

I worked for one of the largest financials services companies in the world and they STILL use excel to drive their trading activities. They are so large and so complex that it's impossible to convert them because no one completely understands how it all works. They were developed by traders/market experts with no help from IT, for years IT didn't even knew they existed. These spreadsheets are truly amazing, I've only…

Excel just added similar functionality built in: https://support.office.com/en-us/article/get-a-stock-quote-e...

Re: Show HN: Stock Trading from Google Spreadsheet

#58
removing emotion from the actual decision to make equity purchases should be the main priority for products right now. Would be great to see more programs "building your own ETF".

- choose your investment theory - set the variables - get monthly/quarterly updates to SELL:X / BUY:Y

Re: Show HN: Stock Trading from Google Spreadsheet

#59
post #55

Earlier quoted context omitted.

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…

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 job…

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"

Post reply on HN