off topic - anyone good with EXCEL?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • lil2rich4u2
    ICQ: 175171926
    • Oct 2002
    • 11046
    #1

    off topic - anyone good with EXCEL?

    i need help before my accountant kills me!!

    i need to make a spreadshet for trades, and im stuck on my P&L cell.

    here is my cell assignments ...

    E2 = POSITION
    F2 = BUY PRICE (per share)
    G2 = SELL PRICE (per share)
    H2 = COMMISSION

    what i need (without the excel code) is this: (((E2*G2)-(E2*F2))-H2)

    i cant get it to work for anything! so let me step it out and maybe someone can help ...

    step 1: PRODUCT(E2*G2)
    step 2: PRODUCT(E2*F2)
    step 3: SUM(step1 - step2)
    step 4: SUM(step3 - H2)

    total should be total profit or loss.

    i know this is off topic, just hoping someone here can ehlp me! im really in a bind ...

    here is a recent trade i made inside the workbook ...

    CLICK HERE TO SEE WORKBOOK
    HEY!!

    Unbeatable hosting! Customer service is top notch!

    --> ISPrime <-- Do a search on any board, their reputation is rock solid .. for years!!
    Tags: None
    • lil2rich4u2
      ICQ: 175171926
      • Oct 2002
      • 11046
      #2
      ahh n/m i got it now, thanks !
      HEY!!

      Unbeatable hosting! Customer service is top notch!

      --> ISPrime <-- Do a search on any board, their reputation is rock solid .. for years!!

        Comment

        • Manansala
          Confirmed User
          • Jan 2005
          • 551
          #3
          Good thing your accountant didn't kill you. Hehehe
          I don't have a signature. !

            Comment

            • Phoenix
              BACON BACON BACON
              • Nov 2002
              • 35475
              #4
              list some stocks you are watching please
              Telegram PhoenixBrad
              https://quantads.io

                Comment

                • lil2rich4u2
                  ICQ: 175171926
                  • Oct 2002
                  • 11046
                  #5
                  Originally posted by Phoenix
                  list some stocks you are watching please
                  My small list of keepers: HDI CNC GOOG EBAY YHOO SBUX SIRI XMSR

                  My big list of daytraders ... ill pick one or 2 of these each day to play, depending on conditions:

                  ACKHQ ADBL ADSX AIRT AIS ALTI AMKR ANGO ANTP ARDM ASFI AXYX BCON
                  BIOM BIZ BKYI CAU CDSS CMTN CPTC CPTH DANKY DCAI DDDC DFIB DHC DOC
                  DRIV DRRA EAG ECGID EGHT EMIS ENER EVST EXAS EZPW FDEI FLWE FMDAY
                  FNGC FNIX FORD FRD FRDMQ GALB GFCI GMTN GNVC GRA GRU GTCB GTEL HANS
                  HIET HOFF HOMS IBIS ICOR IFLB IIJI IMMU INMD INMTQ INTZ ISPH ITEC
                  JMAR KKD LVLT MAXM MBAH MBAY MBEU MCLD MDKI MIKR MIX MOBL NANX NAPS
                  NGPS NNPP NSI NSOL NTOP NTPA OMOG OWENQ PARS PAX PLAY PPHM RECM RMKR
                  RURL SCON SFP SGU SHRN SIPX SMSI SQNM SRXA SSPI SVNT SWYC SYNA TFS
                  TKO TMWD TRIN TRPH TSYS TWRAQ UBET ULTEQ USTT VDWBE VIAC VRSO VXGN
                  WGAT WIN WPTE WTSLA YAKC
                  HEY!!

                  Unbeatable hosting! Customer service is top notch!

                  --> ISPrime <-- Do a search on any board, their reputation is rock solid .. for years!!

                    Comment

                    • lil2rich4u2
                      ICQ: 175171926
                      • Oct 2002
                      • 11046
                      #6
                      i took a HUGE loss recently ...

                      i enterred TWR a swing trade at $1.08 for 7000 shares

                      by 2nd morning it declared BK and they locked trading, when it opened, it was below a penny and went up a bit, i ended up selling it all for .28

                      OMFG !!!!

                      i guess it happens right? just wish i didnt become a statistic on that one, lol

                      oh well .. ill make it back
                      HEY!!

                      Unbeatable hosting! Customer service is top notch!

                      --> ISPrime <-- Do a search on any board, their reputation is rock solid .. for years!!

                        Comment

                        • Phoenix
                          BACON BACON BACON
                          • Nov 2002
                          • 35475
                          #7
                          shit i know...you can swing all over the [;ace//i have a friend that lost a fortune recently

                          id be crying..he takes it in stride though

                          i used to daytrade alot but i found the fees to high

                          now i can afford to do bigger trades...im trying to find roughly ten stocks to buy and sell weekly so i can make 60-90 bucks on each one..nothing crazy, just steady and easy charting
                          Telegram PhoenixBrad
                          https://quantads.io

                            Comment

                            • Spunky
                              I need a beer
                              • Jun 2002
                              • 133978
                              #8
                              I think I opened that program once

                                Comment

                                Previous template Next
                                Working...