Real time PNL in excel with Trader Workstation

Discussion in 'Trading Software' started by TradingNerd, Jul 19, 2012.

  1. and you manage over $1b?
    is there a way to get the xlsm password free?
     
    #11     Jul 19, 2012
  2. getting errors in hidden modules..
     
    #12     Jul 19, 2012
  3. mickson

    mickson

    that is because you havent downloaded the IB API, I dont think this is appropriate to discuss on this forum, work through RAPA support channels.
     
    #13     Jul 19, 2012
  4. Open .xlsm file in hex editor
    Look for DPB= near end of file
    Change DPB to DPx
    Save file
    Open file, click OK to any pop-up error msg box
    Add your own password to VBA project.
     
    #14     Jul 21, 2012
  5. will try that tomorrow, thanks a lot!
     
    #15     Jul 21, 2012
  6. I forgot to add a major step. Sorry, it's been a while since I had to remove a vba password.

    Do this first:

    Make a backup copy of the xlsm file, just in case
    change the extension of the original xlsm file to "zip"
    in the zip archive, find the file xl/vbaProject.bin
    open vbaProject.bin in a hex editor
    search for "DBP="
    change to "DBx=" and proceed as above...
     
    #16     Jul 21, 2012
  7. F*ck! Another mistake.

    Seach for "DPB=" not "DBP."

    Otherwise, instructions are the same.
     
    #17     Jul 21, 2012