
The guys at Piker Trading had an innovative idea about how to evaluate the stock market and the success (or failure) of their unique trading strategy. The idea was a good one, and it was working - and they had the data to prove it! Unfortunately, the Google Sheets and scripts that they had created to manage their data was brutally slow, frequently jammed, and was not something that could ever be shown to a potential investor.
Fortunately, 43Folders' deep background in data, data visualization, and development allowed us to work together and recreate their sheets both functional and aesthetically pleasing. Using gScript (Google's particular flavor of JavaScript) and accessing the Yahoo! Stocks API to correlate historical data with buy/sell choices took us some time and more than a little iteration, but ultimately our solution met the goal of creating profit for both Piker and their clients.
Tools
- Brackets
- Google Sheets
- Yahoo! Stocks API
Skills
- Javascript
- gScript
- Database
- JSON and XML