Real time PNL in excel with Trader Workstation

Quote from TradingNerd:

getting errors in hidden modules..

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.
 
Quote from TradingNerd:

is there a way to get the xlsm password free?
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.
 
Quote from TradingNerd:

will try that tomorrow, thanks a lot!

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...
 
Quote from Kevin Schmit:

search for "DBP="
change to "DBx=" and proceed as above...

F*ck! Another mistake.

Seach for "DPB=" not "DBP."

Otherwise, instructions are the same.
 
Back
Top