About Algorithm Science, SignalSolver and the JeX Framework
At Algorithm Science we make Excel based products which import, analyze and present online data in Excel format. One of our specialties is the import of historical stock data into Excel and so to fill the void after Yahoo! terminated its "ichart" service in 2017, we came up with two workarounds. One involves emulating the older URLs to minimize the changes necessary to older spreadsheet. The other taps into the newer JSON based feeds, providing real-time and historical prices. Many thousands of people are now using these functions to pull stock prices.
One of my personal passions is studying trading strategies for stocks and ETFs. The SignalSolver product does just that, searching for trading strategies that worked in the past. The strategies are found by running hundreds of thousands of backtests against daily, weekly or monthly OHLC data. They are unconventional in that the buy and sell strategies are allowed to be completely different, not symmetrical inverses like your normal run-of-the-mill strategies. I doubt you'll find anything like them outside of large financial institutions. I publish some of the signals I find here in the hope that others will find them interesting, but you should know in advance that back-testing alone can not find reliably profitable strategies for the future, at least I haven't found that elusive link yet. Nevertheless the product is excellent for quantifying which price actions have been consequential. And its pretty easy to use. You can download SignalSolver from this site and do your own backtests for the free trial period.
More recently, we have become interested in the rapidly increasing number of JSON data sources online. No question about it, the world is moving away from CSV and embracing JSON. To help Excel users with the transition, we have developed a framework for extracting such data into Excel without the need for users to know any VBA. All you need to do is study the JSON data to see where the values of interest are, and enter the info onto an Excel sheet. The JeX User Defined Function will then be able to extract the values for you. We use the JeX Framework in our other recent products, JeX News and JeX Financial.
Founder and CEO