+ Reply to Thread
Page 7 of 24 FirstFirst ... 5 6 7 8 9 17 ... LastLast
Results 61 to 70 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-06-19   09:50
    Best answer #2
    Accrued payments  44 USD

    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. #178
    Banned 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews's Avatar
    Join Date
    Sep 2020
    Posts
    377
    Thanks
    1,129
    Thanked 740 Times in 270 Posts
    Meny kabhi forex trading men excel calculator zyada use to ni kia magar is bat ka zror bta skta hon kay agar hum excel calculator use krn to humen pata hoga kay hum kitna profit earn kr rhay hen daily or month ka kitna revenue generate kr rhy hen.

    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. The Following User Says Thank You to 12topnews For This Useful Post:

    hspak (2020-09-21)

  4. #177
    Junior Member YTPAK is on a distinguished road YTPAK's Avatar
    Join Date
    Sep 2020
    Posts
    28
    Thanks
    218
    Thanked 40 Times in 15 Posts
    SubscribeSubscribe
    subscribed 0
    Forex trading Excel sheet bahut hi jyada important Hoti Hai Jiska vagaira aap kabhi bhi apna profit Nahin Hasil kar sakte Kyunki Excel sheet ko batati hai ki aapane Kitna Jyada profit gain kiya hai aur Kitna Jyada Apna profit loss kiya hai isiliye trading Excel sheet ka aapko use karna bahut hi jyada acche se aana chahie Yahi aap ek acche deban Sakenge aur Jyada Jyada profit gain

    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. The Following 2 Users Say Thank You to YTPAK For This Useful Post:

    12topnews (2020-09-24), hspak (2020-09-21)

  6. #176
    Banned RKumar will become famous soon enough RKumar will become famous soon enough RKumar's Avatar
    Join Date
    Apr 2020
    Posts
    679
    Thanks
    33
    Thanked 139 Times in 114 Posts
    Many traders maintain several spreadsheets that they use to keep track of different aspects of my trading and log them over time. they are critical in their weekly self-evaluations and refining their my 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.


  7. The Following 3 Users Say Thank You to RKumar For This Useful Post:

    12topnews (2020-09-24), hspak (2020-09-21), YTPAK (2020-09-15)

  8. #175
    Banned Warid has a reputation beyond repute Warid has a reputation beyond repute Warid has a reputation beyond repute Warid has a reputation beyond repute Warid has a reputation beyond repute Warid has a reputation beyond repute Warid has a reputation beyond repute Warid has a reputation beyond repute Warid has a reputation beyond repute Warid has a reputation beyond repute Warid has a reputation beyond repute Warid's Avatar
    Join Date
    Sep 2020
    Posts
    8,943
    Thanks
    1,374
    Thanked 16,324 Times in 7,945 Posts
    Forex trading Excel sheet bahut hi jyada important Hoti Hai Jiska vagaira aap kabhi bhi apna profit Nahin Hasil kar sakte Kyunki Excel sheet ko batati hai ki aapane Kitna Jyada profit gain kiya hai aur Kitna Jyada Apna profit loss kiya hai isiliye trading Excel sheet ka aapko use karna bahut hi jyada acche se aana chahie Yahi aap ek acche deban Sakenge aur Jyada Jyada profit gain kar Sakenge

    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.


  9. The Following 2 Users Say Thank You to Warid For This Useful Post:

    hspak (2020-09-21), YTPAK (2020-09-15)

  10. #174
    Banned 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews's Avatar
    Join Date
    Sep 2020
    Posts
    377
    Thanks
    1,129
    Thanked 740 Times in 270 Posts
    mujhay tu excell sheet per bharoosa nahe hai or na hi mjhy is sy faida hoa han albata mjhy journal sy zror faida hoa hai us sy banda stick to the plan rehta 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.


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

    hspak (2020-09-21), Warid (2020-09-13), YTPAK (2020-09-15)

  12. #173
    Banned Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin has a reputation beyond repute Alaadin's Avatar
    Join Date
    Sep 2020
    Location
    Turkey
    Posts
    635
    Thanks
    4,683
    Thanked 5,238 Times in 839 Posts
    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.

    -----Update-----

    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.


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

    hspak (2020-09-21), Raheel654 (2020-09-09), Warid (2020-09-13), YTPAK (2020-09-15)

  14. #172
    Banned Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148 has a reputation beyond repute Abubakar 148's Avatar
    Join Date
    Feb 2020
    Posts
    2,729
    Thanks
    9,276
    Thanked 4,196 Times in 2,239 Posts
    forex trading calculator excel sheet
    एक्सएक्ससीएल स्वचालित रूप से एपीगेट फिजीचर कर सकता है - स्टोक पुजारी, एफएक्स रैटेस, स्पॉर्ट्स गमेस के के फ्लिअट दत्त, और शार्प दत्ताबेस में किसी भी इनफो - एक लीव दत्ता सॉरेस से। यह एक दैनिक आधार पर थकाऊ मैनुअल प्रविष्टि को हरा देता है।

    ध्यान दें कि यह कार्यक्षमता, जिसे "गेट एंड ट्रांसफॉर्म / पावर क्वेरी" कहा जाता है, 2007 संस्करण में उपलब्ध नहीं है। केवल 2010 और बाद में:

    यदि आप 2010 का उपयोग कर रहे हैं, तो पावर क्वेरी ऐड-इन डाउनलोड करें और इंस्टॉल करें। यह पहले से ही 2013 और बाद में बनाया गया है।

    "पावर क्वेरी" (या "डेटा"> "नई क्वेरी"> "अन्य स्रोतों से"> "वेब से" पर क्लिक करें)

    "वेब से" बॉक्स में, url दर्ज करें। यदि वेबसाइट से ही आवश्यकता हो तो उपयोगकर्ता क्रेडेंशियल जानकारी प्रदान करें। ओके पर क्लिक करें।"

    पावर क्वेरी वेबपेज को स्कैन करेगा, और "टेबल व्यू" के तहत "नेविगेटर पेन" में डेटा लोड करेगा।

    उस तालिका का चयन करें जिसे आप सूची से क्लिक करके कनेक्ट करना चाहते हैं।

    "लोड करें" पर क्लिक करें और वेब डेटा आपके कार्यपत्रक पर दिखाई देगा।

    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.


  15. The Following 4 Users Say Thank You to Abubakar 148 For This Useful Post:

    hspak (2020-09-21), Raheel654 (2020-09-09), Warid (2020-09-13), YTPAK (2020-09-15)

  16. #171
    Member Ehsankhan341 will become famous soon enough Ehsankhan341's Avatar
    Join Date
    Sep 2020
    Posts
    184
    Thanks
    4
    Thanked 79 Times in 43 Posts
    SubscribeSubscribe
    subscribed 0
    Forex trading excel sheet bht e kam ki chez hoti hai forex tyrading main qnk ish sy apko andaza rehta hai k mna kitna profit gain kiya hai aur kitna loss kiya hai bassically ye ek calculator hota hai jis sy hum rofit aur loss ka hisaab kitab rakhty hain aur ye sheet calculator humen achy sy use krna ana chaghiye q n k ish ki madat sy humen ta chalta a rofit aur loss ka

    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.


  17. The Following 6 Users Say Thank You to Ehsankhan341 For This Useful Post:

    Abubakar 148 (2020-09-09), hspak (2020-09-21), Raheel654 (2020-09-09), Unregistered (1), Warid (2020-09-13), YTPAK (2020-09-15)

  18. #170
    Banned 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews is a splendid one to behold 12topnews's Avatar
    Join Date
    Sep 2020
    Posts
    377
    Thanks
    1,129
    Thanked 740 Times in 270 Posts
    mujhy is strategy ki bilkul smjh nahe arhe hai magar mjhy sirf itna pata hai kay agar mery pas 100$ hai to men 0.02 ki trade laga skta hon, zyada bhi laga skta hon magar risk berh jay ga. So agar kisi dost ko mjhy guide krna hai tu kindly guide kr den shukria.

    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.


  19. The Following 4 Users Say Thank You to 12topnews For This Useful Post:

    Abubakar 148 (2020-09-09), Raheel654 (2020-09-09), Warid (2020-09-13), YTPAK (2020-09-15)

  20. #169
    Banned sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest has a reputation beyond repute sakigbest's Avatar
    Join Date
    Mar 2018
    Location
    Punjab
    Posts
    9,065
    Thanks
    17,563
    Thanked 16,928 Times in 5,537 Posts
    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.


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

    Abubakar 148 (2020-09-09), Raheel654 (2020-09-09), Warid (2020-09-13), YTPAK (2020-09-15)

+ Reply to Thread
Page 7 of 24 FirstFirst ... 5 6 7 8 9 17 ... 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: