Hi
The setting in your first point works correctly in the full version of the program. I tried installing the Lite version on another computer to test this on your behalf, but my username is registered to the full version, so I can't test it.
Your second point, again I am not sure if you can do this in the Lite version. In the manual in the "Triggered Betting" chapter, it states "this functionality is available in the full version". Sub-sections of Triggered Betting cover the variables you are trying to export, as well as Excel bound variables, so I would think this is not available in the Lite version.
Regarding the actual examples you give:
A20 is reserved for the 6th selections volume% on the market sheets
A21 is reserved for the 6th selections place in the outcome of events on the market sheets
If the Lite version allows it, your Custom Cell reference should include the non-market sheet name:
Sheet1!A20
Sheet1!A21
Sorry I could not be more helpful regarding what Lite can / cannot do.