Hi, We’ve read your proposal regarding building a spreadsheet with stock prices. We build monitoring apps for traders by algorithms, formulas and other methods like Bivariate Binomial Option Pricing Method and Hilliard or Schwartz method. We suggest an app which enables to enter some symbols to a symbols sheet. Then the app prepares for each symbol an active worksheet which included: 1. formulas that read in real time the Change, Bid, Ask, sizes and the algorithms and formulas of methods in the next columns. Over the algorithms, there is a table which rates the results by the lowest and the highest (for Candles). During the day, the app accumulates the data every 5 minutes, and the algorithms work on the average. We have experience in the eTrade platform. We believe we can implement the project on any platform wich provides data in real time like qLink.
About us.
SV holds Ph.D. in Math and specializes in Mathematician, statistic, data analyst, and a computer programmer ( HTML5, CSS, Python, Matlab, R, Julia, Javascript and more)
DG is a financial professional and guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner including clear assumptions, drivers, financial statements, valuations, proper sensitivity analysis, scenarios and dashboards that are easy to understand by the client and their investors.