Market Chart by jzt11186

VIEWS: 6 PAGES: 16

More Info
									Instructions for Market Chart




             This spreasheet displays 1 month and 1 week charts for major indices, sector SPDR's and Key ETF's




Last Updated: 5/29/06


             Changes: The range of dates automatically skips days when the NYSE is closed.


Requirements:

             XLQPlus and Excel for Windows

Operation:


             No required inputs. The flow of data from each online portal depends on the condition of their servers. Some days
             normally the flow is satisfactory. You can switch between Yahoo and MSN servers by typing in the name in cell I2 a


Maintenance:

             None.

Critical settings:


             The default XLQ source is "MSN".


Tips:

             Let me know if you find bugs. Email: jaa1@cableone.net




             To view the spreadsheet, just click on the "Market Chart" tab at the bottom. It will take you to the active wo
SPDR's and Key ETF's




d.




                                                                                  cell I2
                                             Data Source, either MSN or Yahoo =   yahoo
ondition of their servers. Some days are poor while
vers by typing in the name in cell I2 as shown on the right.




m. It will take you to the active worksheet.
                Thursday, March 17, 2011
                                                                Data Source, either MSN or Yahoo =
                        4 Week Chart
                                     Yahoo symbol ^DJI       ^IXIC   ^GSPC ^NYA        ^RUT
                                        MSN symbol $INDU    $COMPX    $INX    $NYA.X   $RUT.X
                             Date                  ######   #NAME?   ######   ######   ######
-20   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-19   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-18   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-17   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-16   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-15   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-14   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-13   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-12   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-11   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
-10   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
 -9   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
 -8   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
 -7   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
 -6   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
 -5   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
 -4   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
 -3   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
 -2   #NAME?               #NAME?                  ######   #NAME?   ######   ######   ######
 -1     Thu         Thursday, March 17, 2011       ######   #NAME?   ######   ######   ######
  0   TODAY =       Thursday, March 17, 2011




                       1 Week Chart

-5    #NAME?               #NAME?                 ######    #NAME?   ######   ######   ######
-4    #NAME?               #NAME?                 ######    #NAME?   ######   ######   ######
-3    #NAME?               #NAME?                 ######    #NAME?   ######   ######   ######
-2    #NAME?               #NAME?                 ######    #NAME?   ######   ######   ######
-1    #NAME?               #NAME?                 ######    #NAME?   ######   ######   ######
 0      Thu         Thursday, March 17, 2011      ######    #NAME?   ######   ######   ######
        Thu         Thursday, March 17, 2011
her MSN or Yahoo = yahoo

            XLE      XLB      XLF      XLU      XLV      XLI     XLK      XLP      XLY       GLD     RKH       IYT
            XLE      XLB      XLF      XLU      XLV      XLI      XLK     XLP      XLY       GLD     RKH       IYT
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? IYT, Transportation
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME? #NAME?




           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME?    #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME?    #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME?    #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME?    #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME?    #NAME?
           ######   ######   ######   ######   ######   ######   #####   ######   ######   #NAME?   #NAME?    #NAME?
 SMH      BBH      IYR     ^HGX
 SMH      BBH      IYR     $US:HGX.X
#NAME?                     HGX, Philadelphia Housing Index
         #NAME? IYR, Real Estate (REIT's)                    $INDU       #NAME?
#NAME?   #NAME? #NAME? #NAME?                                $COMPX      #NAME?
#NAME?   #NAME? #NAME? #NAME?                                $INX        #NAME?
#NAME?   #NAME? #NAME? #NAME?                                $NYA.X      #NAME?
#NAME?   #NAME? #NAME? #NAME?                                $RUT.X      #NAME?
#NAME?   #NAME? #NAME? #NAME?                                XLE         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                XLB         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                XLF         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                XLU         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                XLV         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                XLI         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                XLK         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                XLP         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                XLY         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                GLD         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                RKH         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                IYT         IYT, Transportation
#NAME?   #NAME? #NAME? #NAME?                                SMH         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                BBH         #NAME?
#NAME?   #NAME? #NAME? #NAME?                                IYR         IYR, Real Estate (REIT's)
#NAME?   #NAME? #NAME? #NAME?                                $us:HGX.x   HGX, Philadelphia Housing Index




#NAME?   #NAME?    #NAME?   #NAME?
#NAME?   #NAME?    #NAME?   #NAME?
#NAME?   #NAME?    #NAME?   #NAME?
#NAME?   #NAME?    #NAME?   #NAME?
#NAME?   #NAME?    #NAME?   #NAME?
#NAME?   #NAME?    #NAME?   #NAME?
lphia Housing Index
                                             #NAME?

                                             #NAME?

                                             #NAME?
                           Indices,
                        Sector SPDR's        #NAME?
                         & Key ETF's         #NAME?

                                             #NAME?

                                             #NAME?
                        Closing Prices
                                             #NAME?
                  Thursday, March 17, 2011
                                             IYT, Transportation

                                             #NAME?

                                             HGX, Philadelphia Housing Index

                 100%


                 90%


                 80%


                 70%


                 60%
Percent Change




                 50%


                 40%


                 30%
20%


10%


0%
      1/0   1/0
                  Date
                #NAME?                                              YAHOO
                                                                    ^DJI
                #NAME?                                              ^IXIC
                                                                    ^GSPC
                #NAME?                                              ^RUT
                                                                    ^NYA
                #NAME?

                #NAME?

                #NAME?

                #NAME?

                #NAME?

                #NAME?

                IYR, Real Estate (REIT's)
                                                                   Reflects Current P
Housing Index
                                                                   Thursday, March 17, 2
                                                       100%



                                                             90%



                                                             80%



                                                             70%



                                                             60%
                                            Percent Change




                                                             50%



                                                             40%



                                                             30%
      20%



      10%



      0%
1/0    #NAME?   #NAME?   #NAME?
         Weekly Change in Indices
         MSN
         $INDU    Dow         #NAME?
         $COMPX   Nasdaq      #NAME?
         $INX     S&P 500     #NAME?
         $RUT.X   Russell 2000#NAME?
         $NYA.X   NYSE        #NAME?




Reflects Current Prices

Thursday, March 17, 2011
#NAME?          #NAME?   #NAME?   Thu
         Date

								
To top