GRAVED
About this thread
Posts archived: 115 / 115 posts (100%) · the total is Torn's reply count + the opening post at the last fetch
Counted by TornLife from the archived posts.
- Archived posts
- 115
- Discussion span
- →
- Authority score
- 44 / 100
- Historical score
- 52 / 100
- Story score
- 80 / 100
- Engagement score
- 86 / 100
People posting, likes and official posts are not counted for this thread yet: on threads longer than one page they come from a periodic pass over the archive, which has not covered it.
Most-liked replies
- Father [2131687]
· 7 likes ·
Yes, it can be used in android. I wrote , tested and debugged this fully on my android. No use of PC was involved. For it you will need Google Sheets Android App and Yandex/Kiwi/Mobile Firefox to install Tampermonkey on. … - DeKleineKobini [2114440] Committee
· 3 likes ·
Trades are pretty much impossible to add, for multiple reasons. - It can't possibly know how much you paid for which item. - It won't know which contents are in a completed trade. - DeKleineKobini [2114440] Committee
· 1 likes ·
I don't think you can set this up while on mobile. I'm pretty sure that you can't access the scripteditor, which is needed here.
Any idea how to do this on mobile using Google sheets?
I don't think you can set this up while on mobile.
I'm pretty sure that you can't access the scripteditor, which is needed here.
I'm pretty sure that you can't access the scripteditor, which is needed here.
Managed to do a combination lol. Edit it on work pc, mailed the link to my phone and installed on the phone
Yes, it can be used in android. I wrote , tested and debugged this fully on my android. No use of PC was involved. For it you will need Google Sheets Android App and Yandex/Kiwi/Mobile Firefox to install Tampermonkey on.
1) Open the link to Spreadsheet in Google Chrome on android. Click on Edit Icon in right corner and open the spreadsheet in Google Sheets Android App. After close it and open Google Sheets App again.
Note: If you have more than one Gmail Id signed in on the device then select the one that is on the top, otherwise you will have to sign out from all other accounts to Deploy the Spreadsheet.
2) Select the Spreadsheet and click on Make a Copy.
[image: i.gyazo.com]
3) You can now remove this spreadsheet. Close Google Sheets App and Open Google Chrome.
4) Go to https://script.google.com/ .
5) Click on the "Accounting Script V1"
[image: i.gyazo.com]
6) Click on "Open Project"
[image: i.gyazo.com]
7) Click on Publish > Deploy as Web app.
8) Select the options as:
[image: toucantoco.com]
9) Click on Deploy button. It will give you a link. Copy it.
10) Now get back to Yandex/Kiwi/Firefox whatever browser you are using. Install the Script.
11) Go to Torn Preferences page and put the link that you copied in the box there and select the desired options.
[image: i.gyazo.com]
12) Click on Save button.
Edit: Lol, glad that you figured it out. Took me a while to write this post and adding screenshots.
Also what you think about it?
1) Open the link to Spreadsheet in Google Chrome on android. Click on Edit Icon in right corner and open the spreadsheet in Google Sheets Android App. After close it and open Google Sheets App again.
Note: If you have more than one Gmail Id signed in on the device then select the one that is on the top, otherwise you will have to sign out from all other accounts to Deploy the Spreadsheet.
2) Select the Spreadsheet and click on Make a Copy.
[image: i.gyazo.com]
3) You can now remove this spreadsheet. Close Google Sheets App and Open Google Chrome.
4) Go to https://script.google.com/ .
5) Click on the "Accounting Script V1"
[image: i.gyazo.com]
6) Click on "Open Project"
[image: i.gyazo.com]
7) Click on Publish > Deploy as Web app.
8) Select the options as:
[image: toucantoco.com]
9) Click on Deploy button. It will give you a link. Copy it.
10) Now get back to Yandex/Kiwi/Firefox whatever browser you are using. Install the Script.
11) Go to Torn Preferences page and put the link that you copied in the box there and select the desired options.
[image: i.gyazo.com]
12) Click on Save button.
Edit: Lol, glad that you figured it out. Took me a while to write this post and adding screenshots.
Also what you think about it?
Easy to set up and easy to use. I like having the information stored someplace I can come back and check later. Very nice script. R+ :D
R+ Indeed. Will give it a go when I get a free moment. I'm glad there is finally a tool to do this which is publicly available.
Awesome! I've been waiting for something like this for a long time.
Can't wait to set it up and try it out :)
Can't wait to set it up and try it out :)
This is an awesome tool. Thank you!
It's awesome,thx thx thx, wanted this for so long, makes buying and selling sooooooooo much easier, you are my hero.....
Thanks!
Any thoughts on upgrading this? Possibly adding recent trades?
Recent trades? Hmm, you can see your last 10 trades here: https://www.torn.com/trade.php
And if you need more maybe Arson Warehouse has something like that, but not sure as I never used it. But from what I have heard it is a useful utility for traders. You should check it out.
But currently I am busy in some rl stuff and working on 2 other spreadsheets. I may look into it later, but I make no promises.
Edit: Link to Arson Warehouse
And if you need more maybe Arson Warehouse has something like that, but not sure as I never used it. But from what I have heard it is a useful utility for traders. You should check it out.
But currently I am busy in some rl stuff and working on 2 other spreadsheets. I may look into it later, but I make no promises.
Edit: Link to Arson Warehouse
Great work Sid! I’m going to give it a shot to see it in action. Very generous of you to use your spare time on this, I don’t imagine it was an easy task!
Edit: Yes, ArsonWarehouse shows buyers their trades from the last 3 months. I’ll add filters and search options soon as was requested in the awh thread by LordofFire.
Edit: Yes, ArsonWarehouse shows buyers their trades from the last 3 months. I’ll add filters and search options soon as was requested in the awh thread by LordofFire.
As explained by sid, you can actually access it by going to scripts.google.com
You can even enter the script editor, but it hasn't been optimized for mobile so it's not very nice to use (you can't select a snippet of code for example, it's either backspace or select the entire script..)
It can be useful if you need to do a quick fix while you don't have access to a PC, remove or add triggers, that sort of stuff.
You can even enter the script editor, but it hasn't been optimized for mobile so it's not very nice to use (you can't select a snippet of code for example, it's either backspace or select the entire script..)
It can be useful if you need to do a quick fix while you don't have access to a PC, remove or add triggers, that sort of stuff.
I found a conflict with the noconfirmbuy script from DKK.
It doesn't update the spreadsheet if you have that enabled.
Looks like the accounting script triggers on the confirm, so it doesn't register purchases that don't have the confirm prompt?
It doesn't update the spreadsheet if you have that enabled.
Looks like the accounting script triggers on the confirm, so it doesn't register purchases that don't have the confirm prompt?
Tbh, I doubt the conflict is because of lack of confirm prompt. As all DKK's script does is change the HTML and doesn't affect the server-side responses. While my script doesn't depend on HTML and read the server responses. So the conflict is not due to the lack of 'confirm prompt'. Besides one of the alpha testers reported that a script named 'Lowest Bazaar Price' also sometimes has the conflict with it.
Currently the only other scripts I have enabled are bazaar scam warning (from sulsay I think), and doctorn.
Edit: it does work if I don't have noconfirmbuy enabled
Edit edit: I just noticed you can change the load order in the tampermonkey dashboard. Setting this script at #1 fixed the issue.
Edit: it does work if I don't have noconfirmbuy enabled
Edit edit: I just noticed you can change the load order in the tampermonkey dashboard. Setting this script at #1 fixed the issue.
I didn't say that there was no conflict with DKK's script. I said that the conflict with DKK's script is not caused because of lack of 'Confirm Prompt'.
I was just giving some extra info.
I edited that post with some more testing (I didn't see you had responded yet).
Changing the load order fixed the issue.
I edited that post with some more testing (I didn't see you had responded yet).
Changing the load order fixed the issue.