Now “Save” your file somewhere you can easily find it later, you’ve got some data! Getting Historical Prices For Stocks (Copy And Pasting Data In To A Spreadsheet)įor this example, we want to get the historical prices for a stock so we can look at how the price has been moving over time. This will add a new row to the top of the spreadsheet where you can type in the column names. If the column headings are not included, right-click the first row and select “Insert Row”. The column headings should be included too. You can then right-click and “Paste” the data in. Next, open up a new blank spreadsheet and click cell A1. Highlight the information you want, then right click and “Copy”. This will open up a small window showing what your portfolio value was for every day of the contest. You can find these on the “ Graph My Portfolio” page.
To get your old portfolio values, you can copy and paste them out of the HTMW website.įirst, you will need to get your historical portfolio values from the HTMW website. Some of it we will need to write down, some can be copied and pasted, and some we can download directly as an excel file. Using Excel To Track Your Stock Portfolio – Getting Some Dataīefore we can do anything with Excel, we need to get some numbers! The information you use in excel is called “Data”. In this article we will be looking at how you can use Excel with your HTMW account to keep track of your account’s performance.
