Position size calculator in Excel

Hi all,

I would like to know if anybody has a position size calculator?
I would like to keep a trading journal and increase my lot size as the account grows.

So for example.

Start with an account of $100 and taking a position of 1K
If I start with $1000 then my position size would be 10K
etc etc

My overall goal is to increase my account with 15% per week.
So if after the first week my account grows to $1150, the next week my positions will be 11.5K etc.
Can this be calculated in excel automatically? Any excel guru or anybody has anything like this to share?

Thanks.

Maybe this is what you looking for.

You should learn about the Excel RTD which will give you the ability to put real-time data into Excel using only Excels RTD() function.

Once the RTD app is running, you can use the following formula in Excel to insert a real-time feed of account, ticket, or price data. You simply need to fill in the account number, and the property which you want to display:

=RTD("ExcelRTD", , "account number", "property")

For example, if your account number is 156734 and you want to display the accounts balance:

=RTD("ExcelRTD", , "156734", "balance")

You can customise it to your wishes, receive real-time data into M$ Excel and can send commands by VBA.

Regards Jibala