Hello,
I have some records in MySQL database. Each record has
id: Primary Key, autoincrement
Type: varchar
Price: float
Date: dateTime
Type can be a "car" or a "truck". There are many records whose Type
is "car" or whose Type is "truck".
Date has a format of "2009-07-07 20:00:00". This values changes on a
hourly basis.
Now for each Type ("car" or "truck"), I need to find how its price
changes for the last hour vs. the previous hour. For example, assume
that it is now 6:00am and the price for "car" is $16,000. Just one
hour ago (5:00am) the price for "car" was $16,500. Then the price
changes by 16,000 / 16,500 = 0.97. I need this value 0.97.
Is it possible to finish this work with Q package? Can anybody give me
a hint how to do it? I have studied Q package and related examples
however I still feel at loss.
Thanks so much.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
