Weekly Update Post: 14th of March to 20th of March

[jamethiel]

seperis has been amazingly busy! We've gotten the scripts and the new individual spreadsheets... sort of up and running, bar testing. lebannen and thexpuzzler, have a look at your sheets but don't touch them yet. We'll give it a day or so to see if things are working, and then we'll start rolling them out to each user. We'll post with an explanation of how to use the new sheets later.

Reminders

1.) March will see the introduction of the ETF and mutual fund.

2.) We will be switching to a new spreadsheet format over the next while. Don't be surprised to see changes in your spreadsheets.

3.) When you are buying, please list the stock you are buying IN ITS ORIGINAL CURRENCY, not your own home currency.

4.) We're going to talk about DIVIDENDS this week! As homework, I want you all to look at the stocks you have. I want you to list any stocks you own that have ever listed dividends, what those dividends were, and a definition of ex-dividend date and how much you would receive if you had ten shares. First five people to comment to this post with that information gets $20 extra dollars towards their monthly total.

If none of your shares have dividends, pick a share from your market that does.


After some thought, the spreadsheet now has an optional box for adding the converted amount, since some of you like to do it yourself. You have to do write in the original currency, but in the other box below it, you can add your conversion.

PUT ONLY NUMBERS IN THOSE BOXES. Use the boxes to declare currency for declaring currency. With only numbers, I can automate the math easier.

New Things

1.) New transaction log. Google has changed their permissions. We're still intending to switch to the new transaction log, but we need a bit more time to futz with permissions.

Transaction Log

Spreadsheet of Transaction Log

Until further notice, please continue to use the old transaction form here. Note: Please put ALL TRANSACTIONS in the log.
Transaction Form

This page is where you can see what you posted.

Transaction Format

We'll probably just keep posting this in every Monday post for easy reference. Remember to note if you already logged in the transaction log or not. Question has been added to each of these.

Buying - Real Time

Format of Declaration to Buy:
Subject Line: "Buy: {Ticker}"
Name: Your Name
Company: Company Name
Ticker: Ticker
Time: In Your Time Zone or in GMT (say which one you're using)
Price: In the Currency the share is listed in
Price (Converted): In Your Currency If You Want to Add That (Optional)
Shares: 5
Country: Your Country
Recorded in Log?: Yes or No

Buying - Automatic

Format of Declaration to Buy, Automatic:
Subject Line: "Automatic Buy: {Ticker}"
Name: Your Name
Company: Company Name
Ticker: Ticker
Time: In Your Time Zone or in GMT (say which one you're using)
Amount: Amount you wish to invest in this stock in your currency
Country: Your Country
Recorded in Log?: Yes or No

Selling

Format of Declaration to Sell:
Subject Line: "Sell: {Ticker}"
Name: Your Name
Company: Company Name
Ticker: Ticker
Time: In Your Time Zone or in GMT (say which one you're using)
Price: In the Currency the share is listed in
Price (Converted): In Your Currency If You Want to Add That (Optional)
Shares: How many shares.
Country: Your Country
Recorded in Log?: Yes or No

For those who still want to do this manually here, these will be added starting March 1, 2011.

Dividend Received
Dividend Reinvestment

Markets

Also will now be listed on every Monday post:

Eligible Exchanges:

1.) NYSE, any version.
2.) Euronext, any version
3.) ASX - Australian Stock Exchange
4.) LSE - London Stock Exchange
5.) TSE - Tokyo Stock Exchange
6.) Hong Kong Stock Exchange
7.) Shanghai Stock Exchange
8.) Toronto Stock Exchange
9.) Deutsche Börse
10.) NASDAQ
11.) Any stock listed in your local market.

These are the exchanges anyone can buy from. As well as these, you can buy from any that are your local markets.

New Things

You are free to buy from any stock exchange in the world starting March 1st; everyone is now familiar with how this works, so I'm letting you run wild. There's a list in everyone's spreadsheet that I'll be updating as I add more. Some aren't normally accessible to westerners, some aren't accessible period, but many are, and Market Roulette is God's Stockbroker; we can get you anything.

Staring July 1st, if you buy from a market that is not one of the above or your local market, an international fee will be assessed at a rate of an additional USD$5.00 per transaction. That'll be out halfway point and when the community as a whole will be asked, encouraged, and required to input on what they like, don't like, and what they want changed.

New Markets

Full list of stock exchanges of the world, sort of.

List of African Stock Exchanges - some of these for reasons beyond my understanding were removed from the main list.

List of Mideast Stock Exchanges - same thing as above.

List of East Asian Stock Exchanges

List of South Asian Stock Exchanges

List of European Stock Exchanges

List of American Stock Exchanges - this includes Central and South America and the Caribbean nations.

List of Market Opening Times


Important Dates

March 1 - transaction fees go into effect. Codicil: I'm going to put up a separate poll about this. Please look for it and respond.

March 1 - all world markets are now up for grabs. Go for it.

March 1 - ETFs and mutual funds are available for buying and selling.

March 1 - Dividend and Reinvest Dividends will come into play.

July 1 - international fees will be assessed when buying outside the top ten or your local markets. More on this later.

Final

As usual, any questions, please leave them here.

Anyone who wants to start using the new individual spreadsheet and start using stock scripts, please email us. We'll be rolling them out gradually, but if you especially want them now, let us know.