Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Creating noise of the data
Versions des environnements
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement