{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Definitions","MyInstructions","Main","Summary","Goal","Portfolio","Individual","Individual-NKE","Individual-MUR","Individual-X"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":28,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Definitions","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,2,4]]}
[null,"*All definitions given in context of this workbook. "]
[null,"Definitions"]
[]
[null," ","Word/Phrase","Defnition","Basic Definition/Example"]
[null,1,"Point","If a stock is up two points, then it really means that the stock is up $2. Don't confuse points with percentages when talking about stocks. If a $5 stock rises by $2, it has risen two points. Similarly, if a $50 stock rises by $2, it has also risen two points, although the two-point increase is a much greater percentage change for the $5 stock than for the $50 stock. (http://www.investopedia.com/terms/p/points.asp)","When someone says \"my stock went up 10 points today\", what they mean is that \"my stock went up $10 today. A \"point\" is simply a dollar."]
[null,2,"ROI (Return on Investment)","ROI measures the amount of return on an investment relative to the investment’s cost. (http://www.investopedia.com/terms/r/returnoninvestment.asp)"]
[null,3,"Ticker","A ticker symbol is an arrangement of characters (usually letters) representing a particular security listed on an exchange or otherwise traded publicly. When a company issues securities to the public marketplace, it selects an available ticker symbol for its securities which investors use to place trade orders. (http://www.investopedia.com/terms/t/tickersymbol.asp)","A company's lookup symbol in the stock market. For example Nike's is \"NKE\", American Steel is \"X\", or Exxon Mobile is \"XOM\"."]
[null,4,"Gain","Capital gain is an increase in the value of a capital asset (investment or real estate) that gives it a higher worth than the purchase price. (http://www.investopedia.com/terms/c/capitalgain.asp)","If I spend $10 to buy a stock and the price of that stock fgoes up to $20 per stock then I gain $10 if I sell that stock right now. "]
[null,5,"Loss","The opposite of a \"gain.\"","If I spend $10 to buy a stock and the price of that stock fgoes up to $2 per stock then I lose $8 if I sell that stock right now. "]
[null,7,"Stock/Shares/Equity","A stock is a type of security that signifies ownership in a corporation and represents a claim on part of the corporation's assets and earnings. (http://www.investopedia.com/terms/s/stock.asp)"]
[null,8,"Volume","Volume is the number of shares or contracts traded in a security or an entire market during a given period of time. It is simply the amount of shares that trade hands from sellers to buyers as a measure of activity. If a buyer of a stock purchases 100 shares from a seller, then the volume for that period increases by 100 shares based on that transaction. (http://www.investopedia.com/terms/v/volume.asp)","The amount of shares/stocks traded in a period of time. "]
[null,9,"Open Price","The opening price is the price at which a security first trades upon the opening of an exchange on a given trading day. A security's opening price is an important marker for that day's trading activity, especially for those interested in measuring short-term results, such as day traders. Additionally, securities, which experience very large intra-day gains and losses, will have those swings measured relative to their opening price for the day. (http://www.investopedia.com/terms/o/openingprice.asp)","The price at which a stock is valued at when the stock market opens each day."]
[null,10,"Close Price","The closing price is the final price at which a security is traded on a given trading day. The closing price represents the most up-to-date valuation of a security until trading commences again on the next trading day. (http://www.investopedia.com/terms/c/closingprice.asp)","The price at which a stock is valued at when the stock market closes each day."]
[null,11,"Portfolio","A portfolio is a grouping of financial assets such as stocks, bonds and cash equivalents, as well as their mutual, exchange-traded and closed-fund counterparts. Portfolios are held directly by investors and/or managed by financial professionals. (http://www.investopedia.com/terms/p/portfolio.asp)","Your portfolio consist of the individual stock that you own. "]

{"sheet":"MyInstructions","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"*If you have any questions, please contact me at jedelman18@gmail.com"]
[null,"*Note that you must have a good internet connection because this project relies on scraping data off of Yahoo Finance and StockCharts.com. Also, the ticker names must be valid. "]
[null,"*All buttons are in the \"Stock\" tab in the ribbon above. "]
[null,"*Be sure to click the \"Clear Worksheets\" button in the \"Stock\" tab to clear old worksheets before you click \"Get All Individuals\"."]
[]
[null,"Steps to Get Summary"]
[null,"1 - The column titled \"Ticker\" and highlighted in yellow on the \"Main\" worksheet must be filled out. You can either put one ticker in or more. The rest is optional but recommended. "]
[null,"2 - Once you have filled out the tickers you would like to see information for, click \"Get Summary\". "]
[null,"3 - Wait for the data to be retrieved. The more tickers you put in, the longer it will take. It should take around 30 seconds if you have four or five tickers in the table. DO NOT CLOSE THE INTERNET EXPLORER WINDOW THAT POPS UP. I could have hidden it but chose not to so that the user would know when the program is done running."]
[null,"4 - When it is finished, Internet Explorer will close. If it does not close and \"hangs\" for more than a minute then your internet connection is not good enough. If it does not hang and Internet Explorer has closed then you can look at the \"Summary\", \"Goal\", and \"Portfolio\" tabs to see the results."]
[]
[null,"Steps to Get Individual Information for All Tickers"]
[null,"1 - The column titled \"Ticker\" and highlighted in yellow on the \"Main\" worksheet must be filled out. You can either put one ticker in or more. The other columns are optional but recommended. "]
[null,"2 - Once you have filled out the tickers you would like to see information for, click \"Get Individual Information for All\". "]
[null,"3 - Wait for the data to be retrieved. The more tickers you put in, the longer it will take. It should take around 30 seconds if you have four or five tickers in the table. DO NOT CLOSE THE INTERNET EXPLORER WINDOW THAT POPS UP. I could have hidden it but chose not to so that the user would know when the program is done running."]
[null,"4 - When it is finished, Internet Explorer will close. If it does not close and \"hangs\" then your internet connection is not good enough. If it does not hang and Internet Explorer has closed then you can look at the \"Individual-YourTicker\" worksheets to see the results."]
[]
[null,"Steps to Clear Table"]
[null,"1 - Click \"Clear Table\" and the table will be cleared and ready for you to enter your information into."]
[]
[null,"Steps to Clear Pages"]
[null,"1 - Click \"Clear Pages\" and it will delete all of the extra worksheets that are not colored and are title like \"Individual-X\". "]
[]
[null,"Steps to Get Individual"]
[null,"1 - Write in the single ticker you are interested in and click \"Get Individual Ticker\" in the ribbon. The single ticker is highlighted in green."]
[null,"2 - View the \"Individual\" worksheet for the results."]

{"sheet":"Main","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,2,5],[0,1,0,5]]}
[null,"*Instructions on the MyInstructions Tab"]
[null,"Stock Management"]
[]
[]
[null," ","Company Name","Ticker","Original Investment","Shares Owned"]
[null,1,"Nike","NKE",40,3]
[null,2,"Murphy Oil","MUR",15,7]
[null,3,"American Steel","X",13,9]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[]
[]
[null,"Ticker"]
[null,"NKE"]

{"sheet":"Summary","index":3,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,2,12],[0,1,0,5]]}
[null,"*Green numbers come from the internet whenever the button on the Main tab is clicked."]
[null,"Stock Summary"]
[]
[]
[null," ","Company Name","Ticker","Original Cost","Shares Owned","Current Price","Change in Price","Change in Points","Today's Open Price","Gains/Losses Since Original Purchase","If I Sold Right Now, How Much Would I Get","ROI"]
[null,1,{"$f":"IF(Table1[[#This Row],[Company Name]]=0, \"\",Table1[[#This Row],[Company Name]])","v":"Nike"},{"$f":"IF(Table1[[#This Row],[Ticker]]=0,\"\",Table1[[#This Row],[Ticker]])","v":"NKE"},{"$f":"IF(Table1[[#This Row],[Original Investment]]=0,\"\",Table1[[#This Row],[Original Investment]])","v":40},{"$f":"IF(Table1[[#This Row],[Shares Owned]]=0,\"\",Table1[[#This Row],[Shares Owned]])","v":3},57.92,{"$f":"IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],\"\")","v":17.920000000000002},{"$f":"IF(Table2[[#This Row],[Ticker]]=\"\",\"\",IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],0))","v":17.920000000000002},59.73,{"$f":"IFERROR((Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]])*Table2[[#This Row],[Shares Owned]],\"\")","v":53.760000000000005},{"$f":"IFERROR((Table2[[#This Row],[Original Cost]]+Table2[[#This Row],[Change in Price]])*Table2[[#This Row],[Shares Owned]],\"\")","v":173.76},{"$f":"IFERROR((Table2[[#This Row],[If I Sold Right Now, How Much Would I Get]]-(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]))/(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]), \"\")","v":0.4479999999999999}]
[null,2,{"$f":"IF(Table1[[#This Row],[Company Name]]=0, \"\",Table1[[#This Row],[Company Name]])","v":"Murphy Oil"},{"$f":"IF(Table1[[#This Row],[Ticker]]=0,\"\",Table1[[#This Row],[Ticker]])","v":"MUR"},{"$f":"IF(Table1[[#This Row],[Original Investment]]=0,\"\",Table1[[#This Row],[Original Investment]])","v":15},{"$f":"IF(Table1[[#This Row],[Shares Owned]]=0,\"\",Table1[[#This Row],[Shares Owned]])","v":7},26.31,{"$f":"IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],\"\")","v":11.309999999999999},{"$f":"IF(Table2[[#This Row],[Ticker]]=\"\",\"\",IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],0))","v":11.309999999999999},26.05,{"$f":"IFERROR((Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]])*Table2[[#This Row],[Shares Owned]],\"\")","v":79.169999999999987},{"$f":"IFERROR((Table2[[#This Row],[Original Cost]]+Table2[[#This Row],[Change in Price]])*Table2[[#This Row],[Shares Owned]],\"\")","v":184.17},{"$f":"IFERROR((Table2[[#This Row],[If I Sold Right Now, How Much Would I Get]]-(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]))/(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]), \"\")","v":0.75399999999999989}]
[null,3,{"$f":"IF(Table1[[#This Row],[Company Name]]=0, \"\",Table1[[#This Row],[Company Name]])","v":"American Steel"},{"$f":"IF(Table1[[#This Row],[Ticker]]=0,\"\",Table1[[#This Row],[Ticker]])","v":"X"},{"$f":"IF(Table1[[#This Row],[Original Investment]]=0,\"\",Table1[[#This Row],[Original Investment]])","v":13},{"$f":"IF(Table1[[#This Row],[Shares Owned]]=0,\"\",Table1[[#This Row],[Shares Owned]])","v":9},17.329999999999998,{"$f":"IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],\"\")","v":4.3299999999999983},{"$f":"IF(Table2[[#This Row],[Ticker]]=\"\",\"\",IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],0))","v":4.3299999999999983},16.73,{"$f":"IFERROR((Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]])*Table2[[#This Row],[Shares Owned]],\"\")","v":38.969999999999985},{"$f":"IFERROR((Table2[[#This Row],[Original Cost]]+Table2[[#This Row],[Change in Price]])*Table2[[#This Row],[Shares Owned]],\"\")","v":155.96999999999997},{"$f":"IFERROR((Table2[[#This Row],[If I Sold Right Now, How Much Would I Get]]-(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]))/(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]), \"\")","v":0.33307692307692283}]
[null,4,{"$f":"IF(Table1[[#This Row],[Company Name]]=0, \"\",Table1[[#This Row],[Company Name]])","v":""},{"$f":"IF(Table1[[#This Row],[Ticker]]=0,\"\",Table1[[#This Row],[Ticker]])","v":""},{"$f":"IF(Table1[[#This Row],[Original Investment]]=0,\"\",Table1[[#This Row],[Original Investment]])","v":""},{"$f":"IF(Table1[[#This Row],[Shares Owned]]=0,\"\",Table1[[#This Row],[Shares Owned]])","v":""},0,{"$f":"IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],\"\")","v":""},{"$f":"IF(Table2[[#This Row],[Ticker]]=\"\",\"\",IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],0))","v":""},0,{"$f":"IFERROR((Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[Original Cost]]+Table2[[#This Row],[Change in Price]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[If I Sold Right Now, How Much Would I Get]]-(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]))/(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]), \"\")","v":""}]
[null,5,{"$f":"IF(Table1[[#This Row],[Company Name]]=0, \"\",Table1[[#This Row],[Company Name]])","v":""},{"$f":"IF(Table1[[#This Row],[Ticker]]=0,\"\",Table1[[#This Row],[Ticker]])","v":""},{"$f":"IF(Table1[[#This Row],[Original Investment]]=0,\"\",Table1[[#This Row],[Original Investment]])","v":""},{"$f":"IF(Table1[[#This Row],[Shares Owned]]=0,\"\",Table1[[#This Row],[Shares Owned]])","v":""},0,{"$f":"IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],\"\")","v":""},{"$f":"IF(Table2[[#This Row],[Ticker]]=\"\",\"\",IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],0))","v":""},0,{"$f":"IFERROR((Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[Original Cost]]+Table2[[#This Row],[Change in Price]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[If I Sold Right Now, How Much Would I Get]]-(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]))/(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]), \"\")","v":""}]
[null,6,{"$f":"IF(Table1[[#This Row],[Company Name]]=0, \"\",Table1[[#This Row],[Company Name]])","v":""},{"$f":"IF(Table1[[#This Row],[Ticker]]=0,\"\",Table1[[#This Row],[Ticker]])","v":""},{"$f":"IF(Table1[[#This Row],[Original Investment]]=0,\"\",Table1[[#This Row],[Original Investment]])","v":""},{"$f":"IF(Table1[[#This Row],[Shares Owned]]=0,\"\",Table1[[#This Row],[Shares Owned]])","v":""},0,{"$f":"IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],\"\")","v":""},{"$f":"IF(Table2[[#This Row],[Ticker]]=\"\",\"\",IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],0))","v":""},0,{"$f":"IFERROR((Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[Original Cost]]+Table2[[#This Row],[Change in Price]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[If I Sold Right Now, How Much Would I Get]]-(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]))/(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]), \"\")","v":""}]
[null,7,{"$f":"IF(Table1[[#This Row],[Company Name]]=0, \"\",Table1[[#This Row],[Company Name]])","v":""},{"$f":"IF(Table1[[#This Row],[Ticker]]=0,\"\",Table1[[#This Row],[Ticker]])","v":""},{"$f":"IF(Table1[[#This Row],[Original Investment]]=0,\"\",Table1[[#This Row],[Original Investment]])","v":""},{"$f":"IF(Table1[[#This Row],[Shares Owned]]=0,\"\",Table1[[#This Row],[Shares Owned]])","v":""},0,{"$f":"IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],\"\")","v":""},{"$f":"IF(Table2[[#This Row],[Ticker]]=\"\",\"\",IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],0))","v":""},0,{"$f":"IFERROR((Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[Original Cost]]+Table2[[#This Row],[Change in Price]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[If I Sold Right Now, How Much Would I Get]]-(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]))/(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]), \"\")","v":""}]
[null,8,{"$f":"IF(Table1[[#This Row],[Company Name]]=0, \"\",Table1[[#This Row],[Company Name]])","v":""},{"$f":"IF(Table1[[#This Row],[Ticker]]=0,\"\",Table1[[#This Row],[Ticker]])","v":""},{"$f":"IF(Table1[[#This Row],[Original Investment]]=0,\"\",Table1[[#This Row],[Original Investment]])","v":""},{"$f":"IF(Table1[[#This Row],[Shares Owned]]=0,\"\",Table1[[#This Row],[Shares Owned]])","v":""},0,{"$f":"IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],\"\")","v":""},{"$f":"IF(Table2[[#This Row],[Ticker]]=\"\",\"\",IFERROR(Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]],0))","v":""},0,{"$f":"IFERROR((Table2[[#This Row],[Current Price]]-Table2[[#This Row],[Original Cost]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[Original Cost]]+Table2[[#This Row],[Change in Price]])*Table2[[#This Row],[Shares Owned]],\"\")","v":""},{"$f":"IFERROR((Table2[[#This Row],[If I Sold Right Now, How Much Would I Get]]-(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]))/(Table2[[#This Row],[Shares Owned]]*Table2[[#This Row],[Original Cost]]), \"\")","v":""}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,Table2[Original Cost])","v":68},{"$f":"SUBTOTAL(109,Table2[Shares Owned])","v":19},null,{"$f":"SUBTOTAL(109,Table2[Change in Price])","v":33.56},{"$f":"SUBTOTAL(109,Table2[Change in Points])","v":33.56},null,{"$f":"SUBTOTAL(109,Table2[Gains/Losses Since Original Purchase])","v":171.89999999999998},{"$f":"SUBTOTAL(109,Table2[If I Sold Right Now, How Much Would I Get])","v":513.89999999999986}]

{"sheet":"Goal","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,2,8],[0,1,0,8]]}
[null,"*Can change the goal amount by changing cell C6. "]
[null,"Goal Check"]
[]
[]
[null," ","Value"]
[null,"Goal:",600]
[null,"Where I'm At:",{"$f":"SUM(Summary!K6:K13)","v":171.89999999999998}]
[]
[null,"% Achieved",{"$f":"C7/C6","v":0.28649999999999998}]

{"sheet":"Portfolio","index":5,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,2,7]]}
[]
[null,"Breakdown Chart"]
[]
[]
[null,"Company Name","Company Ticker","Original Cost ","Current Price","Shares Owned","Original Total","Current Total"]
[null,{"$f":"Summary!C6","v":"Nike"},{"$f":"Summary!D6","v":"NKE"},{"$f":"Summary!E6","v":40},{"$f":"IF(Summary!H6=\"\",\"\",Summary!G6)","v":57.92},{"$f":"Summary!F6","v":3},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Original Cost ]],\"\")","v":120},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Current Price]],\"\")","v":173.76}]
[null,{"$f":"Summary!C7","v":"Murphy Oil"},{"$f":"Summary!D7","v":"MUR"},{"$f":"Summary!E7","v":15},{"$f":"IF(Summary!H7=\"\",\"\",Summary!G7)","v":26.31},{"$f":"Summary!F7","v":7},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Original Cost ]],\"\")","v":105},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Current Price]],\"\")","v":184.17}]
[null,{"$f":"Summary!C8","v":"American Steel"},{"$f":"Summary!D8","v":"X"},{"$f":"Summary!E8","v":13},{"$f":"IF(Summary!H8=\"\",\"\",Summary!G8)","v":17.329999999999998},{"$f":"Summary!F8","v":9},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Original Cost ]],\"\")","v":117},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Current Price]],\"\")","v":155.96999999999997}]
[null,{"$f":"Summary!C9","v":""},{"$f":"Summary!D9","v":""},{"$f":"Summary!E9","v":""},{"$f":"IF(Summary!H9=\"\",\"\",Summary!G9)","v":""},{"$f":"Summary!F9","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Original Cost ]],\"\")","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Current Price]],\"\")","v":""}]
[null,{"$f":"Summary!C10","v":""},{"$f":"Summary!D10","v":""},{"$f":"Summary!E10","v":""},{"$f":"IF(Summary!H10=\"\",\"\",Summary!G10)","v":""},{"$f":"Summary!F10","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Original Cost ]],\"\")","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Current Price]],\"\")","v":""}]
[null,{"$f":"Summary!C11","v":""},{"$f":"Summary!D11","v":""},{"$f":"Summary!E11","v":""},{"$f":"IF(Summary!H11=\"\",\"\",Summary!G11)","v":""},{"$f":"Summary!F11","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Original Cost ]],\"\")","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Current Price]],\"\")","v":""}]
[null,{"$f":"Summary!C12","v":""},{"$f":"Summary!D12","v":""},{"$f":"Summary!E12","v":""},{"$f":"IF(Summary!H12=\"\",\"\",Summary!G12)","v":""},{"$f":"Summary!F12","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Original Cost ]],\"\")","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Current Price]],\"\")","v":""}]
[null,{"$f":"Summary!C13","v":""},{"$f":"Summary!D13","v":""},{"$f":"Summary!E13","v":""},{"$f":"IF(Summary!H13=\"\",\"\",Summary!G13)","v":""},{"$f":"Summary!F13","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Original Cost ]],\"\")","v":""},{"$f":"IFERROR(Table4[[#This Row],[Shares Owned]]*Table4[[#This Row],[Current Price]],\"\")","v":""}]

{"sheet":"Individual","index":6,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,2,13]]}
[]
[null,"Individual Stock Summary"]
[]
[]
[null," ","Results"]
[null,"Ticker","NKE"]
[null,"Price Today",57.92]
[null,"Today's Low",57.82]
[null,"Today's High",59.78]
[null,"Previous Close",59.42]
[null,"Today's Open",59.73]
[null,"52 Week High",68.2]
[null,"52 Week Low",47.25]
[null,"Volume","12.6m"]
[null,"Avg. Volume","10.5m"]

{"sheet":"Individual-NKE","index":7,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,1,13]]}
[null,"Individual Stock Summary"]
[]
[]
[null," ","Results"]
[null,"Ticker","NKE"]
[null,"Price Today",57.92]
[null,"Today's Low",57.82]
[null,"Today's High",59.78]
[null,"Previous Close",59.42]
[null,"Today's Open",59.73]
[null,"52 Week High",68.2]
[null,"52 Week Low",47.25]
[null,"Volume","12.6m"]
[null,"Avg. Volume","10.5m"]

{"sheet":"Individual-MUR","index":8,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,1,13]]}
[null,"Individual Stock Summary"]
[]
[]
[null," ","Results"]
[null,"Ticker","MUR"]
[null,"Price Today",26.31]
[null,"Today's Low",25.91]
[null,"Today's High",26.93]
[null,"Previous Close",25.69]
[null,"Today's Open",26.05]
[null,"52 Week High",50.79]
[null,"52 Week Low",14.3]
[null,"Volume","4m"]
[null,"Avg. Volume","5.7m"]

{"sheet":"Individual-X","index":9,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,1,13]]}
[null,"Individual Stock Summary"]
[]
[]
[null," ","Results"]
[null,"Ticker","X"]
[null,"Price Today",17.329999999999998]
[null,"Today's Low",16.54]
[null,"Today's High",17.71]
[null,"Previous Close",16.510000000000002]
[null,"Today's Open",16.73]
[null,"52 Week High",27.68]
[null,"52 Week Low",6.15]
[null,"Volume","16.1m"]
[null,"Avg. Volume","15.8m"]