Kelly Criterion Maths Formula

Hello,

I'm looking for someone who is familiar with the Kelly Criterion specifically for forex and CFDs. 

I need help in taking the basic Kelly formula which I have in google sheets and adding some steps to give me the lot size to be used per trade. 

I know what percentage to use and the dollar figure to risk, now I need to convert this to lots to use for the trade.

It must work on 2,3,4,5 decimal place quotes.