http://Investsolver.com contains free Excel Spreadsheets, Matlab, and R programs. These software programs covers many engineering methods applied towards business, investment, operations research, supply chain and technical trading. They can benefit anyone with some working knowledge of engineering math, excel, and programming in a modern language.
Not finding what you want? Reach out directly through the Contact Us page.
Q: The macro embedded in the spreadsheet does not work.
A: VBA macros in the spreadsheet have been tested against Microsoft Excel-2010 and 2013 versions. They may not be compatible against older versions.
Q: Are the macros Open Office Compatible.
A: No. They have not been tested against open office and there is no guarantee it will work. Most of my customers run these spreadsheets on Office-2010 and 2013.
Q: The Matlab code in Mac-OS X Yosemite crashes.
A: This is known issue for Matlab 2013a running on OS X Yosemite.
Q: What are the source(s) of these stock quotes?
A: Most of the stock quotes and major indices data are fetched from Yahoo or Google Finance Web Services.
Q: What financial information can I download from Finance API?
A: The most common are Pricing, Date, Averages, Dividends, Averages, Week Pricing, Volume, Ratios, and Miscellaneous information.
Q: Are the underlying Finance API in your spreadsheets free?
A: The Web service from Google and Yahoo are free for stock quotes. The REST based API version lets you specify multiple symbols with a maximum of 200 per call. You can make multiple calls, but if you call too fast it will lock your IP. Most of my programs limits you to to 20 symbols per call.