Hi, I was wondering if anyone knows of any good Excel Add-ins (for Excel 2003) that will easily create improved bar or candlestick charts in Excel using the live data I have in the spreadsheet. Or, any charting software that will maintain a live connection with an updatng Excel Spreadsheet. I have a list of stocks for which I bring in 1 and 5 minute intraday data and would like to chart the sum of these stocks and some specific sectors. THe built in excel charting of course is limited and does not look great even with some tweaking. Thanks in advance for any suggesitons. ALan
I have tried some, they all suck. The major problem is that they can't handle a much data at all. I do not recall the exact number of observations excel can chart, however I do remember it being so low that I lost interest immediately. I could be wrong, but that is what I have found in my experience, I am interested in seeing if any one has found a way around this issue.