Author Topic: Protecting Excel Custom Cells  (Read 2743 times)

Tags:
  • All members
  • Posts: 48
Protecting Excel Custom Cells
« on: 28 Aug 2013, 21:43 »
I am consdering offering one of my triggers for lease.  However, this trigger makes use of Excel Custom Cells which I would not want to disclose.

Is there a way to protect/encrypt the settings file, in the same way we can protect the trigger files?

  • All members
  • Posts: 48
Re: Protecting Excel Custom Cells
« Reply #1 on: 29 Aug 2013, 20:34 »
Anyone? Tim, Oxa?  :)

  • Moderator
  • Posts: 3605
*
Re: Protecting Excel Custom Cells
« Reply #2 on: 29 Aug 2013, 22:35 »
Hi
This is just an idea and I do not know if it is possible - it will need some research.

set the custom cells in hexadecimal, then
in Excel using a function or VBA code, convert the hex to ASCII text at runtime

for example:
62 61 63 6b 5f 70 72 69 63 65 in hex
is "back_price" in ASCII

Also, I think you can hide cell values / rows / columns in Excel. So perhaps you can do all your secret stuff in a hidden V/R/C.
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • Administrator
  • Posts: 8826
  • Gender: Female
*
Re: Protecting Excel Custom Cells
« Reply #3 on: 30 Aug 2013, 14:41 »
Hi,
I'm sorry, the settings file cannot be protected in MarketFeeder Pro.
However, the contents of the customcells.xml file where your custom cells are stored is protected: you cannot see what is written there if you open the file.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

 

Please note, BetFair is seems to be currently OFFLINE