Money flow stats 12/1/99-11/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.16%,0.19%,2450,0.85% 4.6250,2856,5718400,0.58%,0.54%,2002,1.28% 4.7500,1904,3303200,0.39%,0.31%,1734,2.99% 4.8750,4632,9728200,0.95%,0.92%,2100,5.13% 5.0000,12443,29022200,2.54%,2.73%,2332,8.12% 5.1250,6844,17701500,1.40%,1.67%,2586,8.12% 5.2500,6145,15081800,1.25%,1.42%,2454,6.41% 5.3750,7363,17713800,1.50%,1.67%,2405,5.56% 5.5000,6110,14837300,1.25%,1.40%,2428,6.41% 5.6250,5155,13708700,1.05%,1.29%,2659,8.97% 5.7500,12240,30475200,2.50%,2.87%,2489,11.97% 5.8750,17005,34438300,3.47%,3.24%,2025,13.25% 6.0000,13310,31105900,2.72%,2.93%,2337,11.97% 6.1250,11246,28216200,2.29%,2.66%,2508,9.83% 6.2500,8537,22195700,1.74%,2.09%,2599,10.68% 6.3750,8725,20800800,1.78%,1.96%,2384,11.11% 6.5000,12157,26879600,2.48%,2.53%,2211,11.97% 6.6250,8146,19366900,1.66%,1.82%,2377,8.97% 6.7500,5747,12979500,1.17%,1.22%,2258,7.26% 6.8750,4305,11080700,0.88%,1.04%,2573,7.26% 7.0000,5485,13756600,1.12%,1.30%,2508,8.55% 7.1250,5515,16245400,1.13%,1.53%,2945,7.26% 7.2500,5687,15052800,1.16%,1.42%,2646,8.55% 7.3750,8074,18058300,1.65%,1.70%,2236,8.97% 7.5000,10672,26180400,2.18%,2.47%,2453,11.54% 7.6250,8891,21927200,1.81%,2.06%,2466,10.68% 7.7500,8445,20812900,1.72%,1.96%,2464,10.26% 7.8750,11648,27286600,2.38%,2.57%,2342,10.68% 8.0000,15436,34092900,3.15%,3.21%,2208,9.40% 8.1250,9756,22034700,1.99%,2.08%,2258,8.97% 8.2500,7772,17974600,1.59%,1.69%,2312,9.40% 8.3750,7540,17854900,1.54%,1.68%,2368,10.68% 8.5000,10855,24198800,2.21%,2.28%,2229,10.26% 8.6250,10096,23472500,2.06%,2.21%,2324,11.11% 8.7500,9599,21232900,1.96%,2.00%,2211,12.39% 8.8750,11311,22799800,2.31%,2.15%,2015,10.68% 9.0000,11764,24176600,2.40%,2.28%,2055,10.68% 9.1250,5842,12106700,1.19%,1.14%,2072,9.40% 9.2500,7141,15169400,1.46%,1.43%,2124,7.26% 9.3750,6965,15495900,1.42%,1.46%,2224,7.69% 9.5000,6761,16955300,1.38%,1.60%,2507,6.84% 9.6250,4339,8684900,0.89%,0.82%,2001,5.98% 9.7500,2863,7233700,0.58%,0.68%,2526,4.70% 9.8750,2533,5970700,0.52%,0.56%,2357,5.13% 10.0000,3599,6403700,0.73%,0.60%,1779,3.85% 10.1250,758,1409200,0.15%,0.13%,1859,1.28% 10.2500,1404,2581500,0.29%,0.24%,1838,1.71% 10.3750,1169,2389200,0.24%,0.22%,2043,1.71% 10.5000,1351,2933100,0.28%,0.28%,2171,1.71% 10.6250,1270,2161700,0.26%,0.20%,1702,1.71% 10.7500,1825,2840800,0.37%,0.27%,1556,1.71% 10.8750,2997,6098000,0.61%,0.57%,2034,1.71% 11.0000,3498,8595100,0.71%,0.81%,2457,1.28% 11.1250,1870,4134000,0.38%,0.39%,2210,1.28% 11.2500,1759,3096200,0.36%,0.29%,1760,1.28% 11.3750,580,1314500,0.12%,0.12%,2266,1.28% 11.5000,513,1157600,0.10%,0.11%,2256,0.85% 11.6250,470,929000,0.10%,0.09%,1976,1.71% 11.7500,563,1321700,0.11%,0.12%,2347,2.56% 11.8750,714,1408900,0.15%,0.13%,1973,2.14% 12.0000,1059,2157800,0.22%,0.20%,2037,2.14% 12.1250,1507,2580900,0.31%,0.24%,1712,2.14% 12.2500,933,1832100,0.19%,0.17%,1963,2.99% 12.3750,1116,2178200,0.23%,0.21%,1951,2.14% 12.5000,1692,3350100,0.35%,0.32%,1979,1.71% 12.6250,1274,1849200,0.26%,0.17%,1451,1.71% 12.7500,935,1863800,0.19%,0.18%,1993,2.14% 12.8750,846,1351100,0.17%,0.13%,1597,2.14% 13.0000,1164,3222400,0.24%,0.30%,2768,2.14% 13.1250,1527,2997500,0.31%,0.28%,1962,2.99% 13.2500,1566,3041300,0.32%,0.29%,1942,2.99% 13.3750,1578,2223100,0.32%,0.21%,1408,2.99% 13.5000,1126,2780300,0.23%,0.26%,2469,3.42% 13.6250,962,1860300,0.20%,0.18%,1933,2.99% 13.7500,1538,2660600,0.31%,0.25%,1729,3.42% 13.8750,1597,2347200,0.33%,0.22%,1469,3.42% 14.0000,1421,2341600,0.29%,0.22%,1647,4.70% 14.1250,973,1763400,0.20%,0.17%,1812,2.99% 14.2500,1320,2403500,0.27%,0.23%,1820,4.70% 14.3750,3045,4594200,0.62%,0.43%,1508,5.13% 14.5000,3393,4934900,0.69%,0.46%,1454,5.13% 14.6250,2514,3385400,0.51%,0.32%,1346,5.98% 14.7500,2142,3213200,0.44%,0.30%,1500,5.56% 14.8750,2441,3906900,0.50%,0.37%,1600,5.56% 15.0000,3133,5089000,0.64%,0.48%,1624,5.98% 15.1250,2931,4328800,0.60%,0.41%,1476,5.98% 15.2500,3064,4159100,0.63%,0.39%,1357,5.98% 15.3750,1579,2799900,0.32%,0.26%,1773,5.13% 15.5000,1750,2323600,0.36%,0.22%,1327,5.98% 15.6250,1793,3305700,0.37%,0.31%,1843,5.56% 15.7500,2536,3932700,0.52%,0.37%,1550,6.84% 15.8750,3269,4544300,0.67%,0.43%,1390,6.84% 16.0000,2680,4149000,0.55%,0.39%,1548,5.98% 16.1250,1120,1902300,0.23%,0.18%,1698,5.13% 16.2500,1131,1695800,0.23%,0.16%,1499,4.70% 16.3750,1579,2367200,0.32%,0.22%,1499,4.27% 16.5000,1781,3239400,0.36%,0.30%,1818,5.56% 16.6250,1383,2648900,0.28%,0.25%,1915,5.13% 16.7500,2432,4856000,0.50%,0.46%,1996,5.13% 16.8750,3476,5789000,0.71%,0.55%,1665,7.26% 17.0000,5444,11353200,1.11%,1.07%,2085,6.41% 17.1250,4823,7136700,0.98%,0.67%,1479,8.12% 17.2500,3417,6419100,0.70%,0.60%,1878,7.26% 17.3750,2420,4893600,0.49%,0.46%,2022,6.41% 17.5000,3303,4891700,0.67%,0.46%,1480,5.98% 17.6250,2241,3405700,0.46%,0.32%,1519,5.13% 17.7500,1968,3429100,0.40%,0.32%,1742,4.27% 17.8750,1545,3440300,0.32%,0.32%,2226,4.27% 18.0000,1768,3856600,0.36%,0.36%,2181,3.85% 18.1250,691,1540200,0.14%,0.14%,2228,2.14% 18.2500,608,1637500,0.12%,0.15%,2693,1.71% 18.3750,400,497900,0.08%,0.05%,1244,1.28% 18.5000,432,913800,0.09%,0.09%,2115,1.28% 18.6250,264,397400,0.05%,0.04%,1505,0.85% 18.7500,378,570100,0.08%,0.05%,1508,1.28% 18.8750,664,914000,0.14%,0.09%,1376,0.85% 19.0000,379,639500,0.08%,0.06%,1687,0.85% 19.1250,498,779000,0.10%,0.07%,1564,1.28% 19.2500,488,690300,0.10%,0.06%,1414,1.28% 19.3750,761,1084300,0.16%,0.10%,1424,1.71% 19.5000,722,1039200,0.15%,0.10%,1439,1.71% 19.6250,184,306000,0.04%,0.03%,1663,0.85% 19.7500,251,362300,0.05%,0.03%,1443,0.85% 19.8750,223,243900,0.05%,0.02%,1093,0.85% 20.0000,476,1075100,0.10%,0.10%,2258,1.71% 20.1250,972,1678300,0.20%,0.16%,1726,2.14% 20.2500,719,1040400,0.15%,0.10%,1447,2.14% 20.3750,737,1016200,0.15%,0.10%,1378,1.71% 20.5000,1118,2087800,0.23%,0.20%,1867,2.14% 20.6250,892,1744500,0.18%,0.16%,1955,2.14% 20.7500,1311,2411900,0.27%,0.23%,1839,2.14% 20.8750,1197,2838700,0.24%,0.27%,2371,1.71% 21.0000,492,1702500,0.10%,0.16%,3460,0.85% 21.1250,1,500,0.00%,0.00%,500,0.43% |