losing

  1. R

    Losing Validation and Conditional Formatting on paste

    Hello, Is there a way to avoid losing conditional formatting and data validation when pasting data in the cells? Thank you.
  2. P

    How to set up an effective formula for testing a betting system.......

    Hi, What kind of excels functions that involved for setting up an effective formula to check and see if the following betting strategy would work for every 9,500 or so hands, and I'm using excel 2007: +10 +20 +10 -20 +20 +10 -20 -30 -70 -150 -10 -30 -70 +150 +10 -10 -30 +70 -10 +30 -10...
  3. R

    Problems with formulas when adding or removing rows from tables

    Hello. Before anything else, I want to say that if there is a better formula/method to do what I am doing and that by itself solves the problem of the cells losing their "counting" when adding rows, or losing the reference when deleting rows, then I will use that method. Basically, I created a...
  4. M

    Drawdown formula problem

    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...
  5. W

    Drawdown Calculation or Largest losing streak by value

    Hi All, Please help me...... I am looking for an in cell formula to tell me the max value losing streak or drawdown for the the table i have attached the image of. I have search hi and low and can only find vaalue by value drawdown, drawdown against peak value and losing steak by number of...
  6. Grizlore

    Lost all formulas in cells

    Help please This keeps happening, and I can't see why... On some worksheets and spreadsheets, when I save the formulas disappear, only to be replaced by the previously calculated values. It has become a real pain. I assume this is something simple. Can anyone help please? Thanks & Regards

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top