Show HN: Stock Trading from Google Spreadsheet • Hacker News Board

Re: Show HN: Stock Trading from Google Spreadsheet

#41

Post by DailyHN » Wed, Dec 05, 2018, 4:35 PM UTC

giarc wrote: post #40

DailyHN wrote: 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.

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

Re: Show HN: Stock Trading from Google Spreadsheet

#42

Post by cfontes » Wed, Dec 05, 2018, 4:59 PM UTC

Down_n_Out wrote: post #26

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.

Re: Show HN: Stock Trading from Google Spreadsheet

#43

Post by umitanuki » Wed, Dec 05, 2018, 5:06 PM UTC

projectramo wrote: post #10

anonu wrote: 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...…

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

https://alpaca.markets/

Re: Show HN: Stock Trading from Google Spreadsheet

#44

Post by umitanuki » Wed, Dec 05, 2018, 5:12 PM UTC

foolsgold wrote: post #18

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.

Re: Show HN: Stock Trading from Google Spreadsheet

#45

Post by paulcnichols » Wed, Dec 05, 2018, 5:12 PM UTC

Cool, but first thought was a sarcastic “What could possibly wrong?”

Re: Show HN: Stock Trading from Google Spreadsheet

#46

Post by umitanuki » Wed, Dec 05, 2018, 5:16 PM UTC

thedangler wrote: post #28

I wish Alpaca worked for Canadians. There is Questtrade, but comparing the documentation, it isn't as nice to work with.

We are working hard to support non-US users!

Re: Show HN: Stock Trading from Google Spreadsheet

#47

Post by umitanuki » Wed, Dec 05, 2018, 5:17 PM UTC

hellofunk wrote: post #5

ykevinator wrote: post #3

I can't believe I've never heard of alpaca before.

Looks like the press release was only a few weeks ago. I wish they provided some way to access historical data, however. I struggle to find accessible and inexpensive histories.

You will access to the historical data. https://docs.alpaca.markets/web-api/market-data/ working to cover more

Re: Show HN: Stock Trading from Google Spreadsheet

#48

Post by umitanuki » Wed, Dec 05, 2018, 5:25 PM UTC

jcfrei wrote: post #19

conistonwater wrote: post #11

Earlier quoted context omitted.

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

Good explanation of Robinhood's business model by Matt Levine: https://www.bloomberg.com/opinion/articles/2018-10-16/carl-i...

And by Evan https://medium.com/automation-generation/commission-free-tra...

Re: Show HN: Stock Trading from Google Spreadsheet

#49

Post by hackerews » Wed, Dec 05, 2018, 5:33 PM UTC

Smart to have a SUBMIT button.

POST requests with Google Sheets is generally a bad idea since you can't explicitly control when they're sent.

Re: Show HN: Stock Trading from Google Spreadsheet

#50

Post by ravenclau648 » Wed, Dec 05, 2018, 5:35 PM UTC

umitanuki wrote: post #44

foolsgold wrote: post #18

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.

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