General information
Category:
Coding, syntax & commands
Title:
Creating noise of the data
hi,
I have data like this
date,open,high,low,close,tottrdqty
01/03/2005,157.00,168.40,155.00,166.60,4698552.00
01/04/2005,168.00,170.00,165.00,166.00,3868083.00
01/05/2005,165.75,166.45,152.10,157.45,2716391.00
01/06/2005,158.00,158.90,144.05,145.65,3973549.00
01/07/2005,145.00,147.45,139.55,143.05,3938691.00
01/10/2005,143.25,145.95,140.25,143.45,2973811.00
01/11/2005,143.90,144.95,139.00,139.90,2012794.00
01/12/2005,140.40,141.40,132.00,135.00,2203202.00
01/13/2005,140.00,143.75,135.80,142.05,2433136.00
01/14/2005,143.00,143.50,137.05,138.65,2934634.00
01/17/2005,140.75,140.75,137.15,139.35,1054767.00
01/18/2005,140.30,140.30,133.80,134.55,2244099.00
01/19/2005,136.90,136.90,133.75,135.05,992619.00
01/20/2005,145.00,150.00,137.50,138.95,7143280.00
01/24/2005,141.00,142.40,138.75,140.90,1640574.00
01/25/2005,140.00,142.70,139.50,142.20,1511345.00
01/27/2005,144.70,147.80,142.65,143.60,3408308.00
01/28/2005,145.00,150.00,144.50,148.70,2464907.00
01/31/2005,138.20,143.80,135.15,142.05,5263511.00
02/01/2005,145.00,145.00,138.00,139.00,2322155.00
02/02/2005,140.00,142.50,139.25,139.85,3637436.00
02/03/2005,140.50,142.00,139.50,139.85,1522144.00
I would like to add a noise graph to my application.
so it would be like add the range of high and low to the noise
so the count would be the maximum for the price in the range
eg:
01/17/2005,140.75,140.75,137.15,139.35,1054767.00
01/18/2005,140.30,140.30,133.80,134.55,2244099.00
01/19/2005,136.90,136.90,133.75,135.05,992619.00
133.75 will have count 1
133.8 will have count 2
140.75 will have count 1
140.30 will have count 2
and so on
it is like a the count for the value increases if high low is in its range,
any simple way to do this ?
please let me know if i am not clear
suhashegde
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only