Live data from Hacker News

Show HN: Stock Trading from Google Spreadsheet

news.ycombinator.com

31–40 of 90 posts

Re: Show HN: Stock Trading from Google Spreadsheet

#31

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.

Try degiro?

Re: Show HN: Stock Trading from Google Spreadsheet

#32
post #25
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'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.

Re: Show HN: Stock Trading from Google Spreadsheet

#33

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…

[deleted]

Re: Show HN: Stock Trading from Google Spreadsheet

#34

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…

Dear all IT fellas....finance fella here.. Please halt moaning about excel....

If u can make excel super efficient and a million times faster by working some IT magic I would personally reward you $....don't even suggest an other solution....

TAKE IT AS A CHALLENGE and improve EXCEL if you really got what it takes...

Re: Show HN: Stock Trading from Google Spreadsheet

#37
post #8

Trading driven from a spreadsheet brings back horrible memories of my earliest days on Wall Street. Excel was usually hacked in the most grotesque ways: tick data coming in, updating cells and signals and driving actual orders out the other end. Add to the fact that you're running on a desktop computer thats already struggling with a dozen other applications consuming market data, CPU cycles and driving 6 monitors...…

And people trusted real money to such a crap solution?

I remember a while ago there was an article posted here on HN that explained most ATMs are just FTPing txt files back and forth. The amount of fragile, weird systems that underpin our financial world seems deeper every day...

Re: Show HN: Stock Trading from Google Spreadsheet

#38

Earlier quoted context omitted.

Companies like that usually sell the order flow to market makers.

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

Re: Show HN: Stock Trading from Google Spreadsheet

#39

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.

Not free, but Europeans can sign up with interactive brokers UK and the pricing is very good for US markets.

>Paying 7,5 EUR to 15 EUR or more for each transaction gets old quick.

Even if there was a free service in Europe I'm not sure I'd use it due to concerns about fill & execution quality. Or to use an IT analogy...if you're not paying you are the product. In this case via order flow being sold.

Re: Show HN: Stock Trading from Google Spreadsheet

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

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 certain feature that I think is important.

Can share more when ready... aka when I've purchased the domain name so it doesn't get squatted.

Post reply on HN