I looked again (just now) and didn't see anything. RTD, of course, is strickly MSExcel. There are other facilities, but you'd have to see how well they fit -- and the documentation is lacking, so you have to be willing to experiment. (FWIW, I have discovered things not-yet-documented, so there's a bit of fun in there..... if that's your idea of fun....) Sorry I can be more definitive, but it's been a while since I looked. Let us know if you find out anything fun.
Yes, I understand that., It's difficult to get accurate advice when one can't provide accurate information about specifics (which I simply can't...). I have a Dell 7000 laptop with 16 GB DDR memory and 128 GB SSD hard-drive I bought just months ago. It could very well be that I have considerable potential for improvement here, but I think it's mostly the framework provided to me that's too slow.
If you know C#, python is fast to pick up. I think courses on coursera udemy youtube, etc should be decent But even faster for you is to just use an excel to call into C# code. Used to do some time ago, i cant remember the exact details but it is fairly simple to link them up. You don't even have to bother with python if you want to be productive fast and focus on strategy testing
Install R and (and perhaps also RStudio) and work through the freely-available Venables & Smith intro.
Yes, I've used both, but I needed to code a custom machine learning algo...and that was faster to do in a computer language. You can store/load data anyway you like, excel, csv, binary, database, txt, etc. --------- For example, to work with a spreadsheet file (excel, csv, etc.), you'd select a 'loader' module and put it on the workspace. You'd then open it up in order to set the parameters. One parameter could be the location of said file. Selecting that would cause a standard windows file explorer window to open. Simply select the file. What do you want to do with the file? Let's say you want to sort the data in it. So you'd grab a 'sort' module and put it in the workspace. Now, connect the loader to the sorter. (The data 'flows' through these connections, making it easier to visualize workflow). Then set the sorter parameters, telling it which column to sort and how to sort it. Then, connect the output from the sorter to 'the display.' Then run it. This is a simple example based from my memory only, mind you. But there are plenty of videos and tutorials. Here's one:
I wish... My current set-up was programmed for me by a company. Thanks, man. Those dense 100 pages look a bit more extensive than 2 hours and a day of work though. But I will take a look later. When I have time (which I don't seem to have these days...).
Wow. This looks really impressive. And could be very useful to me. After loading the data - do you know if it's stored in the program? Obviously, the answer depends on a person's background, but how complicated is this program to learn and get up to speed with? Is it easy to create charts and stuff with this? In addition to sorting my data set EOD, I'd also be interested in creating a dashboard for live data (intraday) for comparative analysis, etc.
Major limitation of LibreOffice is they limit you to 1000 columns. And Libre uses that awful macro language that is similar to the one in OpenOffice.
It can store all, or some of the data in memory...depending upon your memory capacity, data size, software settings, and software version. It's not complicated. The tutorial is built in and walks you through everything. The less you know about programming, the easier I suspect it'll be. It is easier to create charts/graphs with it than it is to do with Excel, imo. See below: https://community.rapidminer.com/t5/RapidMiner-Studio-Forum/real-time-data/td-p/6587 https://community.rapidminer.com/t5/RapidMiner-Studio-Forum/Creating-a-dashboard/td-p/31554