market_roulette | admin: january 3, 2011, game on

ETA: All new transactions should be recorded in the new Monday post for this week.

So we'll do this in order:

Individual Page

You should have received an email from googledocs with a link to your individual spreadsheet. ETA: Changing this: email market.roulette when you see this. Some of the email I have are bouncing anyway, so might as well start over. Email with your email address in the body.

Model Spreadsheet

This is what it will look like. Please see the tabs at the bottom:

Summary - that's the first page and where you will record your data. Instructions are in red.
Converter - do not change anything here. This has a currency and stock converter. Instructions are also written to use them.
DataSheetRO - do not change anything here. That page holds the data to make the converter work. You'll be replacing this page regularly for updated data. It'll be easy to do. It also has the current stock list, which is why this page will undergo regular updating and replacing.

At some point this month, I'll add a data sheet that will be locked for me to record your data on so you can compare. And I may add other pages; it's very convenient.

Individual Page - Usage

First, formatting:

1.) Go to File -> Spreadsheet Settings.
2.) Change your locale and timezones.
3.) Email me when you've done this so I can adjust some of the formulas.

Then, individualizing.

1.) Enter your individual information on row five.
2.) Recolor the entire thing however you want. Just don't move or rename anything without checking in with me.

Now, explanation:

Summary is your records. You enter your transactions at the bottom under Transactions. I'll add the macros for it to be fed to the top portion when you've made your first buy.

Converter is a quick and dirty currency and stock price converter. This page and DataSheetRO will pretty much be under constant fixing and tweaking, as google functions are sometimes like Excel and sometimes not so much.

DataSheetRO is where all the raw data is stored.

StockList - if you don't have it, just wait. I'm working with google for copying sheets to other workbooks. It's a copy for you to edit of all the stocks available, if you want to make notes, etc. There's a google function that gives quotes as of 20 minutes ago--this is using that.

And that about covers it.

Monday Post

This is the first Monday post of gameplay.

1.) If you buy, sell, or do any stock transactions, post a comment here.

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 Your Country's Currency
Shares: 5
Country: Your Country

Use the same format for sells.

2.) International Players - January Monthly Conversion Amount

ETA: All of this with data tables can be found here, along with the Daily Conversion and the Hourly Conversion amounts. Hourly is in yellow.

December's average conversion:

Australia, Dollar - 1.009110 per US Dollar
Canada, Dollar - 1.009445 per US Dollar
EU, Euro - .756842 per US Dollar
Hong Kong, Dollar - 7.774429 per US Dollar
Japan, Yen - 83.39332 per US Dollar
Singapore, Dollar - 1.307674 per US Dollar
United Arab Emirates, Dirham - 3.6736806
UK, Pounds Sterling - .640839 per US Dollar

Your January Amount in Your Currency:

Australia, Dollar - 151.3679
Canada, Dollar - 151.4168
EU, Euro - 113.5263
Hong Kong, Dollar - 1166.164
Japan, Yen - 12509
Singapore, Dollar - 196.1511
United Arab Emirates, Dirham - 551.0521
UK, Pounds Sterling - 96.12581

Verification: Historical Rates

3.) International Players - Other Conversions

All amounts are shown here. And I do not know what google is doing with the dirham's symbol, but seriously, it needs to stop now.

And that's it. Questions, remarks, problems, please leave a comment and put in the subject line Question, Remark, Problem, etc for sorting purposes.

Happy playing!

ETA:

All new transactions should be recorded in the new Monday post here. Do not record any further transactions in this post.

Page 2 of 2 << [1] [2] >>

Flat | Top-Level Comments Only

From:

calligrafiti

Name: Calligrafiti
Company: Rediff
Ticker: REDF
Time: 9:12 pm EST
Price: 5.27
Shares: 15
Country: USA

Also, sorry, but I haven't received an email with a link to an individual spreadsheet. I did email as directed Monday, but it sounds like googledocs is being a little problematic, so that may be why I haven't seen it. Anyway, I thought I'd mention it here in case my email didn't make it through. Thanks!

jamethiel

Thank you for mentioning it. (google ate your mail. Google makes me sad).

I sent you a link just now, and I'm recording your transaction!

thexpuzzler

Name: thexpuzzler
Company: Company Name
Ticker: 531370/AFX
Time: 13:07
Price: 14,37€
Shares: 4
Country: Germany

(I'm sorry I'm pretty sure I got the ticker code wrong, somehow I couldn't really find the ticker on two different sites I checked and the third one only had this one? I fail!)

That's ok! If you can us the company name, we'll search for it. It may be one of the ones from your very restricted local market.

eeeh, I just realized I forgot to C&P the name here, I put it in my spreadsheet instead *headdesk*
eh, it's Carl Zeiss Meditec AG. so sorry.

Re: Buy: 531370/AFX

jamethiel - Date: 2011-01-06 12:55 pm (UTC) - Expand

thexpuzzler - Date: 2011-01-06 01:17 pm (UTC) - Expand

Name: thexpuzzler
Company: NET SERVICOS PFD
Ticker: NS2B
Time: 15:01
Price: 10,29€
Shares: 5
Country: Germany

(So I spent the last hour or so doing research and I read a lot about this being a good investment - it's Brazilian though, so I hope it's still ok to buy this? I'm just trying stuff out :D Hope that's okay!)

OK. Recorded. Again, it doesn't seem to be one that google can automatically update so I'll go in and check it once a day. Also, if you could please update the reference stocks sheet with what they do? While i can understand a little French, German is beyond my capabilities.

seperis

It'll be one of these three.

NS2B.DE GER
NS2B.F FRA
NS2B.BE BER

Default to the .BE on any German stock with one of those. If I can be on tonight, I'll go over how to figure out if a stock needs a suffix.

Oh, I think this one would be the same for all markets. I must have been wrong *facepalm*

I'll update the sheet! :)

NS2B.DE GER
NS2B.F FRA
NS2B.BE BER

Which exchange are you using? You're eligible for all of these, btw, so it won't make any diff but in accuracy. Do me a favor; when you record from any of your markets, put in the exchange you got it on? There are seven or eight in Germany plus Xetra (that's the .DE one on the GER exchange).

I think I got the one from Frankfurt Börse or Deutsche Börse, which would make it a .DE. But this is really strange though, I can't actually find any data on there that is more recent than 10:30 or so - is that normal? I'm very confused because the google one apparently stopped tracking this like, half a year ago?
And then there's this which says there was never any time where it was 10.29 as I recorded it that time (but why would I have recorded it like that if it didn't exist? :D)

Maybe I should take this one back too and stick to some safe choice *dies* I am so sorry about this! (I really thought this would be a good choice, it's like one of the most popular TV cable and internet broadband providers in Brazil. Hmmmm...)

Very confusing.

Re: Buy: NS2B

seperis - Date: 2011-01-07 06:34 pm (UTC) - Expand

thexpuzzler - Date: 2011-01-07 07:17 pm (UTC) - Expand

Name: jamethiel
Company: THe Reject Shop
Ticker: TRS.AX
Time: 11:39
Price: $12.81
Shares: 4
Country: Australia

Edited Date: 2011-01-07 12:39 am (UTC)

Recorded

snowynight

Name: snowynight
Company: Rediff.com India Limited (ADR)
Ticker: REDF
Time: 6:33 GMT
Price: HKD 5.57
Shares: 40
Country: China

Hi! The price of this is actually in US dollars. So converted to HKD, it's $43.29.

Just a reminder that this transaction and the next transaction have to fit into your monthly account limit of $150 US/ $1166.16 Hong Kong. If you wouldn't mind looking at the three account transactions you have and working out what you can fit in your monthly allowance.

Sorry.
I would change it to 10 shares now.

Re: Subject Line: "Buy: REDF"

jamethiel - Date: 2011-01-10 12:55 am (UTC) - Expand

Name: snowynight
Company: Sims Metal Management Ltd (ADR)
Ticker: SMS
Time: 6:39 GMT
Price: HKD 21.25
Shares: 25
Country: China

I would change it to 1 share

Re: BUY: SMS

spn_girl

Format of Declaration to Buy:
Subject Line: "Buy: {Ticker}"
Name: spn_girl
Company: Robust Resources Ltd
Ticker: ROL.AX
Time: 11.06am my time
Price: $1.765
Shares: 28
Country: Australia

(sorry there is a bit of a delay on the time - I'm at work and I was half way through filling this in and had to go and serve a customer, by the time I got back half an hour later the price had gone up a cent :( is it still okay to put it through at the price I started to buy at?)

oops, for got to delete the first couple of lines there....

No worries, I trust you *g*

This is recorded.

Re: buy ROL.AX

spn_girl - Date: 2011-01-10 01:13 am (UTC) - Expand

Name: Spn_girl
Company: Metminco
Ticker: MNC.AX
Time: 13.08 my time
Price: 0.42
Shares: 88
Country: Australia

Recorded.

BLD.AX please change quantity of shares to 8

Done!

admin: january 3, 2011, game on

Page Summary

Style Credit

Expand Cut Tags