Live data from Hacker News

Show HN: Stock Trading from Google Spreadsheet

news.ycombinator.com

81–90 of 90 posts

Re: Show HN: Stock Trading from Google Spreadsheet

#81
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.

Thanks, will have a look!

Re: Show HN: Stock Trading from Google Spreadsheet

#82
post #56
post #41

Earlier quoted context omitted.

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 :)

Keen to see this. Can you please reply to this message when you share to HN?

Re: Show HN: Stock Trading from Google Spreadsheet

#83

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.

IB is the easiest American one to get for Europeans. It's been around for a while and plenty of respectable finance people have been using it (for personal trading).

If you travel to the US most major ones should open an account for you too. But they ban foreign IPs sometimes and unlocking can be hassle.

The only major problem with the US I'm aware of is the death tax exemption for non-residents is only 60000$, so you don't wanna die or need to structure appropriately.

Re: Show HN: Stock Trading from Google Spreadsheet

#84
post #55

Earlier quoted context omitted.

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…

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.

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

#85
post #32
post #25

Earlier quoted context omitted.

I'm actually building a product right now that will live entirely on Google Sheets.

Awesome, can you tell us more? I'm building out "Idea Meritocracy" tools like those found in Principles(Dalio). The Google Forms integration is really powerful for mobile input. And event triggers are great for managing what's inputted to the form.

Reading that book now and would be interested in hearing more about what you're doing. Coding your principles in a decision tree?

Re: Show HN: Stock Trading from Google Spreadsheet

#86
post #85
post #32

Earlier quoted context omitted.

Awesome, can you tell us more? I'm building out "Idea Meritocracy" tools like those found in Principles(Dalio). The Google Forms integration is really powerful for mobile input. And event triggers are great for managing what's inputted to the form.

Reading that book now and would be interested in hearing more about what you're doing. Coding your principles in a decision tree?

Skip to the Appendix and you'll see exactly what I'm talking about.

Also, I'm managing the "5 Step Process to Get What You Want Out of Life" in the same spreadsheet.

Re: Show HN: Stock Trading from Google Spreadsheet

#87
post #4

I don't think many people realize the flexibility of Google Sheets + Scripts. When I need an ad-hoc flexible internal tool, Google sheets is usually the first place I start building.

I don't think many people realize the flexibility of Assembly language.

Re: Show HN: Stock Trading from Google Spreadsheet

#88
post #76

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…

People outside of finance really underestimate how important excel is in the finance world. It really is the lingua franca ( or the universal software ) of the industry. It is so entrenched that even google hasn't been able to move the dial. One of the major selling points of google spreadsheet is that it is free. What google didn't realize is that finance companies are wealthy enough to afford to buy or license soft…

As a long-time finance developer, I can attest to this. I think the only company that will be able to kill Excel's dominance in finance is Microsoft, and sometimes I think that they're trying. It seems the past few releases (basically 2013 on) have alienated a lot of power users by needlessly shuffling the menus/toolbars, adding lots of graphics that slow down sheets and add nothing for people who already know how to use the app, and not keeping a laser eye on memory consumption/performance issues.

Re: Show HN: Stock Trading from Google Spreadsheet

#89
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…

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

#90

Earlier quoted context omitted.

Which is a nice way of saying you're in a pool of bait for high frequency traders. ...but that's really not so bad. Having an algorithm skim 2 cents/share off of you is a lot better than paying $5+ per trade (assuming you're not trading 1000s of shares, and you're not in penny stocks or options where spreads are big).

It's not a nice way of saying that, the "pool of bait" logic is totally wrong. There's a lot of nonsense written about high frequency trading on the internet, but for example Matt Levine's explanations are completely readable, correct, and on point (see the other comment).

If someone will pay to trade with you instead of someone else, you're definitely not getting the best price.
Post reply on HN