[Spreadsheet] THT - Torn Helper Tool - Page 21 | Tools & Users…
[Spreadsheet] THT - Torn Helper Tool
    • theharks [2702970]
    • Role: Civilian
    • Level: 29
    • Posts: 28
    • Karma: 11
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 22:27:03 - 14/04/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Been using it for a while = its pretty damn good !!
    • Alascato [2323855]
    • Role: Civilian
    • Level: 71
    • Posts: 2706
    • Karma: 1440
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:41:05 - 15/04/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Suggestion: add another sheet with points listings. Just like bazaar listings
    Last edited by Alascato on 15:41:14 - 15/04/22

     Hi there if  you wanna trade with me,                  CLICK HERE

    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 05:48:47 - 16/04/22 (3 months ago)
    Post link copied to clipboard Copy post link

    Alascato [2323855]

    Suggestion: add another sheet with points listings. Just like bazaar listings
    Added to the list of suggestions in the  first post, thanks!
    • SniperSeer5182 [2762338]
    • Role: Civilian
    • Level: 20
    • Posts: 5
    • Karma: 2
    • Last Action: 1 month
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:10:53 - 16/04/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Im interested, but I am new here and do not that much money yet
    • Social-Hermit [2631831]
    • Role: Civilian
    • Level: 35
    • Posts: 56
    • Karma: 14
    • Last Action: 1 month
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:35:25 - 16/04/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Well worth the investment! Highly recommend this tool!
    • theharks [2702970]
    • Role: Civilian
    • Level: 29
    • Posts: 28
    • Karma: 11
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:30:45 - 16/04/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Just keep saving - still has work to do but is so helpful !
    • Transhumanist [2575642]
    • Role: Civilian
    • Level: 75
    • Posts: 501
    • Karma: 540
    • Last Action: 5 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 14:34:19 - 17/04/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Interested in buying
    • Transhumanist [2575642]
    • Role: Civilian
    • Level: 75
    • Posts: 501
    • Karma: 540
    • Last Action: 5 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 09:59:22 - 19/04/22 (3 months ago)
    Post link copied to clipboard Copy post link
    09:17:46 - 19/04/22 You sent $89,000,000 to jtower with the message: THT - ********@gmail.com
    • VileStorms [2351240]
    • Role: Civilian
    • Level: 34
    • Posts: 19
    • Karma: 0
    • Last Action: 1 day
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 01:41:11 - 20/04/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Interested

    Check out my store page: https://tinyurl.com/rivendellsTradelist

    • Lafat [2623027]
    • Role: Civilian
    • Level: 40
    • Posts: 747
    • Karma: 920
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 08:53:39 - 23/04/22 (3 months ago)
    Post link copied to clipboard Copy post link
    just a suggestion, could a "Racing" sheet be implemented, with stuff like race skill/ car to use for race, recommended upgrades, avrage skill gain and # of races till next racing merit.
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 14:37:38 - 23/04/22 (3 months ago)
    Post link copied to clipboard Copy post link

    Lafat [2623027]

    just a suggestion, could a "Racing" sheet be implemented, with stuff like race skill/ car to use for race, recommended upgrades, avrage skill gain and # of races till next racing merit.
    That would be great, but I think that should be a request for Torn to add those info to the API system. Currently there's almost nothing about racing and nothing at all about cars
    • Nova_Corp [2114365]
    • Role: Civilian
    • Level: 42
    • Posts: 44
    • Karma: 16
    • Last Action: 8 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 06:29:42 - 06/05/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Worth Getting , gave it a test run and gave it a while to see how it works out, i am happy to Say its worth it , you get alot of information that you have track manually tracked for you, if i was you i would get it
    • Alascato [2323855]
    • Role: Civilian
    • Level: 71
    • Posts: 2706
    • Karma: 1440
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 21:28:39 - 07/05/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Is there any chance to build something like this for RW? Or RW sheet in general

     Hi there if  you wanna trade with me,                  CLICK HERE

    • masheen [2625139]
    • Role: Reporter
    • Level: 71
    • Posts: 3025
    • Karma: 2643
    • Last Action: 5 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 21:29:33 - 07/05/22 (3 months ago)
    Post link copied to clipboard Copy post link

    Alascato [2323855]

    Is there any chance to build something like this for RW? Or RW sheet in general
    Same. And one that could track individual member activity too/top performers
    Last edited by masheen on 21:29:45 - 07/05/22
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:23:05 - 07/05/22 (3 months ago)
    Post link copied to clipboard Copy post link

    Alascato [2323855]

    Is there any chance to build something like this for RW? Or RW sheet in general
    That would probably be a separate spreadsheet. But let me take a look at the API, to see what's available
    • Alascato [2323855]
    • Role: Civilian
    • Level: 71
    • Posts: 2706
    • Karma: 1440
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:31:29 - 07/05/22 (3 months ago)
    Post link copied to clipboard Copy post link

    Alascato [2323855]

    Is there any chance to build something like this for RW? Or RW sheet in general

    jtower [2287159]

    That would probably be a separate spreadsheet. But let me take a look at the API, to see what's available
    ok thanks

     Hi there if  you wanna trade with me,                  CLICK HERE

    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:02:09 - 10/05/22 (3 months ago)
    Post link copied to clipboard Copy post link
    There's an issue with the perks API, which is causing some wrong data, especially in the Travel, Money, Nerve sheets. It'll be back working once they fix the bug
    • Hawk [2080065]
    • Role: Civilian
    • Level: 100
    • Posts: 4364
    • Karma: 10000
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 01:55:15 - 11/05/22 (3 months ago)
    Post link copied to clipboard Copy post link
    Looks great!

    I have a question about the stocks history...

    How does the spreadsheet know your profit? Since the log of a stock sale doesn't have the price it was bought at, it would have to guess which lot just sold in the case of multiple lots.

    For example:
    - Lot 1 has 1m shares of SYM bought at 675 a few days ago
    - Lot 2 has 1m shares of SYM bought at 685 yesterday
    - Lot 3 has 1m shares of SYM bought at 745 months ago and held just for the block dividends

    If I sell 1m shares today for 690, will the spreadsheet know if my profit was 2%, 1%, or -7%?

    For those playing stocks, it could happen frequently (and be frustrating).

     

     

    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 02:21:47 - 11/05/22 (3 months ago)
    Post link copied to clipboard Copy post link

    Hawk [2080065]

    Looks great!

    I have a question about the stocks history...

    How does the spreadsheet know your profit? Since the log of a stock sale doesn't have the price it was bought at, it would have to guess which lot just sold in the case of multiple lots.

    For example:
    - Lot 1 has 1m shares of SYM bought at 675 a few days ago
    - Lot 2 has 1m shares of SYM bought at 685 yesterday
    - Lot 3 has 1m shares of SYM bought at 745 months ago and held just for the block dividends

    If I sell 1m shares today for 690, will the spreadsheet know if my profit was 2%, 1%, or -7%?

    For those playing stocks, it could happen frequently (and be frustrating).
    It "remembers" your last StockPortfolio sheet (before the sale) and check the differences with the current StockPortfolio sheet (after the sale). In the StockPortfolio sheet you have each "block" of shares, so if you sell a specific one, it knows which one you sold and at which buy price.

    This won't work correctly if you split and sell or merge and sell within the same minute (this is also explained in the guide I sent - check "Stock Trading This Month" section in the guide)
    Last edited by jtower on 02:25:02 - 11/05/22
    • Hawk [2080065]
    • Role: Civilian
    • Level: 100
    • Posts: 4364
    • Karma: 10000
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 11:39:12 - 11/05/22 (3 months ago)
    Post link copied to clipboard Copy post link

    Hawk [2080065]

    Looks great!

    I have a question about the stocks history...

    How does the spreadsheet know your profit? Since the log of a stock sale doesn't have the price it was bought at, it would have to guess which lot just sold in the case of multiple lots.

    For example:
    - Lot 1 has 1m shares of SYM bought at 675 a few days ago
    - Lot 2 has 1m shares of SYM bought at 685 yesterday
    - Lot 3 has 1m shares of SYM bought at 745 months ago and held just for the block dividends

    If I sell 1m shares today for 690, will the spreadsheet know if my profit was 2%, 1%, or -7%?

    For those playing stocks, it could happen frequently (and be frustrating).

    jtower [2287159]

    It "remembers" your last StockPortfolio sheet (before the sale) and check the differences with the current StockPortfolio sheet (after the sale). In the StockPortfolio sheet you have each "block" of shares, so if you sell a specific one, it knows which one you sold and at which buy price.

    This won't work correctly if you split and sell or merge and sell within the same minute (this is also explained in the guide I sent - check "Stock Trading This Month" section in the guide)
    Thanks! I haven't seen the guide

     

     

Reply
Thread Title: