Scottrade Online Proxy Voting While Logged In

A few moments ago, I was looking for Scottrade Online Proxy Voting. That's what I call it. Scottrade calls it Shareholder Notifications.

I remembered there was a way vote to your shares while logged into Scottrade. I just could not remember how to do it. I'm writing about it now so that I will have something to remind me should I forget again.

Here's the steps I took:

1. I signed into my Scottrade account
2. Once logged in, I noticed that I was on the Home tab at the top of the page.
3. I also noticed that the My Account tab is the third tab and the Home Tab is the first tab.
4. At the top of the page, I chose the My Account Tab
5. Once on the My Account page, I noticed sidebar navigation on the left side of the page. The navigation elements are stacked on top of each other running down the left side of the page.
6. I noticed that I was on the Balances navigation element on the left side of the page. Balances is the topmost navigation element.
7. The second navigation element is Positions. Positions is the next element underneath Balances.
8. I chose the Balances navigation element which takes me to the Balances page.
9. Once on the Balances page, I noticed that I have a whole new set of tabs at the top of the page. There are 4 tabs total on the Balances page.
10. I chose the right-most tab, the 4th tab. This tab is called Shareholder Notifications
11. The Shareholder Notifications page allows me to vote my shares in the upcoming shareholder annual meeting

It's not particularly hard voting my shares at Scottrade. Nor it is hard keeping up with shareholder notifications in general. The hardest part for me is remember how I did it the last time I did it.

Ed Abbott

Exporting Scottrade Buy/Sell Transactions to a Spreadsheet

This morning, I was trying to remember how to export transactions in my Scottrade account to a spreadsheet. I recalled having done this before.

I found this page which confirmed for me that I am correct in thinking that this can be done

Transaction History

Here are the steps I followed to export my buy and sell orders to an Excel spreadsheet:

1. Log in to your account
2. Choose the My Account tab at the top of the page
3. Choose Account History from the menu on the left side of the page
4. Allow the Transactions tab to continue to be the default choice at the top of the page
5. Find the dates pull-down menu that has a date range, such as Last 7 Days
6. Change the pull-down menu to Select Dates
7. Choose a date range to the right of the pull-down menu
8. Immiediately below the date range pull-down menu is is another pull-down menu called Transactions. Change this pull-down menu from All Types to Trades if you do not wish to be swamped with data
9. Immediately to the right of the Transactions menu is a Security Type menu. With this menu you should be able to differentiate between Stocks or Options or other security types. Use this menu to further filter your data.
10. Press the Go button
11. All date-range transactions will appear on your screen
12. If you prefer chronological order over reverse chronological order clicking on Date at the top left-hand corner of the heading for all transactions does nothing to alter the saved spreadsheet. Sorry!
13. When all your transactions appear on the screen, press the Export to Excel button in the bottom left-hand corner just below your transactions
14. Use your favorite utility to translate all transactions from reverse chronological order to chronological order. For Linux users, the Unix tac command works. Sorry. I don't know what to suggest for Windows users or for users on other platforms.
15. If you do decide to reverse the chronology of the transactions, you might want to put the heading back on the first line of the file. Reversing the chronology of transactions moves the heading to the last line of the file.
16. To place the heading back on the first line of the CSV file, use your favorite text editor. I use Vim, but you might but you might prefer Notepad under Windows or whatever text editor you like to use under your favorite operating system
17. Examine the CSV file for transactions you have no interest in with a text editor. Many transactions are pure Cash transactions with Cash as the stock symbol. You may wish to eliminate these to eliminate excess clutter in your transaction data. See above step where you choose what kind of data you want via the Transactions pull-down menu for a better way to eliminate extraneous data. If you are not able to eliminate data with the Transactions pull-down menu, you can always do it now with a text editor.

Once the spreadsheet has been exported, you'll find that the filename includes a timestamp in YY-MM-DD-HH-MM-SS format.

It occurs to me that the spreadsheet file can really be imported into any spreadsheet. I just looked at the file and it is a CSV file which is comma separated values. In other words, the file is not exclusively an Excel spreadsheet file. It is really a file that is compatible with any spreadsheet.

Here's a Wikipedia article on CSV files if you are interested and want to know more:

Comma-separated values

Ed Abbott