FAQs

http://investsolver.com contains free Excel Spreadsheets, Matlab, and R programs. These software programs covers many scientific 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, 2013, 2016, and Office-365 versions. They may not be compatible against mac and 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, 2013, 2016, and Office-365.

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 Bloomberg or Google Finance Web Services. Note that Yahoo! Stock API discontinued their web service in 2017.

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 Bloomberg Markets are free for stock quotes. The REST based API version lets you specify multiple symbols with a maximum of 20 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 10 symbols per call.