Excel RTD ʹò

1 tradexڣ > ѡ > Excel RTDExcel RTDWindowsǽʾǷtradex򿪶˿ڣѡǡ

2 Excelڼ ExcelPriceRTD.xll

Excel ļ>ѡ>>ת...> > tradexװĿ¼RTDĿ¼£ҵ "ExcelPriceRTD.xll""ExcelPriceRTD64.xll", еһȷ

ע⣺
 1) ڴ󲿷ֵexcel32λģʹExcelPriceRTD.xll 64λexcelʹExcelPriceRTD64.xll
    鿴excel汾Ϣļ>˻>excel, ĶԻһʾ 32λ64λġ
 2) ExcelPriceRTD.xll ֻExcelһΣԺExcelظ˲衣
 


3 tradex£Excelκcell¸ʽĹʽȡtradexʵʱۣ

  =tradex("","Լ","Լ","") 

 1вעִСд
 2빫ʽسcellԶˢ£籣Excel´δʱӦcellsҲԶ£Ҫ빫ʽ
 3빫ʽ磺

  =tradex("LME","CA","3M","last") 

  =tradex("SGXOTC","FE","201512","bid")

  עΪÿʹӢ"" 

ֵ֧£
bid, bidvol,       
offer, offervol, 
last, lastvol, 
stl
total

4 ѡ裩ExcelĬϵˢƵ 2һΣҪΪʵʱıۣͨ²ˢƵʣ

  Excel ALT+F11> ڡʱԺΪλ
  
  1ˢ¼1룺Application.RTD.ThrottleInterval=1000Ȼس

  2鿴ǰЧˢ¼?Application.RTD.ThrottleIntervalȻس

  òֻҪִһΣExcelԶûá





  