admin: the new spreadsheet
Mar. 30th, 2011 11:17 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_rouletteAbout half the spreadsheets are more or less updated to the new version. This is a quick tutorial on what's changed.
Instructions
This applies to people using the Transaction Log for their spreadsheets. If you use the comm, this doesn't apply to you.
Every spreadsheet now has a page called TransactionLog. This is not to replace the main log. This is a copy of all your personal transactions.
1.) After you enter your transactions in the main Transaction Log, you go to your spreadsheet, go to the menu Market (it's right after Help), and run Update Transactions and the script will take your transactions from the big log and put them in your log, format them, and convert them for you if necessary.
2.) After you run this, go to your Summary sheet. If they are brand new companies, you will see them update there from your log automatically; if you are adding shares of a company you already own, the number of shares should increase.
If you don't see them, this is weird and it only happens to about five of you, but this is the procedure.
On the Summary page, in the table, go to the Ticker label. You may see a tiny orange dot or triangle on the left side. Click on Ticker so its' outlined but not so you can edit the field. Then click control-R. I do not know why it does that to some people but not others. The mysteries of google continue.
3.) When the new transactions show up in Summary, go to the menu Market and run Update Stock Prices. It may take a few minutes. It should update all your stock prices.
4.) There is a sheet in your spreadsheet called DataPage. Scroll down to B77. There is a number there. That shows if you have any transactions in the main Transaction Log (the market roulette log, not your personal one) that haven't been transferred. It will also show the last time you ran the Update Transactions and Update Stock Prices scripts.
Do Not Do
1.) Do not add anything directly to the Summary page. The summary page is based on a set of internal spreadsheet scripts that use your TransactionLog Sheet. They are how soon we will have graphs.
2.) You do not need to add your transactions manually to your TransactionLog sheet. When you enter them in the main Transaction Log, you run Update Transactions in your spreadsheet and it will do all the moving and formatting automatically for you. As soon as we know it works manually, I'll add triggers so it will run scripts for you, but right now, you have to tell the scripts to run so if they fail, the scripts will email me with the log and the problem and I can do a fix.
If you want to start adding them manually to your own spreadsheet and not use the main transaction log, please tell me. I'll need a special script so I can copy them into the main log.
3.) If there is a failure, email me. Every country and every language has differences in how google accepts scripts. Some people require me to change all commas to semicolons, so not kidding. It's easy to fix.
4.) You cannot mess this up unfixably. Please don't panic if something looks wrong or suddenly goes out of whack. I put enough failsafes in here, and every spreadsheet has a Revision page. It'll be easy to fix.
Future
The summary page will have some additional features added over the next month.
Again, this is a slow process so everything we add works before we add something new. Some of you will have updates slightly faster depending on what the scripts are supposed to do and the country, since Singapore is apparently the perfect testing country.
Some of you haven't yet gotten the update. Don't worry. I made a copy of your spreadsheet to apply the scripts, but they failed and I'm trying to find out why before I update.
Any questions of any kind, email or comment here. I'll also be online most night thsi week, so feel free to say hi in yahoo or aim or google.
Instructions
This applies to people using the Transaction Log for their spreadsheets. If you use the comm, this doesn't apply to you.
Every spreadsheet now has a page called TransactionLog. This is not to replace the main log. This is a copy of all your personal transactions.
1.) After you enter your transactions in the main Transaction Log, you go to your spreadsheet, go to the menu Market (it's right after Help), and run Update Transactions and the script will take your transactions from the big log and put them in your log, format them, and convert them for you if necessary.
2.) After you run this, go to your Summary sheet. If they are brand new companies, you will see them update there from your log automatically; if you are adding shares of a company you already own, the number of shares should increase.
If you don't see them, this is weird and it only happens to about five of you, but this is the procedure.
On the Summary page, in the table, go to the Ticker label. You may see a tiny orange dot or triangle on the left side. Click on Ticker so its' outlined but not so you can edit the field. Then click control-R. I do not know why it does that to some people but not others. The mysteries of google continue.
3.) When the new transactions show up in Summary, go to the menu Market and run Update Stock Prices. It may take a few minutes. It should update all your stock prices.
4.) There is a sheet in your spreadsheet called DataPage. Scroll down to B77. There is a number there. That shows if you have any transactions in the main Transaction Log (the market roulette log, not your personal one) that haven't been transferred. It will also show the last time you ran the Update Transactions and Update Stock Prices scripts.
Do Not Do
1.) Do not add anything directly to the Summary page. The summary page is based on a set of internal spreadsheet scripts that use your TransactionLog Sheet. They are how soon we will have graphs.
2.) You do not need to add your transactions manually to your TransactionLog sheet. When you enter them in the main Transaction Log, you run Update Transactions in your spreadsheet and it will do all the moving and formatting automatically for you. As soon as we know it works manually, I'll add triggers so it will run scripts for you, but right now, you have to tell the scripts to run so if they fail, the scripts will email me with the log and the problem and I can do a fix.
If you want to start adding them manually to your own spreadsheet and not use the main transaction log, please tell me. I'll need a special script so I can copy them into the main log.
3.) If there is a failure, email me. Every country and every language has differences in how google accepts scripts. Some people require me to change all commas to semicolons, so not kidding. It's easy to fix.
4.) You cannot mess this up unfixably. Please don't panic if something looks wrong or suddenly goes out of whack. I put enough failsafes in here, and every spreadsheet has a Revision page. It'll be easy to fix.
Future
The summary page will have some additional features added over the next month.
Again, this is a slow process so everything we add works before we add something new. Some of you will have updates slightly faster depending on what the scripts are supposed to do and the country, since Singapore is apparently the perfect testing country.
Some of you haven't yet gotten the update. Don't worry. I made a copy of your spreadsheet to apply the scripts, but they failed and I'm trying to find out why before I update.
Any questions of any kind, email or comment here. I'll also be online most night thsi week, so feel free to say hi in yahoo or aim or google.
no subject
Date: 2011-04-05 01:27 am (UTC)no subject
Date: 2011-04-05 03:35 am (UTC)no subject
Date: 2011-04-05 03:51 am (UTC)