Excel Help Please

Discussion in 'Trading Software' started by white17, Jan 30, 2003.

  1. white17


    I have a column of numbers in an excel sheet. I have figured everything I want except the "mean" and can't find the correct function command. Anyone help? TIA
  2. =average(a:a) or whatever your column is
  3. white17


    ZT: Thank you !
  4. summing the numbers up and dividing by N would have worked too :D LOL. Just kidding.
  5. white17


    I broke down and used the AVERAGE Fx.:)
  6. I'm looking to create a real time spreadsheet. I have AT which has a nice DDE link, however I don't know how to create new rows every 5 minutes so I can calculate formulas. I also need help creating an alarm of some sort.

    Does anyone have something similiar already that they might want to sell?