Money flow stats 12/1/99-10/6/00 in 1/8 range. Save data as "cncprice.csv". Use MS Excel to chart on 3 columns: %Trade, %Volume, %Days. Using "Lines on 2 Axes" chart from chart wizard. Use Price as X Label.
Price, Trades, Volume, %Trades, %Volume, Avg Size, %Days 4.5000,803,1968100,0.17%,0.20%,2450,0.93% 4.6250,2856,5718400,0.62%,0.57%,2002,1.40% 4.7500,1904,3303200,0.41%,0.33%,1734,3.27% 4.8750,4536,9494200,0.98%,0.95%,2093,5.14% 5.0000,10824,25317900,2.34%,2.54%,2339,7.94% 5.1250,6465,16735600,1.40%,1.68%,2588,7.94% 5.2500,5934,14567700,1.28%,1.46%,2454,5.61% 5.3750,6790,16185600,1.47%,1.62%,2383,4.67% 5.5000,5384,13060100,1.16%,1.31%,2425,5.61% 5.6250,4611,12054100,1.00%,1.21%,2614,8.41% 5.7500,11127,27679000,2.40%,2.77%,2487,10.75% 5.8750,15009,30546600,3.24%,3.06%,2035,12.62% 6.0000,11200,25569200,2.42%,2.56%,2282,9.81% 6.1250,9239,23701000,2.00%,2.37%,2565,7.48% 6.2500,6507,16056700,1.41%,1.61%,2467,6.54% 6.3750,6369,16224300,1.38%,1.63%,2547,6.54% 6.5000,9593,21547000,2.07%,2.16%,2246,7.01% 6.6250,6357,15395500,1.37%,1.54%,2421,5.14% 6.7500,3994,9242700,0.86%,0.93%,2314,4.21% 6.8750,2964,8353800,0.64%,0.84%,2818,4.67% 7.0000,3304,8850300,0.71%,0.89%,2678,7.01% 7.1250,4509,13406200,0.97%,1.34%,2973,6.07% 7.2500,5243,13567700,1.13%,1.36%,2587,8.88% 7.3750,7864,17505600,1.70%,1.75%,2226,9.35% 7.5000,10539,25853600,2.28%,2.59%,2453,12.15% 7.6250,8858,21811500,1.91%,2.19%,2462,11.21% 7.7500,8445,20812900,1.82%,2.09%,2464,11.21% 7.8750,11648,27286600,2.52%,2.73%,2342,11.68% 8.0000,15436,34092900,3.33%,3.42%,2208,10.28% 8.1250,9756,22034700,2.11%,2.21%,2258,9.81% 8.2500,7772,17974600,1.68%,1.80%,2312,10.28% 8.3750,7540,17854900,1.63%,1.79%,2368,11.68% 8.5000,10855,24198800,2.35%,2.42%,2229,11.21% 8.6250,10096,23472500,2.18%,2.35%,2324,12.15% 8.7500,9599,21232900,2.07%,2.13%,2211,13.55% 8.8750,11311,22799800,2.44%,2.28%,2015,11.68% 9.0000,11764,24176600,2.54%,2.42%,2055,11.68% 9.1250,5842,12106700,1.26%,1.21%,2072,10.28% 9.2500,7141,15169400,1.54%,1.52%,2124,7.94% 9.3750,6965,15495900,1.50%,1.55%,2224,8.41% 9.5000,6761,16955300,1.46%,1.70%,2507,7.48% 9.6250,4339,8684900,0.94%,0.87%,2001,6.54% 9.7500,2863,7233700,0.62%,0.72%,2526,5.14% 9.8750,2533,5970700,0.55%,0.60%,2357,5.61% 10.0000,3599,6403700,0.78%,0.64%,1779,4.21% 10.1250,758,1409200,0.16%,0.14%,1859,1.40% 10.2500,1404,2581500,0.30%,0.26%,1838,1.87% 10.3750,1169,2389200,0.25%,0.24%,2043,1.87% 10.5000,1351,2933100,0.29%,0.29%,2171,1.87% 10.6250,1270,2161700,0.27%,0.22%,1702,1.87% 10.7500,1825,2840800,0.39%,0.28%,1556,1.87% 10.8750,2997,6098000,0.65%,0.61%,2034,1.87% 11.0000,3498,8595100,0.76%,0.86%,2457,1.40% 11.1250,1870,4134000,0.40%,0.41%,2210,1.40% 11.2500,1759,3096200,0.38%,0.31%,1760,1.40% 11.3750,580,1314500,0.13%,0.13%,2266,1.40% 11.5000,513,1157600,0.11%,0.12%,2256,0.93% 11.6250,470,929000,0.10%,0.09%,1976,1.87% 11.7500,563,1321700,0.12%,0.13%,2347,2.80% 11.8750,714,1408900,0.15%,0.14%,1973,2.34% 12.0000,1059,2157800,0.23%,0.22%,2037,2.34% 12.1250,1507,2580900,0.33%,0.26%,1712,2.34% 12.2500,933,1832100,0.20%,0.18%,1963,3.27% 12.3750,1116,2178200,0.24%,0.22%,1951,2.34% 12.5000,1692,3350100,0.37%,0.34%,1979,1.87% 12.6250,1274,1849200,0.28%,0.19%,1451,1.87% 12.7500,935,1863800,0.20%,0.19%,1993,2.34% 12.8750,846,1351100,0.18%,0.14%,1597,2.34% 13.0000,1164,3222400,0.25%,0.32%,2768,2.34% 13.1250,1527,2997500,0.33%,0.30%,1962,3.27% 13.2500,1566,3041300,0.34%,0.30%,1942,3.27% 13.3750,1578,2223100,0.34%,0.22%,1408,3.27% 13.5000,1126,2780300,0.24%,0.28%,2469,3.74% 13.6250,962,1860300,0.21%,0.19%,1933,3.27% 13.7500,1538,2660600,0.33%,0.27%,1729,3.74% 13.8750,1597,2347200,0.35%,0.24%,1469,3.74% 14.0000,1421,2341600,0.31%,0.23%,1647,5.14% 14.1250,973,1763400,0.21%,0.18%,1812,3.27% 14.2500,1320,2403500,0.29%,0.24%,1820,4.67% 14.3750,3045,4594200,0.66%,0.46%,1508,5.14% 14.5000,3393,4934900,0.73%,0.49%,1454,5.14% 14.6250,2514,3385400,0.54%,0.34%,1346,6.07% 14.7500,2142,3213200,0.46%,0.32%,1500,5.61% 14.8750,2441,3906900,0.53%,0.39%,1600,5.61% 15.0000,3133,5089000,0.68%,0.51%,1624,6.54% 15.1250,2931,4328800,0.63%,0.43%,1476,6.54% 15.2500,3064,4159100,0.66%,0.42%,1357,6.54% 15.3750,1579,2799900,0.34%,0.28%,1773,5.61% 15.5000,1750,2323600,0.38%,0.23%,1327,6.54% 15.6250,1793,3305700,0.39%,0.33%,1843,6.07% 15.7500,2536,3932700,0.55%,0.39%,1550,7.48% 15.8750,3269,4544300,0.71%,0.46%,1390,7.48% 16.0000,2680,4149000,0.58%,0.42%,1548,6.54% 16.1250,1120,1902300,0.24%,0.19%,1698,5.61% 16.2500,1131,1695800,0.24%,0.17%,1499,5.14% 16.3750,1579,2367200,0.34%,0.24%,1499,4.67% 16.5000,1781,3239400,0.38%,0.32%,1818,6.07% 16.6250,1383,2648900,0.30%,0.27%,1915,5.61% 16.7500,2432,4856000,0.53%,0.49%,1996,5.61% 16.8750,3476,5789000,0.75%,0.58%,1665,7.94% 17.0000,5444,11353200,1.18%,1.14%,2085,7.01% 17.1250,4823,7136700,1.04%,0.72%,1479,8.88% 17.2500,3417,6419100,0.74%,0.64%,1878,7.94% 17.3750,2420,4893600,0.52%,0.49%,2022,7.01% 17.5000,3303,4891700,0.71%,0.49%,1480,6.54% 17.6250,2241,3405700,0.48%,0.34%,1519,5.61% 17.7500,1968,3429100,0.43%,0.34%,1742,4.67% 17.8750,1545,3440300,0.33%,0.34%,2226,4.67% 18.0000,1768,3856600,0.38%,0.39%,2181,4.21% 18.1250,691,1540200,0.15%,0.15%,2228,2.34% 18.2500,608,1637500,0.13%,0.16%,2693,1.87% 18.3750,400,497900,0.09%,0.05%,1244,1.40% 18.5000,432,913800,0.09%,0.09%,2115,1.40% 18.6250,264,397400,0.06%,0.04%,1505,0.93% 18.7500,378,570100,0.08%,0.06%,1508,1.40% 18.8750,664,914000,0.14%,0.09%,1376,0.93% 19.0000,379,639500,0.08%,0.06%,1687,0.93% 19.1250,498,779000,0.11%,0.08%,1564,1.40% 19.2500,488,690300,0.11%,0.07%,1414,1.40% 19.3750,761,1084300,0.16%,0.11%,1424,1.87% 19.5000,722,1039200,0.16%,0.10%,1439,1.87% 19.6250,184,306000,0.04%,0.03%,1663,0.93% 19.7500,251,362300,0.05%,0.04%,1443,0.93% 19.8750,223,243900,0.05%,0.02%,1093,0.93% 20.0000,476,1075100,0.10%,0.11%,2258,1.87% 20.1250,972,1678300,0.21%,0.17%,1726,2.34% 20.2500,719,1040400,0.16%,0.10%,1447,2.34% 20.3750,737,1016200,0.16%,0.10%,1378,1.87% 20.5000,1118,2087800,0.24%,0.21%,1867,2.34% 20.6250,892,1744500,0.19%,0.17%,1955,2.34% 20.7500,1311,2411900,0.28%,0.24%,1839,2.34% 20.8750,1197,2838700,0.26%,0.28%,2371,1.87% 21.0000,492,1702500,0.11%,0.17%,3460,0.93% 21.1250,1,500,0.00%,0.00%,500,0.47%
Enjoy! |