Hello, I have been a developer for years but am new to google apps and google docs. I am trying to build an application using google apps and I am not sure how to proceed.
I have a large dataset of volatility data and I want to be able to plot different subsets of that data in charts. For example, plot the SPX 6 month 25 delta call minus the 25 delta put vs. time. From what I have read, that shouldn't be that difficult, but right now I am feeling pretty overwhelmed. It seems to me I can store the data in the google apps datastore and then build an app to query the data based on user input, do some calculations and output the resulting data to a spreadsheet with a chart. Is that a reasonable approach? From what I have read I cannot use Google Fusion because that cannot be integrated with the datastore, and my dataset is too large to fit in a spreadsheet. I like the Google Visualization API but I don't think the query language supports the calculations I need to do. What is the best place to start here? Where do I start learning about how to build a google app that works with data, charts and spreadsheets? Right now the biggest challenge is wading through all the information. I wish I had someone to talk to about this. -Jim
