win

Hi, I am adding to my sheet a trading simulator. Out of 100 trades, the Win Rate, for example, is 60% (60 trades will Win out of 100). On the spreadsheet, I want the R-Multiple colum to reflect this by showing 60 (3.00) and 40 (-1.00). Each Win is represented by a ‘3’ and each loss by ‘-1.00'. I...

Hi folks, looking for a little help again. I am trying to do a small ‘drawdown’ sheet for my trading account. I use a 3 to 1 risk ratio. I am willing to risk ‘1’ (2% of my account) to make ’3’ (6% gain). Each time I lose a trade, I lose 2% of my account, so 4 consecutive losing trade, means I...

hello all, i have had help on this before but i have added something new and can't work out the formula <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Win Price Place Price Win Outlay Place Outlay Finished Win Amount Place Amount Won/Lost $4.70 $1.90 $50.00 $50.00 1st...

<tbody> <tbody> RED CONFERENCE SEASON TOTAL WIN LOSS WIN LOSS 1 2 3 4 5 6 7 1 Richards 2 0 2 0 1 7 6 5 4 3 2 1 2 Argo 1 0 2 0 2 6.5 5.5 4.5 3.5 2.5 1.5 2 Shepard 1 0 2 0 3 6 5 4 3 2 2 Evergreen Park 1 1 1 1 4 5.5 4.5 3.5 2.5 2 Reavis 1 1 1 1 5 5 4 3 6...

Hi, I am trying to count based on the lookup multiple ranges. Example; In data sheet code "1111" contain count 5 and result is "WIN" against "ENG" . In Sheet-2 code "1111", I have 11 row, formula fill the result first 5 row "WIN" and rest of the row is blanks. File attached for your...

I have a Status Column (Win, Loss and Open), it's 6th on the Rows area of my pivot table. I want to subtotal Win, Loss and Open and show it on the bottom of the table, like how Grand Total is shown. Is it possible? What's the workaround?

I'm creating a spreadsheet to keep track of my hobby, sports betting. Of course, being a mediocre Excel nerd, I want to automate as much as possible, but now I'm running into a formula issue. I swear I'm so close, but now I need help from the pros. So here's what I have and what I'm looking for...

Hey there. Long time since I have posted something and became stuck on something. I want to track Wins and Losses for a set of baseball teams. Every game will have a W or an L Go back 10 games and tell me the % of those games that team has won Also, Go back 25 games and tell me the % of those...

Hey guys, I have two sets of data - one has an IF formula which leaves the words 'win' or 'lose' based on the results. Formula is =IF(A15<=C15,"lose","win") And another which highlights a cell based on conditional formatting formula is =E2>AVERAGE(E$2:E$11)*1.1 What I'd like to have is a...

Please can someone tell me why this doesn't work? RepeatPublish is a named range on another sheet which has the value "Yes" in it. It works without the the second test. Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("C:P")) Is Nothing Then...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Hi Guy's Any idea how to I turn my data output from this.... <colgroup><col><col><col><col span="3"></colgroup><tbody> 201309 201310 201311 201312 201401 A 13000 18266 15300 7250 25050 B 0 15568.9904 15000 16900 47040 C 0 0 0 8750 126082.4 </tbody> to this very quickly please...

Hello, I would like to know how i could sum the most consecutive wins in dollars in column A, and the average consecutive wins in column B. In the table below, you can see in column A1:A3, three consecutive dollar wins which should total $43. How do i go about calculating the largest sum in...

Hi! I'm having difficulties completing my scoringsheet for NeXT year's World Cup. The system is listen on this Picture: https://imgur.com/a/vbehT. 1. My problem is that I want the result in the matches to decide where each team ends up in the Group. For example, if Russia and Egypt win their...

<tbody> Status Bookmaker Rating Win Nitrogen Sports Pick of the Day Loss Nitrogen Sports Regular Win TRP Special Pick of the Day Loss TRP Special Pick of the Night Win TRP Special Pick of the Day Win TRP Special Pick of the Night </tbody> Alright, So I am trying to find the current...

Hi everyone, new forum user here with some knowledge on vba and excel. This has been a great resource for me to use excel effectively and am hopeful if someone can help me with a long time problem of mine; Format: Excel Online Code: Excel Formula I am trying to figure out a function that's...

Does Excel have functions that will enable me to calculate Z scores for Normal distributions that are not symmetrical? Suppose I have all of the data for all of the major league baseball teams going back over 100 years. Suppose I want to calculate the mean and std dev for win streaks of various...

I can not seem to figure this out. I'm trying to make this code as simple as possible, without using loops or "If" statements, but cannot seem to figure out how to reference every odd numbered column. I've got a sheet that has a list of "Player's Names" in column A. I have headers going across...

I have been using API code similar to https://www.mrexcel.com/forum/excel-questions/6148-possible-hide-excel-title-bar.html successfully to hide the Title Bar (min, max, close, menu buttons) in Excel 2013/2016 running Win 7/Win 10 and it has been working without issue on tablets when rotating...

Hi guys. I have some problems with IE on win 7, 64bit. There are some sites that have lots of java and flash content. when I open them in IE these sites shows only a blank screen (both IE10 and IE11). I've tried to change security settings in IE to get it to display these sites but so far...