<- Previous Log | Select Different Log | Next Log -> |
Searching from 2021-01-27 00:00:00 to 2021-01-27 23:59:59.999999. Query completed in 0.51 seconds [2021-01-27 03:04:31] --> Armanelgtron has joined the channel [2021-01-27 03:04:31] -!- Topic for #armagetron is "http://www.armagetronad.org/ | pastebin: http://armagetron.pastebin.com/ | Tournaments: #armagetron.tourneys | Pickup a game: #armagetron.pickup" [2021-01-27 03:04:31] -!- Topic set by guru3 on 2015-04-22 20:50:50 UTC [2021-01-27 03:04:35] -!- weber.freenode.net set mode #armagetron +cnrt [2021-01-27 03:04:35] -!- Channel #armagetron created on 2006-11-26 06:42:45 UTC [2021-01-27 05:06:23] <-- Lucifer_arma has quit (Quit: Core dumped without a trace.) [2021-01-27 05:10:53] --> Lucifer_arma has joined the channel [2021-01-27 17:30:02] <-- Netsplit between *.net and *.split. Quit: ljrbot [2021-01-27 17:30:17] --> Netsplit between *.net and *.split ended. Joined: ljrbot [2021-01-27 18:34:20] <Lucifer_arma> lovely. Now I have to idiot-proof my computer because my wife is an idiot. [2021-01-27 19:06:21] <Lucifer_arma> seriously, it's 2021, you're not allowed to look at a computer screen and not know the difference between logging into a service your web browser offers and logging into a web application [2021-01-27 19:07:11] <Lucifer_arma> and when given simple instructions, such as "only use the media player web browser for netflix/hulu. If you need to check your email, use any of these other 5 web browsers that are installed", I think it's reasonable to expect those instructions to be followed [2021-01-27 19:07:24] <Lucifer_arma> anyway, in more important matters. My brain is getting locked at something. [2021-01-27 19:07:48] <Lucifer_arma> so, I have a table with historical stock prices. I have another table with technical indicators. I need to put together a simple moving average based on the historical table. [2021-01-27 19:08:28] <Lucifer_arma> the basic algorithm is done, and is what you expect. Loop through all the records in the table and compute each day's average. [2021-01-27 19:09:04] <Lucifer_arma> now, I need to update the history table with new records, and compute new moving averages for the new days [2021-01-27 19:10:02] <Lucifer_arma> so I need the moving average computation to figure out where the current stored moving averages are in the history, determine where it needs to start computing, and then work up to the present [2021-01-27 19:11:05] <Lucifer_arma> it's given only the stock to work on, the number of data points to use in the average calculation, and the most recent modified record in the history table [2021-01-27 19:11:25] <Lucifer_arma> the moving average table could be empty, it could be all caught up except for new data. It could also be in an in-between state. Historical records may also be modified for various reasons, which means already existing moving averages will have to be re-calculated and updated [2021-01-27 19:12:05] <Lucifer_arma> I'm not going to just delete all moving averages and start from scratch every time I retrieve a new stock history data set [2021-01-27 19:12:56] <Lucifer_arma> I don't know what to ask. My brain is getting locked on trying to figure out how to check the existing table and advance the loop pointers to the right places to start on the calculation [2021-01-27 19:13:52] <Lucifer_arma> it's in python, and the historical data set comes in as a dictionary keyed by date. There's a separate row ID for each record that's also in there, but the dictionary is keyed by date, sorted in ascending order [2021-01-27 19:14:22] <Lucifer_arma> presumably, but not necessarily, the averages will also be loaded in the same way: keyed by date [2021-01-27 19:15:02] <Lucifer_arma> and the function takes in the date of the oldest changed record. When nothing's changed and there's new data, this will be equal to the business day after the last record in the table [2021-01-27 19:15:46] <Lucifer_arma> now, because it's business days, I can't do any date minus data points math, like today-7 to get records, because that doesn't account for weekend dates when the stock market is closed and no new records are generated [2021-01-27 20:41:29] <ljrbot> New news from bzr: [0.2.9-armagetronad-sty+ct+ap] r1216 glancing forward and don't reset glancing when turning [2021-01-27 21:41:41] <ljrbot> New news from bzr: [0.2.9-armagetronad-sty+ct+ap] r1217 make glancing forward rotate some cameras to the cycle direc... [2021-01-27 21:48:27] <-- Z-Man has quit (Ping timeout: 272 seconds) [2021-01-27 21:53:02] --> Z-Man has joined the channelView entire month