michaelak117
Registered User.
- Local time
- Yesterday, 19:12
- Joined
- Mar 12, 2009
- Messages
- 37
Currently I run a daily process that involves appending data to a table and querying for data lines i need. I then use tables to lookup and add other important fields. My issue lies with the lookups I am using these other tables for. In financial trading at the end of every month that month rolls off because this particular data looks out into the future. When that month rolls off I must change my tables in order to have the appropriate lookups. (The month of march is no longer needed, so I change my table to start with April).
The problem is I then have no referece for that previous month and it is important that I compare this months data to lasts months. For example this months data provides analsis for 20 years in the future. I want to compare this months 20 years(such as year ten) to last months year ten. The problem is, when the tables are changed I dont have these years referenced for the last month(mar). In the tabes I have the months in one field such as apr-09, aug-09, feb-10, oct-10, feb-15, mar-15. The latter being the years. In the next column is a number listing which year in the future , being 1-20. That is a basic ex, just imagine month/yrs in once field and a number representing those time series in the next.
I can query the data and then turn it back into a table and build that table everyday in order to keep data specific to its month (for when the month changes).. I have considered this, but I figure there may a solution where in this table I can have it be dynamic and change for me, as to not have to maintain another database and query from it. Please contact me for any clarifications. Help is appreciated.
The problem is I then have no referece for that previous month and it is important that I compare this months data to lasts months. For example this months data provides analsis for 20 years in the future. I want to compare this months 20 years(such as year ten) to last months year ten. The problem is, when the tables are changed I dont have these years referenced for the last month(mar). In the tabes I have the months in one field such as apr-09, aug-09, feb-10, oct-10, feb-15, mar-15. The latter being the years. In the next column is a number listing which year in the future , being 1-20. That is a basic ex, just imagine month/yrs in once field and a number representing those time series in the next.
I can query the data and then turn it back into a table and build that table everyday in order to keep data specific to its month (for when the month changes).. I have considered this, but I figure there may a solution where in this table I can have it be dynamic and change for me, as to not have to maintain another database and query from it. Please contact me for any clarifications. Help is appreciated.
