Search results

One more question, what is the PK in table MarketAggregate? Are From, To timestamp part of the PK? Thanks a lot for your share!

If you could, can you just share the relationship between the two tables you mentioned? No the E-R diagram, just the SQL create table script or something like that to show how you link those two tables. Thanks a lot! Andrew

Thanks a lot for the sharing! I do like your idea but having difficulty in understanding how it is actually implemented in MySql. Can you share more about the E-R model for those two tables? What do you mean by "mapping to the generating class"? Thanks a lot, Andrew

Hello, I plan to store OHLCV data in Mysql database for backtesting purpose. In your opinion, besides the EOD data, if you need weekly data, do you suggest to calculate them on the fly or store those weeekly/monthly OHLCV data along with daily data in the same time series table? My intital...

Hello, I know that this thread might be little bit old but I hope I could still ask some related questions. I plan to store OHLCV data in Mysql database. In your opinion, besides the daily data, if you need weekly data, do you suggest to calculate them on the fly or store those...

Hello, I calculate the R/W ratio for the initial entry for long position like this: (entry price- stop price)/(target price - entry price). My question to you is: If you add more shares for the same stock, how do you recalculate the R/W ratio? Do you treat them as a totally different...