Tweet
Hi, All
Fairly new at this, wondering if anyone can help me with a VBA app. Pretty simple, reading time and sales data (E-Signal Active X API) and charting some data. Problem is I am getting best results while updating the spreadsheet each second and then this data is used on a chart. Do ok with charting the data by minute( spreadsheet update with each trade but chart only plots a point every minute). But when I start charting the data by second (which works better for trading) The app freezes at getTimeSalesBar when market starts moving faster. I think it is a system resource issue. Wondering if there is a more effecient way to write the code to get it to work (I think screen updates in charting gets system intensive?) or is there a better charting software to use with VB or c++. Any help would be appreciatedl.
Thanks,
TraderF
Fairly new at this, wondering if anyone can help me with a VBA app. Pretty simple, reading time and sales data (E-Signal Active X API) and charting some data. Problem is I am getting best results while updating the spreadsheet each second and then this data is used on a chart. Do ok with charting the data by minute( spreadsheet update with each trade but chart only plots a point every minute). But when I start charting the data by second (which works better for trading) The app freezes at getTimeSalesBar when market starts moving faster. I think it is a system resource issue. Wondering if there is a more effecient way to write the code to get it to work (I think screen updates in charting gets system intensive?) or is there a better charting software to use with VB or c++. Any help would be appreciatedl.
Thanks,
TraderF
Comment