![[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_rouletteJust in case anyone forgot, January is basically everyone's Mistakes Month and adaptation month. All mistakes with transactions, stock, money will be fixed with no penalty. If you make a mistake, if we make a mistake, it'll be reversed and fixed. I kind of saw this coming when I was working in googledocs and it kept converting everything to euros for like, two days.
So again, this month, you can do it wrong, and you can reverse anything you do. Just comment in the same thread that whatever you did that needs changing/fixing. This month, there is no limit to this, so you won't be bothering us. By the end of the month, I want everyone comfortable with the procedure.
Conversions
We're still working on accurate conversions; googledocs formulas seem to be off. So don't worry if you see the numbers changing; nothing will be finalized until the end of January on your buy/sells, and we should have google working then, or I'll see if I can write up a script with static tables to do it myself.
Tips
1.) Double check your stock price against a major website if you're using the spreadsheet numbers. They are almost always accurate, then sometimes they're off by a factor of one hundred or something. Use one of the major international websites or a major financial one. Recommended: Wall Street's website if you're not sure. I will be checking against my Sharebuilder account's ticker as well.
2.) Conversions will, in general, round to two decimal places for best practices. Google is--doing that but not always in line with international standards. Don't worry if you see changes when you go and look at the numbers; I'm trying to make a macro that won't fight me on this.
3.) Individual converter page; this is undergoing a revision. The one I wrote is working, so as soon as I'm done testing it, I'll give the code here for you to cut and paste. If Google did mass copy, I'd just copy to everyone's pages, but lo, they do not do that. They do mass export, however, and as soon as I'm done testing that, we'll be using that for mass data updates.
Format
Buying - Real Time
Buying - Automatic
Selling
Final Notes
Again, this month is shakedown and getting used to procedure. Do not worry if two days from now you realize GE was overpriced; just tell us to kill it (in the same thread you bought in) and it will be erased.
At the end of the month, we'll check everything for accuracy before starting February. February will limit you to three (3) takebacks, but the mods are both understanding and fighting googledocs, so we're not going to be draconian on this until everythign is working.
If you have Excel, there's a special financial toolbar that is no longer available from Microsoft (I think), but I have and can upload for anyone to use. It works like google's financial functions, but okay, I think the Excel one is neater and I use it to calculate stuff in my private portfolio. I'll upload it by Friday and put a link here for anyone to grab if they want to use it.
My Note: Due to overtime at work, I may not be online as much this week until the weekend.jamethiel is keeping up with everything gorgeously and we're checking in with each other regularly, ie, every night, since my job doesn't like me sleeping anyway when I could be, y'know, running more tests. I'll be reading, just probably not interacting as much.
Happy playing!
So again, this month, you can do it wrong, and you can reverse anything you do. Just comment in the same thread that whatever you did that needs changing/fixing. This month, there is no limit to this, so you won't be bothering us. By the end of the month, I want everyone comfortable with the procedure.
Conversions
We're still working on accurate conversions; googledocs formulas seem to be off. So don't worry if you see the numbers changing; nothing will be finalized until the end of January on your buy/sells, and we should have google working then, or I'll see if I can write up a script with static tables to do it myself.
Tips
1.) Double check your stock price against a major website if you're using the spreadsheet numbers. They are almost always accurate, then sometimes they're off by a factor of one hundred or something. Use one of the major international websites or a major financial one. Recommended: Wall Street's website if you're not sure. I will be checking against my Sharebuilder account's ticker as well.
2.) Conversions will, in general, round to two decimal places for best practices. Google is--doing that but not always in line with international standards. Don't worry if you see changes when you go and look at the numbers; I'm trying to make a macro that won't fight me on this.
3.) Individual converter page; this is undergoing a revision. The one I wrote is working, so as soon as I'm done testing it, I'll give the code here for you to cut and paste. If Google did mass copy, I'd just copy to everyone's pages, but lo, they do not do that. They do mass export, however, and as soon as I'm done testing that, we'll be using that for mass data updates.
Format
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 Your Country's Currency
Shares: 5
Country: Your Country
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
Country: Your Country
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 Your Country's Currency
Shares: How many shares.
Country: Your Country
Final Notes
Again, this month is shakedown and getting used to procedure. Do not worry if two days from now you realize GE was overpriced; just tell us to kill it (in the same thread you bought in) and it will be erased.
At the end of the month, we'll check everything for accuracy before starting February. February will limit you to three (3) takebacks, but the mods are both understanding and fighting googledocs, so we're not going to be draconian on this until everythign is working.
If you have Excel, there's a special financial toolbar that is no longer available from Microsoft (I think), but I have and can upload for anyone to use. It works like google's financial functions, but okay, I think the Excel one is neater and I use it to calculate stuff in my private portfolio. I'll upload it by Friday and put a link here for anyone to grab if they want to use it.
My Note: Due to overtime at work, I may not be online as much this week until the weekend.
jamethiel is keeping up with everything gorgeously and we're checking in with each other regularly, ie, every night, since my job doesn't like me sleeping anyway when I could be, y'know, running more tests. I'll be reading, just probably not interacting as much. Happy playing!
no subject
Date: 2011-01-04 05:49 pm (UTC)no subject
Date: 2011-01-05 02:50 am (UTC)