+ Reply to Thread
Page 23 of 24 FirstFirst ... 13 21 22 23 24 LastLast
Results 221 to 230 of 238

Thread: forex trading calculator excel sheet

     
  1. TOP MESSAGES
    2019-05-30   12:23
    Best answer #1
    Accrued payments  16029 USD

    एक्सएक्ससीएल स्वचालित रूप से एपीगेट फिजीचर कर सकता है - स्टोक पुजारी, एफएक्स रैटेस, स्पॉर्ट्स गमेस के के फ्लिअट दत्त, और शार्प दत्ताबेस में किसी भी इनफो - एक लीव दत्ता सॉरेस से। यह एक दैनिक आधार पर थकाऊ मैनुअल प्रविष्टि को हरा देता है।
    ध्यान दें कि यह कार्यक्षमता, जिसे "गेट एंड ट्रांसफॉर्म / पावर क्वेरी" कहा जाता है, 2007 संस्करण में उपलब्ध नहीं है। केवल 2010 और बाद में:
    यदि आप 2010 का उपयोग कर रहे हैं, तो पावर क्वेरी ऐड-इन डाउनलोड करें और इंस्टॉल करें। यह पहले से ही 2013 और बाद में बनाया गया है।
    "पावर क्वेरी" (या "डेटा"> "नई क्वेरी"> "अन्य स्रोतों से"> "वेब से" पर क्लिक करें)
    "वेब से" बॉक्स में, url दर्ज करें। यदि वेबसाइट से ही आवश्यकता हो तो उपयोगकर्ता क्रेडेंशियल जानकारी प्रदान करें। ओके पर क्लिक करें।"
    पावर क्वेरी वेबपेज को स्कैन करेगा, और "टेबल व्यू" के तहत "नेविगेटर पेन" में डेटा लोड करेगा।
    उस तालिका का चयन करें जिसे आप सूची से क्लिक करके कनेक्ट करना चाहते हैं।
    "लोड करें" पर क्लिक करें और वेब डेटा आपके कार्यपत्रक पर दिखाई देगा।

    2019-05-30   20:18
    Best answer #2

    Excel Spreadsheet: Lot size and Risk calculator.
    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. 1) .5% of my account size, 2) the number of pips to the stop loss. I created a spread sheet that helps me, thought I would share. *my first posting of this sort .
    Some Notes:*
    at the beginning of the day
    1) put in my current account balance.
    2) Select the Risk in % of account value. (i.e. .5% max for each trade Idea).
    3) enter the current exchange rate for 7 pairs needed to calculate the Pip Value in USD. *(note this will get us in the ballpark to calculate the Pip Value. won't be exact unless you can program in a feed from alveo or another source. that is beyond me at the moment. If a big move happens, you can always update the current value.)
    4) Setup which pairs you want to quickly track lot sizes.
    5) enter the stoploss in pips*
    6) determine if you want to leg into a trade
    *a) specify % risk allocated to each leg.
    *b) specify how far away each leg is from the Stop Loss as a percentage of the Total Stop Loss. entry at the full distance would be 100%. *example: 40pip stop loss with one entry @ 40pips (100%) and second entry at 20 pips from the SL (50%). *hopefully it isn't two confusing. look at the speadsheet for an example. *
    7) Each leg displays the number of pips risk, USD Risk, and Maximum number of lots to trade. also shows the total risk, total lots, for all legs.
    NOTE: *the number of lots have been truncated during the calculation to prevent rounding up. *example: if the calculation said I can open .2589 Lots, it is truncated to .25 to prevent it rounding to .26.

    2019-06-07   20:40
    Best answer #3

    Lot Size*= The lot size you have with your account.
    PIP Value (approximate)*= Lot Size divided by 10,000. For example standard lot size, 100,000 / 10,000 = $10.
    Risk % or % of Capital at Risk*= This is the amount that you choose to risk per trade. Usually, 1.5-2.0% is a recommended value.
    Average PIP Stop Loss*= With this value you have to estimate the average stop loss size for the trading method used.

    2019-06-19   06:00
    Best answer #4
    Accrued payments  1 USD

    Tidak tahu apakah ini akan berguna bagi siapa pun kecuali saya. * Saya telah mencoba menghitung ukuran lot saya dengan lebih efisien berdasarkan dua faktor. 1) .5% dari ukuran akun saya, 2) jumlah pip untuk stop loss. Saya membuat lembar spread yang membantu saya, pikir saya akan berbagi. * Posting pertama saya tentang ini .
    Beberapa Catatan: *
    pada awal hari
    1) dimasukkan ke saldo akun saya saat ini.
    2) Pilih Risiko dalam% dari nilai akun. (mis., maks 5% untuk setiap Ide perdagangan).
    3) masukkan nilai tukar saat ini untuk 7 pasangan yang dibutuhkan untuk menghitung Nilai Pip dalam USD. * (perhatikan ini akan membuat kami berada di stadion baseball untuk menghitung Nilai Pip. tidak akan tepat kecuali Anda dapat memprogram dalam umpan dari alveo atau sumber lain. itu di luar saya saat ini. Jika sebuah langkah besar terjadi, Anda dapat selalu perbarui nilai saat ini

    2019-05-30   20:25
    Best answer #5

    The calculator shows the possible income projections based on the desired risk, amount of capital, type of lot size used, and the PIP value for major USD pairs.
    The following notes apply.
    Lot Size*= The lot size you have with your account.
    PIP Value (approximate)*= Lot Size divided by 10,000. For example standard lot size, 100,000 / 10,000 = $10.
    Risk % or % of Capital at Risk*= This is the amount that you choose to risk per trade. Usually, 1.5-2.0% is a recommended value.
    Average PIP Stop Loss*= With this value you have to estimate the average stop loss size for the trading method used.
    PIPS Profit Per Day*= for swing trading may be considered PIPS per trade and the days may be then considered trades.

    2019-06-06   02:34
    Best answer #6

    Lot Size*= The lot size you have with your account.
    PIP Value (approximate)*= Lot Size divided by 10,000. For example standard lot size, 100,000 / 10,000 = $10.
    Risk % or % of Capital at Risk*= This is the amount that you choose to risk per trade. Usually, 1.5-2.0% is a recommended value.
    Average PIP Stop Loss*= With this value you have to estimate the average stop loss size for the trading method used.
    PIPS Profit Per Day*= for swing trading may be considered PIPS per trade and the days may be then considered trades.

  2. #18
    Banned Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas has a reputation beyond repute Mureedabbas's Avatar
    Join Date
    Jan 2019
    Posts
    1,249
    Thanks
    14,425
    Thanked 6,637 Times in 1,942 Posts
    FOREX TRADING INCOME CALCULATOR – DOWNLOAD EXCEL SPREADSHEET.
    At the link below you will find the Forex Trading Income Calculator in Excel spreadsheet format.

    The calculator shows the possible income projections based on the desired risk, amount of capital, type of lot size used, and the PIP value for major USD pairs.

    The following notes apply.

    Lot Size = The lot size you have with your account.

    PIP Value (approximate) = Lot Size divided by 10,000. For example standard lot size, 100,000 / 10,000 = $10.

    Risk % or % of Capital at Risk = This is the amount that you choose to risk per trade. Usually, 1.5-2.0% is a recommended value.

    Average PIP Stop Loss = With this value you have to estimate the average stop loss size for the trading method used.

    PIPS Profit Per Day = for swing trading may be considered PIPS per trade and the days may be then considered trades.

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  3. #17
    Trusted Member ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn's Avatar
    Join Date
    Jun 2018
    Posts
    5,724
    Thanks
    4,298
    Thanked 19,053 Times in 4,651 Posts
    SubscribeSubscribe
    subscribed 0
    yes my dear friend yes Aap Ki Baat Ko Mangta Hoon Hamesha hi Kya Main Jab Bhi kaam karen to trading acche se Karenge is main Soch Samajh Kar trading Karen Kyunki acche se Soch Samajh Kar trading Karenge toh apna kaam Nahin Honge isliye main Chahe kya maze mein Jab Bhi trade Lagan to amaze Mein Soch Samajh Kar trailer gaana chaahi kar denge

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  4. The Following 4 Users Say Thank You to ntn For This Useful Post:

    Farooq007 (2019-06-29), Lipsee (2020-01-16), Mureedabbas (2019-06-28), zonyakhan (2019-06-29)

  5. #16
    Trusted Member ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn's Avatar
    Join Date
    Jun 2018
    Posts
    5,724
    Thanks
    4,298
    Thanked 19,053 Times in 4,651 Posts
    SubscribeSubscribe
    subscribed 0
    G haan sir ap ki bat sahi hai as main hamen chahiy hai ker ham as main ache se kam kare aor hamen as main mehnat bhi karna chahiy hai aor asforex trading main hame as main ache se aor hamen as main ache as mehnat bhi karna chahiy hai aor hen as main sabar bhi karma chahiy hai

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  6. The Following 3 Users Say Thank You to ntn For This Useful Post:

    Farooq007 (2019-06-29), Mureedabbas (2019-06-28), zonyakhan (2019-06-29)

  7. #15
    Senior Member zohaib1 is just really nice zohaib1 is just really nice zohaib1 is just really nice zohaib1 is just really nice zohaib1 is just really nice zohaib1's Avatar
    Join Date
    Jun 2013
    Location
    pakistan
    Posts
    1,918
    Thanks
    2,366
    Thanked 468 Times in 257 Posts
    SubscribeSubscribe
    subscribed 0
    Don't know if this will be of use to anyone but me. * I have tried to calculate my lot size more efficiently based on two factors. 1). 5% of the size of my account, 2) number of pips for stop loss. I made a spread sheet that helped me, I thought I would share. * My first post about this.

    Some Notes: *

    at the beginning of the day

    1) entered into my current account balance.
    2) Select Risk in% of account value. (eg, max 5% for each trade idea).
    3) enter the current exchange rate for the 7 pairs needed to calculate the Pip Value in USD. * (note this will keep us at the baseball stadium to calculate Pip Value. It won't be right unless you can program it in a feed from an alveo or other source. It's outside of me now. If a big step occurs, you can always update the value when this

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  8. The Following User Says Thank You to zohaib1 For This Useful Post:

    Mureedabbas (2019-06-28)

  9. #14
    Trusted Member ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn's Avatar
    Join Date
    Jun 2018
    Posts
    5,724
    Thanks
    4,298
    Thanked 19,053 Times in 4,651 Posts
    SubscribeSubscribe
    subscribed 0
    Assalamualaikum ji haan bhai jaan aapne bilkul theek kaha hai hamein chahiye ki Forex mein bahut jyada mehnat karna Kyunki Agar Hum Forex mehnat Karenge to ghar jakar Hum Forex Mein Kamyab Honge Agar Hum isme mehnat Nahin Karenge To Kabhi Kamyab nahi honge to Agar Kannada chahiye to bahut jyada mehnat karo

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  10. The Following 3 Users Say Thank You to ntn For This Useful Post:

    Farooq007 (2019-06-29), Mureedabbas (2019-06-28), zonyakhan (2019-06-29)

  11. #13
    Trusted Member ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn has a reputation beyond repute ntn's Avatar
    Join Date
    Jun 2018
    Posts
    5,724
    Thanks
    4,298
    Thanked 19,053 Times in 4,651 Posts
    SubscribeSubscribe
    subscribed 0
    Yes my dear Friend hame chahiy hai hai ker ham as main kam karts hain as u game as main bohat hi ache se kam karna chahiy hai to hi tu ham as main kamyab hi sake gee aor ham agar as main mehnat nahi kare gee tu ham as main kamyab nahi sake gee as liy game chahiy hai jee ham as main ache se bhi kam kare

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  12. The Following 3 Users Say Thank You to ntn For This Useful Post:

    Farooq007 (2019-06-29), Mureedabbas (2019-06-21), zonyakhan (2019-06-29)

  13. #12
    Senior Member zohaib1 is just really nice zohaib1 is just really nice zohaib1 is just really nice zohaib1 is just really nice zohaib1 is just really nice zohaib1's Avatar
    Join Date
    Jun 2013
    Location
    pakistan
    Posts
    1,918
    Thanks
    2,366
    Thanked 468 Times in 257 Posts
    SubscribeSubscribe
    subscribed 0
    Grid trading Download file Please calculator Stop loss calculator This ... The Excel sheet allows you to view the outcome of management using forex system.

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  14. The Following User Says Thank You to zohaib1 For This Useful Post:

    Mureedabbas (2019-06-21)

  15. #11
    Senior Member sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach has a reputation beyond repute sumerach's Avatar
    Join Date
    May 2019
    Location
    arifwala,pakistan
    Posts
    2,437
    Thanks
    2,605
    Thanked 4,092 Times in 1,731 Posts
    SubscribeSubscribe
    subscribed 0
    Lot Size*= The lot size you have with your account.

    PIP Value (approximate)*= Lot Size divided by 10,000. For example standard lot size, 100,000 / 10,000 = $10.

    Risk % or % of Capital at Risk*= This is the amount that you choose to risk per trade. Usually, 1.5-2.0% is a recommended value.

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  16. The Following User Says Thank You to sumerach For This Useful Post:

    Mureedabbas (2019-06-21)

  17. #10
    Senior Member zohaib1 is just really nice zohaib1 is just really nice zohaib1 is just really nice zohaib1 is just really nice zohaib1 is just really nice zohaib1's Avatar
    Join Date
    Jun 2013
    Location
    pakistan
    Posts
    1,918
    Thanks
    2,366
    Thanked 468 Times in 257 Posts
    SubscribeSubscribe
    subscribed 0
    Programming Strategy in Forex Excel Spreadsheet. The data that we are using is of EUR.USD which is recorded minute by minute. Now let us calculate Slow SMA and Fast SMA for this data, but the question remains for what period should we calculate this.

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  18. The Following 6 Users Say Thank You to zohaib1 For This Useful Post:

    aasf123 (2020-05-25), Alizahid (2020-10-21), hammad101 (2020-05-20), Pk25 (2020-09-18), sweety faiza (2019-09-20), usama samar (2020-08-26)

  19. #9
    Member trinugroho is a glorious beacon of light trinugroho is a glorious beacon of light trinugroho is a glorious beacon of light trinugroho is a glorious beacon of light trinugroho is a glorious beacon of light trinugroho is a glorious beacon of light trinugroho's Avatar
    Join Date
    May 2019
    Posts
    330
    Thanks
    1,376
    Thanked 520 Times in 210 Posts
    SubscribeSubscribe
    subscribed 0
    Excel Spreadsheet: Lot size and Risk calculator.

    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. 1) .5% of my account size, 2) the number of pips to the stop loss. I created a spread sheet that helps me, thought I would share. my first posting of this sort .
    Some Notes:
    at the beginning of the day
    1) put in my current account balance.
    2) Select the Risk in % of account value. (i.e. .5% max for each trade Idea).
    3) enter the current exchange rate for 7 pairs needed to calculate the Pip Value in USD. (note this will get us in the ballpark to calculate the Pip Value. won't be exact unless you can program in a feed from alveo or another source. that is beyond me at the moment. If a big move happens, you can always update the current value.)
    4) Setup which pairs you want to quickly track lot sizes.
    5) enter the stoploss in pips
    6) determine if you want to leg into a trade
    a) specify % risk allocated to each leg.
    b) specify how far away each leg is from the Stop Loss as a percentage of the Total Stop Loss. entry at the full distance would be 100%. example: 40pip stop loss with one entry @ 40pips (100%) and second entry at 20 pips from the SL (50%). hopefully it isn't two confusing. look at the speadsheet for an example.
    7) Each leg displays the number of pips risk, USD Risk, and Maximum number of lots to trade. also shows the total risk, total lots, for all legs.
    NOTE: the number of lots have been truncated during the calculation to prevent rounding up. example: if the calculation said I can open .2589 Lots, it is truncated to .25 to prevent it rounding to .26.

    Though trading on financial markets involves high risk, it can still generate extra income in case you apply the right approach. By choosing a reliable broker such as InstaForex you get access to the international financial markets and open your way towards financial independence. You can sign up here.


  20. The Following 7 Users Say Thank You to trinugroho For This Useful Post:

    aasf123 (2020-05-25), Alizahid (2020-10-21), hammad101 (2020-05-20), Joo (2020-10-12), Pk25 (2020-09-18), sweety faiza (2019-09-20), usama samar (2020-08-26)

+ Reply to Thread
Page 23 of 24 FirstFirst ... 13 21 22 23 24 LastLast

Subscribe to this Thread (2)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Currently Active UsersCurrently Active Users

There are currently users online. members and guests

Forex Forum India | Forex Community Place Statistics Forex Forum India Statistics

Most users ever online was .

Welcome to our newest member,

Threads:

Posts:

Member: