I am fairly new to Apiary, Don't know if this will be of any use to anyone but me. I have been trying to more effeciently calculate my lot size for a trade based on two factors. I created a spread sheet that helps me, thought I would share. If a big move happens, you can always update the current value. Alveo accepts all lot sizes greater than 0. So you can also enter 0. Of course I am still in the demo account, not sure how a real accounts liquidity provider would react: I copied an absolute reference to a number of cells that breaks the calculations in some of the boxes references the wrong stoploss in pips and the wrong pip value.
You might want to check those calcs, just to be sure everything is working ok. Lots of great upgrades to the new release. NZD is the Quote currency. The first version required multiple legged trades to be calculated by a percent of the original stop. I have removed this. Now each leg requires a set number of pips for each legs stoploss.
Hi greenbackman59, I really like the new version of Alveo. I was using the Beta for a while before it was promoted to production. I was using the single click trading to put in stop loss and lot size checking that the risk was less than my max. I am trying to see if my spreadsheet will improve the time it takes me given I was having to adjust the lot size until I hit on the right amount. SlowHand - when you say Alveo accepts lots sizes such as 0.
That looks like completely variable trade sizing. I will have to look into that a bit closer. Ok I hate to appear thick headed but I will anyway. I have great difficulty figuring out how to use spreadsheets in Excel. I was wanting to create one just like yours Terry with no luck. I love your updated version and you gave detailed instructions and still I am challenged. I am studying the Excel how to guide in hopes that this will help me enter my stats can you suggest any other ways to learn how to input?
Or maybe I just need to keep reading your instructions over and over until I get it? Hi Fxjunkie, excel can be a bear to get to understand. I have created one for tracking my stock trades in the past I will need to take some time to adjust it so that you can use it for your alveo trades. Hey Terry you are so kind: If not I would love to do a screen share with you to help Thank you!! I was starting to work on this myself. You did a great job. I will use yours. I love spreadsheets but I am just a novice.
Keep up the good work. No person, institution, or entity, including the Apiary Investment Fund, can guarantee a return on investment for such transactions. Neither the Apiary Investment Fund nor its representatives will recommend the purchase, sale, or transaction advice for a specific security.
To learn more about how to get involved, sign up now for a 14 day free trial or fill out the form below and preview the training right now!
Skip to main content. Lot size and Risk calculator. Thanks SlowHand I did not know that. Markets are closed now, and I cannot check for myself! Thanks you for putting it together. I included a link to a screen capture and labeled the cells you should change.
Fxjunkie, if you are talking about creating a new spreadsheet to track your trades let me see if I can find one that will work.More...