My page contains financial data from the socket.io stream. Data is a multidimensional array. I want to have google spreadsheet on my page (or any spreadsheet) whith predefined formulas in cells. In best case I want to be able to access my stream data multidimensional array directly from spreadsheet formulas.
At the end I want that user be able to edit formulas and make custom calculations for each data update.
how this can be done? Is it possible to use google spreadsheet functionality, embedding, api to acheave this? Any ideas? If not with google spreadshett than what other alternatives?