Viewing 5 posts - 1 through 5 (of 5 total)
Thank you so much. Your code is elegant!
I can understand your logic well. But if it is time for me to design, I always flounder. My knowledge on SQL is...
February 23, 2010 at 2:07 pm
Really appreciate it.
I am trying to digest it.
February 21, 2010 at 2:22 pm
"change" is defined as: (current close - previous close)/current close.
Original data table has "date" as date format, "close" as float format.
I need to query out the "date", "close", and "change"...
February 21, 2010 at 8:24 am
Thank you so much, Paul. You are so helpful.
One more question, in your script, is the "delta" column sortable? I tried "row_number()" function to generate a column in metadata but...
February 21, 2010 at 8:21 am
Thank you, SSC Veteran.
The main part is how to calculate the change by SQL query. In original dataset, there is no change column.
February 20, 2010 at 8:27 pm
Viewing 5 posts - 1 through 5 (of 5 total)