+ Reply to Thread
Page 13 of 24 FirstFirst ... 3 11 12 13 14 15 23 ... LastLast
Results 121 to 130 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. #118
    Member Sameer10 is a name known to all Sameer10 is a name known to all Sameer10 is a name known to all Sameer10 is a name known to all Sameer10 is a name known to all Sameer10 is a name known to all Sameer10's Avatar
    Join Date
    Jun 2020
    Posts
    925
    Thanks
    0
    Thanked 605 Times in 442 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.


  3. #117
    Member Sameer10 is a name known to all Sameer10 is a name known to all Sameer10 is a name known to all Sameer10 is a name known to all Sameer10 is a name known to all Sameer10 is a name known to all Sameer10's Avatar
    Join Date
    Jun 2020
    Posts
    925
    Thanks
    0
    Thanked 605 Times in 442 Posts
    SubscribeSubscribe
    subscribed 0
    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.

    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. #116
    Banned guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000's Avatar
    Join Date
    May 2020
    Location
    Islamabad
    Posts
    3,652
    Thanks
    10,915
    Thanked 4,238 Times in 2,265 Posts
    yes hum sab ko yahi sheet banani chaheya jis me hum daily trading so calculator me data ka pata chal sake or is excel sheet say hum progress report be bana saken jis say hum ko monthly report me pata chal sakta ha ka hum na kitna loss keya ho kitna profit keya me khud be yahi karta hun or bahut aasan rahta ha ye sub kuch trading me.
    Quick reply to this message Reply With Quote Multi-Quote This Message
    Remove Your Thanks

    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.


  5. #115
    Member bhole001 has a spectacular aura about bhole001 has a spectacular aura about bhole001 has a spectacular aura about bhole001's Avatar
    Join Date
    Jun 2020
    Posts
    296
    Thanks
    503
    Thanked 231 Times in 137 Posts
    SubscribeSubscribe
    subscribed 0
    yes hum sab ko yahi sheet banani chaheya jis me hum daily trading so calculator me data ka pata chal sake or is excel sheet say hum progress report be bana saken jis say hum ko monthly report me pata chal sakta ha ka hum na kitna loss keya ho kitna profit keya me khud be yahi karta hun or bahut aasan rahta ha ye sub kuch trading me.
    Quick reply to this message Reply With Quote Multi-Quote This Message
    Remove Your Thanks
    The Following 2 Users Say Thank You to hammad101 For This Useful Post:
    bhole001 (Today), guru000 (05-20-2020)
    #112
    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.

    Is me aap aik strategy bana rahay hotay hai jo k aap k trading skill ko improve kar skay . lekin aap ko is me aik or cheez ka khas khiyal rakhna hai k calculation aap ki theek honi chahiye or calculation bhi profit par base karni chahiye.
    Quick reply to this message Reply With Quote Multi-Quote This Message
    Remove Your Thanks
    The Following 2 Users Say Thank You to hammad101 For This Useful Post:
    bhole001 (Today), guru000 (05-20-2020)
    #113
    USD/CaD is a best and fast moving pair dear friends . I am place the order regular . At this time this pair tend is a dome . I think that we are sat that the sell is a best opportunity .
    But dear trader I am say that those are interest in this pair and they are take the entry with the proper analysis than they are place the order . friends trading is best then experience .
    Quick reply to this message Reply With Quote Multi-Quote This Message
    Remove Your Thanks
    The Following 2 Users Say Thank You to hammad101 For This Useful Post:
    bhole001 (Today), guru000 (05-20-2020)
    #114
    We could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit of moving the average. So I guess with the intersect we won't miss the signal.
    Quick reply to this message Reply With Quote Multi-Quote This Message
    Remove Your Thanks
    The Following 2 Users Say Thank You to hammad101 For This Useful Post:
    bhole001 (Today), guru000 (05-20-2020)
    #115
    yes hum sab ko yahi sheet banani chaheya jis me hum daily trading so calculator me data ka pata chal sake or is excel sheet say hum progress report be bana saken jis say hum ko monthly report me pata chal sakta ha ka hum na kitna loss keya ho kitna profit keya me khud be yahi karta hun or bahut aasan rahta ha ye sub kuch trading me.
    Quick reply to this message Reply With Quote Multi-Quote This Message
    Remove Your Thanks
    The Following 2 Users Say Thank You to hammad101 For This Useful Post:
    bhole001 (Today), guru000 (05-20-2020)
    #116
    #111
    yes hum sab ko yahi sheet banani chaheya jis me hum daily trading so calculator me data ka pata chal sake or is excel sheet say hum progress report be bana saken jis say hum ko monthly report me pata chal sakta ha ka hum na kitna loss keya ho kitna profit keya me khud be yahi karta hun or bahut aasan rahta ha ye sub kuch trading me
    Quick reply to this message Reply With Quote Multi-Quote This Message #117
    We could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit of moving the average. So I guess with the intersect we won't miss the signal.
    Quick reply to this message Reply With Quote Multi-Quote This Message #118
    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
    Quick reply to this message Reply With Quote Multi-Quote This Message
    Remove Your Thanks
    The Following 2 Users Say Thank You to aasf123 For This Useful Post:
    bhole001 (Today), guru000 (05-30-2020)
    #119
    Smile
    could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit of moving the average.

    --- Update ---

    could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit ofjj mnsjxnf noving the average.
    Quick reply to this message Reply With Quote Multi-Quote This Message
    Remove Your Thanks
    The Following 2 Users Say Thank You to aasf123 For This Useful Post:
    bhole001 (Today), guru000 (05-30-2020)
    #120
    could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit of moving the average.

    --- Update ---

    could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit ofjj mnsjxnf noving the average.
    Quick reply to this message Reply With Quote Multi-Quote This Message

    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 User Says Thank You to bhole001 For This Useful Post:

    guru000 (2020-06-03)

  7. #114
    Banned guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000's Avatar
    Join Date
    May 2020
    Location
    Islamabad
    Posts
    3,652
    Thanks
    10,915
    Thanked 4,238 Times in 2,265 Posts
    could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit of moving the average.

    --- Update ---

    could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit ofjj mnsjxnf noving the average.

    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 guru000 For This Useful Post:

    bhole001 (2020-06-01)

  9. #113
    Banned aasf123 will become famous soon enough aasf123 will become famous soon enough aasf123's Avatar
    Join Date
    May 2020
    Posts
    92
    Thanks
    658
    Thanked 120 Times in 73 Posts

    Smile

    could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit of moving the average.

    --- Update ---

    could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit ofjj mnsjxnf noving the average.

    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 2 Users Say Thank You to aasf123 For This Useful Post:

    bhole001 (2020-06-01), guru000 (2020-05-30)

  11. #112
    Banned aasf123 will become famous soon enough aasf123 will become famous soon enough aasf123's Avatar
    Join Date
    May 2020
    Posts
    92
    Thanks
    658
    Thanked 120 Times in 73 Posts
    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

    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 2 Users Say Thank You to aasf123 For This Useful Post:

    bhole001 (2020-06-01), guru000 (2020-05-30)

  13. #111
    Banned guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000's Avatar
    Join Date
    May 2020
    Location
    Islamabad
    Posts
    3,652
    Thanks
    10,915
    Thanked 4,238 Times in 2,265 Posts
    We could use both stop loss and take on the necessary profit for which we could generate profits from our trading. It's trending. It was trending. It was trending. And so we won't miss the moment to do the open position, moving the average in my view is the most precise indicator used to analyze a forex market and prove to be the profit of moving the average. So I guess with the intersect we won't miss the signal.

    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 guru000 For This Useful Post:

    bhole001 (2020-06-01)

  15. #110
    Banned guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000 has a reputation beyond repute guru000's Avatar
    Join Date
    May 2020
    Location
    Islamabad
    Posts
    3,652
    Thanks
    10,915
    Thanked 4,238 Times in 2,265 Posts
    #111
    yes hum sab ko yahi sheet banani chaheya jis me hum daily trading so calculator me data ka pata chal sake or is excel sheet say hum progress report be bana saken jis say hum ko monthly report me pata chal sakta ha ka hum na kitna loss keya ho kitna profit keya me khud be yahi karta hun or bahut aasan rahta ha ye sub kuch trading me

    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 guru000 For This Useful Post:

    bhole001 (2020-06-01)

  17. #109
    Senior Member hammad101 is a splendid one to behold hammad101 is a splendid one to behold hammad101 is a splendid one to behold hammad101 is a splendid one to behold hammad101 is a splendid one to behold hammad101 is a splendid one to behold hammad101 is a splendid one to behold hammad101's Avatar
    Join Date
    May 2020
    Location
    Sadiqabad
    Posts
    1,137
    Thanks
    6,492
    Thanked 894 Times in 574 Posts
    SubscribeSubscribe
    subscribed 0
    yes hum sab ko yahi sheet banani chaheya jis me hum daily trading so calculator me data ka pata chal sake or is excel sheet say hum progress report be bana saken jis say hum ko monthly report me pata chal sakta ha ka hum na kitna loss keya ho kitna profit keya me khud be yahi karta hun or bahut aasan rahta ha ye sub kuch trading me.

    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 2 Users Say Thank You to hammad101 For This Useful Post:

    bhole001 (2020-06-01), guru000 (2020-05-20)

+ Reply to Thread
Page 13 of 24 FirstFirst ... 3 11 12 13 14 15 23 ... 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: