Live data from Hacker News

Show HN: Stock Trading from Google Spreadsheet

news.ycombinator.com

71–80 of 90 posts

Re: Show HN: Stock Trading from Google Spreadsheet

#71

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?

yep, https://www.degiro.eu/ has ~0,5$ fee on NYSE and NASDAQ

Re: Show HN: Stock Trading from Google Spreadsheet

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

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

#73
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?

Quantopian ? https://www.quantopian.com/

Re: Show HN: Stock Trading from Google Spreadsheet

#74
post #68

These common excel spreadsheets used by investors are partly why I am writing my web application. It focuses on DGI investing and dividends in general and I have a lot o plans and room for improvements, but e.g. automatic dividend calendar must be 100 times better than keeping track of dividends in google spreadsheet manually :D

DGI == Dividend Growth Investing

Re: Show HN: Stock Trading from Google Spreadsheet

#75

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.

These guys have actually been advertising on the radio lately (in the Los Angeles area).

  https://www.robinhood.com/
They are claiming zero commissions on US based securities, but then, how are they making money ?

Re: Show HN: Stock Trading from Google Spreadsheet

#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 software. As poor high school or college students, we all used google spreadsheet, but in the industry, we all use excel.

There are so much sunk costs ( decades of excel worksheets and decades of technical know-how ) that most companies aren't going to switch to another spreadsheet and migrate all that data and retrain their employees.

Re: Show HN: Stock Trading from Google Spreadsheet

#77
I'm really curious what a simple algorithm would be? I know that penny stock traders usually operate within the first hour of trading mostly looking for stocks that are poised to gap open on some event looking to catch upward momentum, even if only 1% or 2%.

Would be awesome to see how this could be accomplished with the Alpaca API.

Re: Show HN: Stock Trading from Google Spreadsheet

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

Principal number one; don’t overcomplicate yourself. Keep it simple, stupid

Re: Show HN: Stock Trading from Google Spreadsheet

#79

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.

These guys have actually been advertising on the radio lately (in the Los Angeles area). https://www.robinhood.com/ They are claiming zero commissions on US based securities, but then, how are they making money ?

https://news.ycombinator.com/item?id=18414651

https://news.ycombinator.com/item?id=18223972

Re: Show HN: Stock Trading from Google Spreadsheet

#80

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?

Thanks, will have a look!
Post reply on HN