Search results

  1. H

    Excel

    Haven't seen any books specificaly for trading applications, been reading VBA books myself. My model is almost complete at this point, just trying to make it easier to use. I have 1 version for bonds and 1 version for eminis, would like to combine them. Just found this site by searching...
  2. H

    Excel

    maxpi, How do I get it to display 2.5/32? In the Format Cells window, Numbers tab, custom, I selected #???/32 It didn't let me put a decimal point between the question marks to display 1/2 ticks. As far as the first question, the input cell will not be the same format as the arrays...
  3. H

    Excel

    Let me add 1 more question to that. Is it possible to combine decimal and fraction formats? example: 2.5/32
  4. H

    Excel

    Anyone know how to make the number format of an array change based on the value of a particular cell (not in the array)? Conditional formatting only allows for changes to font, borders, and patterns.
  5. H

    Margin for options on futures

    Future options are margined with SPAN. It's risk based not a set calculation. You can get current parameters at cme.com
  6. H

    Excel ?

    couldn't figure it out so I rewrote the formula. {=MAX(($E$2:$E$483=H2)*($F$2:$F$483))} cleaner this way
  7. H

    Excel ?

    should be (D2: D483) without the space not (D2:D483) damn smilies...
  8. H

    Excel ?

    I have the following formula perform a data sort. {=(ADDRESS(MIN(IF(E2:E483=G2,ROW(D2:D483))),COLUMN(D2:D483),4))} How do I convert the resulting cell address to the cell value. I thought that I'd done this before but, for the life of me, I can't figure it out. Thanks in advance.
  9. H

    E-Signal IP address

    Thanks. He called back and they put him on a different server. He just got everythink back up and running.
  10. H

    E-Signal IP address

    I got it. 8 time outs. sounds like an E-signal server issue. All other ping tests passed.
  11. H

    E-Signal IP address

    I'm trying to help a friend (via instant messanger) get his e-signal back up. appearantly their tech supprt isn't being too helpful. Does anyone know where to find the IP address so I can walk him through a ping test. All of his other apps are working fine. He says there's no icon in the...
  12. H

    listen to this laptop buying horror story

    Yeh, I don't know that much about this stuff but the controller cards range from $30 to $700. I'll have to research it some.
  13. H

    listen to this laptop buying horror story

    I don't need 300 gigs. That was the only IBM I found. The cheapest 10K rpm HD newegg.com has is a Western Digital 36.7 GB serial ATA 150 for $101. They also have Fufitsu 36.7GB SCSI Ultra320 68pin and 80pin for $120. I figure it's probably worth the exta $19 for the SCSI over the ATA...
  14. H

    Prop Firms software

    TT and CQG
  15. H

    listen to this laptop buying horror story

    Found 15,000 rpm drives but only from Fujitsu, Hitachi, and Seagate. Not finding much in the way of IBM. This is the only HD I've found so far. Product Info 32P0799 IBM Hard Drive ULTRA320 NON-SWAP SCSI 300GB 10000RPM, NEW RETAIL.IN STOCK. $875.00...
  16. H

    Help --Buying a used computer --

    Don't know if this s still available but if you're in the Chicago area, I found this on craigslist. System for sale - $500 Reply to: sale-136583577@craigslist.org Date: 2006-02-24, 5:33AM CST Amd athlon water cooled rig.Cpu and north bridge is water cooled in integrated koolance...
  17. H

    listen to this laptop buying horror story

    About 3 or 4 months after the HP debacle I built a PC for my mother, for $550, that was significantly better than mine was. Ordered everything form pricewatch.com and newegg.com. I've built 2 more since then aswell.
  18. H

    listen to this laptop buying horror story

    You're absolutely right. I should have included that aswell. It came with a Maxtor 5400 rpm HD. There weren't a whole lot of 10,000 rpm drives out at the time but there is a huge difference between 5400 and 7200. I had already replace the stock maxtor with a 7200 rpm Western Digital HD by...
  19. H

    listen to this laptop buying horror story

    Never owned a laptop but as far as PCs go I'll never buy a preassembled computer again. In 2001 I bought a HP Pavilion with an Athlon 1600 and 512 MBs of RAM from Sams Club for $900. It worked fine for about 6 months, then I started getting blue screen errors. "IRQL not less or equal"...
  20. H

    system restore

    In this case could you just remove the object using Spybot's BHO tool?
Back
Top