admin: spreadsheet update
Mar. 17th, 2011 08:56 am![[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_rouletteUpdated
The following spreadsheets are updated with the new pages and--with any luck--are operational:
out_there
lebannen
nafs
jenna_thorn
roguewords
loriel_eris
eponymousanon
thexpuzzler
Most transactions have been added; if anything looks wrong or we missed one or one is incorrect, email me to correct it.
There's been a new menu added to the top of your spreadsheet located after Help - it's named Market. You may also see one called "Mod" or "Moderator"--ignore that one.
Market has four functions listed. Currently, only Update Stock Prices is operational; I haven't added the other scripts yet and won't until next week. Do not use them yet. Some people have them, some don't, because the script only runs during blue moons and I want higher accuracy than that.
Stock Update Prices checks Yahoo, Google, Businessweek, and Globe and Planet, so it pretty much got everyone I've added so far and hasn't errored out when I've run it. However, google is weird; if you cannot run Stock Update Prices or it errors, email me so I can switch security settings and find one that works. Apparently, it's kind of magical and what works for one person will not work for anyone else, ever.
If you want another site added to check, please leave a comment. I can't guarantee I can add it, but I can tell you if it's possible.
Update Dividends, Update Transactions, and Update User Settings will be added next week after I've seen these run for a week.
Next Thursday we'll add the next group, chosen by activity level.
Also Updated
The Transaction Log's been altered and shortened, since we can't change over to another. I tested it and it works the same, just now with fewer questions all on one page.
Questions, comments, add here, otherwise, happy investing!
The following spreadsheets are updated with the new pages and--with any luck--are operational:
out_therelebannennafsjenna_thornroguewordsloriel_eriseponymousanonthexpuzzlerMost transactions have been added; if anything looks wrong or we missed one or one is incorrect, email me to correct it.
There's been a new menu added to the top of your spreadsheet located after Help - it's named Market. You may also see one called "Mod" or "Moderator"--ignore that one.
Market has four functions listed. Currently, only Update Stock Prices is operational; I haven't added the other scripts yet and won't until next week. Do not use them yet. Some people have them, some don't, because the script only runs during blue moons and I want higher accuracy than that.
Stock Update Prices checks Yahoo, Google, Businessweek, and Globe and Planet, so it pretty much got everyone I've added so far and hasn't errored out when I've run it. However, google is weird; if you cannot run Stock Update Prices or it errors, email me so I can switch security settings and find one that works. Apparently, it's kind of magical and what works for one person will not work for anyone else, ever.
If you want another site added to check, please leave a comment. I can't guarantee I can add it, but I can tell you if it's possible.
Update Dividends, Update Transactions, and Update User Settings will be added next week after I've seen these run for a week.
Next Thursday we'll add the next group, chosen by activity level.
Also Updated
The Transaction Log's been altered and shortened, since we can't change over to another. I tested it and it works the same, just now with fewer questions all on one page.
Questions, comments, add here, otherwise, happy investing!
