Leaderboard

@Christof+, I took a quick look at your free tool - nice idea and implementation! Although TWS API is quite slow to return data history. Here are a few changes to add support for 64-bit Excel (I tried this on Excel 2019 64-bit): 1. Change GetTimeZoneInformation() return type to Long: 2. Change variable types to hold GetTickCount() value to LongPtr in TakeNap(): 3. I also had to type 127.0.0.1 to the Host field on General page. With empty host the ActiveX control did not want to connect to TWS. So I suggest setting this field to 127.0.0.1 by default. 4. Plus I disabled the annoying message that ChartAffair Key is invalid, as it appreared too often. I attached Excel sheet with my modifications - probably would be helpful to someone. Chartaffair Real-Time RV Tool.xlsm