Money flow stats 12/1/99-10/2/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.18%,0.20%,2450,0.95% 4.6250,2856,5718400,0.63%,0.58%,2002,1.42% 4.7500,1904,3303200,0.42%,0.34%,1734,3.32% 4.8750,4536,9494200,0.99%,0.97%,2093,5.21% 5.0000,10824,25317900,2.37%,2.58%,2339,8.06% 5.1250,6465,16735600,1.42%,1.70%,2588,8.06% 5.2500,5934,14567700,1.30%,1.48%,2454,5.69% 5.3750,6790,16185600,1.49%,1.65%,2383,4.74% 5.5000,5384,13060100,1.18%,1.33%,2425,5.69% 5.6250,4611,12054100,1.01%,1.23%,2614,8.53% 5.7500,11127,27679000,2.44%,2.82%,2487,10.90% 5.8750,15009,30546600,3.29%,3.11%,2035,12.80% 6.0000,11200,25569200,2.45%,2.60%,2282,9.95% 6.1250,9239,23701000,2.02%,2.41%,2565,7.58% 6.2500,5960,14821300,1.31%,1.51%,2486,6.16% 6.3750,5155,13061400,1.13%,1.33%,2533,5.69% 6.5000,7400,16460800,1.62%,1.68%,2224,6.16% 6.6250,5927,13913600,1.30%,1.42%,2347,4.74% 6.7500,3827,8768200,0.84%,0.89%,2291,3.32% 6.8750,2738,7786200,0.60%,0.79%,2843,3.79% 7.0000,2896,7454400,0.63%,0.76%,2574,6.16% 7.1250,4252,12659800,0.93%,1.29%,2977,5.69% 7.2500,5108,13298200,1.12%,1.35%,2603,8.53% 7.3750,7781,17344000,1.70%,1.77%,2229,9.00% 7.5000,10232,25346600,2.24%,2.58%,2477,11.37% 7.6250,8623,20632800,1.89%,2.10%,2392,10.43% 7.7500,8350,20594200,1.83%,2.10%,2466,10.43% 7.8750,11648,27286600,2.55%,2.78%,2342,11.85% 8.0000,15436,34092900,3.38%,3.47%,2208,10.43% 8.1250,9756,22034700,2.14%,2.24%,2258,9.95% 8.2500,7772,17974600,1.70%,1.83%,2312,10.43% 8.3750,7540,17854900,1.65%,1.82%,2368,11.85% 8.5000,10855,24198800,2.38%,2.47%,2229,11.37% 8.6250,10096,23472500,2.21%,2.39%,2324,12.32% 8.7500,9599,21232900,2.10%,2.16%,2211,13.74% 8.8750,11311,22799800,2.48%,2.32%,2015,11.85% 9.0000,11764,24176600,2.58%,2.46%,2055,11.85% 9.1250,5842,12106700,1.28%,1.23%,2072,10.43% 9.2500,7141,15169400,1.56%,1.55%,2124,8.06% 9.3750,6965,15495900,1.53%,1.58%,2224,8.53% 9.5000,6761,16955300,1.48%,1.73%,2507,7.58% 9.6250,4339,8684900,0.95%,0.88%,2001,6.64% 9.7500,2863,7233700,0.63%,0.74%,2526,5.21% 9.8750,2533,5970700,0.55%,0.61%,2357,5.69% 10.0000,3599,6403700,0.79%,0.65%,1779,4.27% 10.1250,758,1409200,0.17%,0.14%,1859,1.42% 10.2500,1404,2581500,0.31%,0.26%,1838,1.90% 10.3750,1169,2389200,0.26%,0.24%,2043,1.90% 10.5000,1351,2933100,0.30%,0.30%,2171,1.90% 10.6250,1270,2161700,0.28%,0.22%,1702,1.90% 10.7500,1825,2840800,0.40%,0.29%,1556,1.90% 10.8750,2997,6098000,0.66%,0.62%,2034,1.90% 11.0000,3498,8595100,0.77%,0.88%,2457,1.42% 11.1250,1870,4134000,0.41%,0.42%,2210,1.42% 11.2500,1759,3096200,0.39%,0.32%,1760,1.42% 11.3750,580,1314500,0.13%,0.13%,2266,1.42% 11.5000,513,1157600,0.11%,0.12%,2256,0.95% 11.6250,470,929000,0.10%,0.09%,1976,1.90% 11.7500,563,1321700,0.12%,0.13%,2347,2.84% 11.8750,714,1408900,0.16%,0.14%,1973,2.37% 12.0000,1059,2157800,0.23%,0.22%,2037,2.37% 12.1250,1507,2580900,0.33%,0.26%,1712,2.37% 12.2500,933,1832100,0.20%,0.19%,1963,3.32% 12.3750,1116,2178200,0.24%,0.22%,1951,2.37% 12.5000,1692,3350100,0.37%,0.34%,1979,1.90% 12.6250,1274,1849200,0.28%,0.19%,1451,1.90% 12.7500,935,1863800,0.20%,0.19%,1993,2.37% 12.8750,846,1351100,0.19%,0.14%,1597,2.37% 13.0000,1164,3222400,0.25%,0.33%,2768,2.37% 13.1250,1527,2997500,0.33%,0.31%,1962,3.32% 13.2500,1566,3041300,0.34%,0.31%,1942,3.32% 13.3750,1578,2223100,0.35%,0.23%,1408,3.32% 13.5000,1126,2780300,0.25%,0.28%,2469,3.79% 13.6250,962,1860300,0.21%,0.19%,1933,3.32% 13.7500,1538,2660600,0.34%,0.27%,1729,3.79% 13.8750,1597,2347200,0.35%,0.24%,1469,3.79% 14.0000,1421,2341600,0.31%,0.24%,1647,5.21% 14.1250,973,1763400,0.21%,0.18%,1812,3.32% 14.2500,1320,2403500,0.29%,0.24%,1820,5.21% 14.3750,3045,4594200,0.67%,0.47%,1508,5.69% 14.5000,3393,4934900,0.74%,0.50%,1454,5.69% 14.6250,2514,3385400,0.55%,0.34%,1346,6.64% 14.7500,2142,3213200,0.47%,0.33%,1500,6.16% 14.8750,2441,3906900,0.53%,0.40%,1600,6.16% 15.0000,3133,5089000,0.69%,0.52%,1624,6.64% 15.1250,2931,4328800,0.64%,0.44%,1476,6.64% 15.2500,3064,4159100,0.67%,0.42%,1357,6.64% 15.3750,1579,2799900,0.35%,0.29%,1773,5.69% 15.5000,1750,2323600,0.38%,0.24%,1327,6.64% 15.6250,1793,3305700,0.39%,0.34%,1843,6.16% 15.7500,2536,3932700,0.56%,0.40%,1550,7.58% 15.8750,3269,4544300,0.72%,0.46%,1390,7.58% 16.0000,2680,4149000,0.59%,0.42%,1548,6.64% 16.1250,1120,1902300,0.25%,0.19%,1698,5.69% 16.2500,1131,1695800,0.25%,0.17%,1499,5.21% 16.3750,1579,2367200,0.35%,0.24%,1499,4.74% 16.5000,1781,3239400,0.39%,0.33%,1818,6.16% 16.6250,1383,2648900,0.30%,0.27%,1915,5.69% 16.7500,2432,4856000,0.53%,0.49%,1996,5.69% 16.8750,3476,5789000,0.76%,0.59%,1665,8.06% 17.0000,5444,11353200,1.19%,1.16%,2085,7.11% 17.1250,4823,7136700,1.06%,0.73%,1479,9.00% 17.2500,3417,6419100,0.75%,0.65%,1878,8.06% 17.3750,2420,4893600,0.53%,0.50%,2022,7.11% 17.5000,3303,4891700,0.72%,0.50%,1480,6.64% 17.6250,2241,3405700,0.49%,0.35%,1519,5.69% 17.7500,1968,3429100,0.43%,0.35%,1742,4.74% 17.8750,1545,3440300,0.34%,0.35%,2226,4.74% 18.0000,1768,3856600,0.39%,0.39%,2181,4.27% 18.1250,691,1540200,0.15%,0.16%,2228,2.37% 18.2500,608,1637500,0.13%,0.17%,2693,1.90% 18.3750,400,497900,0.09%,0.05%,1244,1.42% 18.5000,432,913800,0.09%,0.09%,2115,1.42% 18.6250,264,397400,0.06%,0.04%,1505,0.95% 18.7500,378,570100,0.08%,0.06%,1508,1.42% 18.8750,664,914000,0.15%,0.09%,1376,0.95% 19.0000,379,639500,0.08%,0.07%,1687,0.95% 19.1250,498,779000,0.11%,0.08%,1564,1.42% 19.2500,488,690300,0.11%,0.07%,1414,1.42% 19.3750,761,1084300,0.17%,0.11%,1424,1.90% 19.5000,722,1039200,0.16%,0.11%,1439,1.90% 19.6250,184,306000,0.04%,0.03%,1663,0.95% 19.7500,251,362300,0.05%,0.04%,1443,0.95% 19.8750,223,243900,0.05%,0.02%,1093,0.95% 20.0000,476,1075100,0.10%,0.11%,2258,1.90% 20.1250,972,1678300,0.21%,0.17%,1726,2.37% 20.2500,719,1040400,0.16%,0.11%,1447,2.37% 20.3750,737,1016200,0.16%,0.10%,1378,1.90% 20.5000,1118,2087800,0.24%,0.21%,1867,2.37% 20.6250,892,1744500,0.20%,0.18%,1955,2.37% 20.7500,1311,2411900,0.29%,0.25%,1839,2.37% 20.8750,1197,2838700,0.26%,0.29%,2371,1.90% 21.0000,492,1702500,0.11%,0.17%,3460,0.95% 21.1250,1,500,0.00%,0.00%,500,0.47% |