You will be trying to generate a signal to buy or sell, based on what has happened in a time-span.
Starting at some point in the past and ending when the calculation takes place.
I think you need to create an algorithm, it is mostly looping over some time-span and some IF statements.
SQL is neither needed nor efficient. Store the data in binary-files on SSD.
edit: do you have data to work with?
The populace of Iceland will select new representatives in parliament in a week's time.
The MP in question may have destroyed his small, left-wing political party.
Icelandic Gov did not pay anybody! They just said ISK deposits in Icelandic banks are safe. At the same time currency conversion restrictions were imposed.
Go figure..
ISK lost 50% of its value, can't call that whole. Icelanders with deposits in the UK & NL branches lost, just like the natives. UK and NL citizens with deposits in Icelandic banks were treated just like Icelanders. Iceland can't print EUR or GBP.
Agreed, I have a good experience with binary files on SSD, I use them like arrays.
seek(a*x + b*y + 0)
b1=read.decimal
seek(a*x + b*y + 1)
b2 = read.decimal
and hey, there is my bar
This has been your hobby for years, your basement is full of severs, right?
Just decide how much your project is worth, and pull the plug when you have lost that amount of cash.