{"product_id":"v2083compric","title":"V. 20:10 (83-84): Computing The Price Regression Line (PRL) Using Excel by W.G.S. Brown","description":"Computing The Price Regression Line (PRL) Using Excel by W.G.S. Brown\u003cbr\u003e\u003cbr\u003eApproach: First download into a spreadsheet the historical data for the base index (usually the S\u0026amp;P 500) and data for one or more funds\/stocks\/indexes that you want to analyze (sidebar Figure 1). Set up a template for the calculations, then copy the data into the template to\nevaluate the price regression line (PRL) and how well the prices follow the index. I have used limited data here to make it easy for you to verify that you have set up the spreadsheet correctly. These steps apply to Internet\nExplorer 6 and Excel 2000. Internet Explorer 6 puts the data directly into a temporary spreadsheet when downloaded, while version 5+ saves it to a comma-separated file, *.csv, which means you have to import it as a separate step.","brand":"store-traders-com","offers":[{"title":"Default Title","offer_id":52133919949169,"sku":"\\V20\\C10\\117sb.pdf","price":2.95,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0900\/3843\/6209\/files\/unnamed_746fc794-0cab-469e-90e9-06887da5125d.jpg?v=1739657327","url":"https:\/\/shop.traders.com\/products\/v2083compric","provider":"Stocks \u0026 Commodities","version":"1.0","type":"link"}