admin: january 3, 2011, game on
Jan. 2nd, 2011 11:30 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
seperis posting in ![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png){kind=small}
market_rouletteETA: 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:
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.
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.
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.
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.
no subject
Date: 2011-01-04 04:29 am (UTC)(email to market.roulette at gmail dot com )
no subject
Date: 2011-01-04 04:31 am (UTC)Re: Buy: BLD.AX
Date: 2011-01-04 04:51 am (UTC)Re: Buy ATP.AX
Date: 2011-01-04 04:52 am (UTC)BUY: ECA
Date: 2011-01-04 04:57 am (UTC)Company: Encana
Ticker: ECA
Time: 11:57 Eastern Time
Price: $29.83 USD
Shares: 2
Country: USA
Re: BUY: ECA
Date: 2011-01-04 04:58 am (UTC)Thanks!
BUY: F
Date: 2011-01-04 05:04 am (UTC)Company: Ford
Ticker: F
Time: 11:58 Eastern Time
Price: $17.25 USD
Shares: 2
Country: USA
Automatic Buy: GE
Date: 2011-01-04 05:09 am (UTC)Company: General Electric
Ticker: GE
Time: Central US
Amount: $50
Country: USA
Automatic Buy: KFT
Date: 2011-01-04 05:10 am (UTC)Company: Kraft
Ticker: KFT
Time: Central US
Amount: $90
Country: USA
Re: BUY: ECA
Date: 2011-01-04 05:20 am (UTC)Re: BUY: F
Date: 2011-01-04 05:20 am (UTC)BUY: GE
Date: 2011-01-04 05:27 am (UTC)Company: General Electric
Ticker: F
Time: 12:27AM Eastern Time
Price: $18.28 USD
Shares: 2
Country: USA
Buy: CNG
Date: 2011-01-04 06:55 am (UTC)Company: China Natural Gas
Ticker: CNG
Time: 6:53 GMT
Price: $0.065
Shares: 666
Country: China
Re: BUY: GE
Date: 2011-01-04 07:52 am (UTC)Also, let me know if you didn't mean GE here and accidentally typed F as the ticker instead?
Re: Buy: CNG
Date: 2011-01-04 08:07 am (UTC)I think you just got the ticker wrong and then the companies confused. Do you still want to buy CHNG, and if so, how much?
Re: BUY - ATP.AX
Date: 2011-01-04 04:10 pm (UTC)BUY: REDF
Date: 2011-01-04 06:27 pm (UTC)Company: Rediff
Ticker: REDF
Time: 12:18 US Central
Price: $5.05
Shares: 100
Country: United States
BUY: ATP.AX
Date: 2011-01-04 06:33 pm (UTC)Company: Atlas South Sea Pearls
Ticker: ATP.AX
Time: 12:20 US Central
Price: $0.12
Shares: 400
Country: United States
Re: BUY: REDF
Date: 2011-01-04 06:36 pm (UTC)Re: BUY: GE
Date: 2011-01-05 01:10 am (UTC)I got a little too happy with the copy / paste, you are correct on the assumption it should be GE. And thanks for catching my math error and applying the gameplay credit, when I punched the amounts in the spreadsheet I thought my balance was positive. I've truncated the balance figure to 2 decimal places so the negative will be obvious. Because I obviously, like, need that.... Let me know if that's ok.
THANKS!
Re: BUY: GE
Date: 2011-01-05 01:26 am (UTC)(The Total left is something I did on the fly, so it's a bit inconsistent from spreadsheet to spreadsheet.We may need to go through and standardise the spreadsheets. Oops!)
Re: BUY: REDF
Date: 2011-01-05 01:31 am (UTC)no subject
Date: 2011-01-05 01:32 am (UTC)Company: Ocado Group PLC
Ticker: OCDO.L
Time: ? See below
Price: £1.967
Shares: 15
Country: UK
Time: So the market is closed here, do I give you the closing time, which is 04/1629, or tomorrow's opening time, which will be 05/0800? Or do I have to wait until I get to the computer tomorrow, by which time the price may have done something else, as it's being a teensy bit volatile at the moment?
Buy: BLD
Date: 2011-01-05 01:51 am (UTC)Company: Boral Limited
Ticker: BLD
Time: My Time Zone - 12.50pm, 05/01/2011
Price: AUD $4.850
Shares: 8
Country: Australia
Note - Free transaction, so total cost should be AUD $38.80
Buy: ANN
Date: 2011-01-05 01:52 am (UTC)Company: Ansell Limited
Ticker: ANN
Time: My Time Zone - 12.51pm, 05/01/2011
Price: AUD $12.75
Shares: 4
Country: Australia
Note - $7 transaction, so total cost should be AUD $58.00