Stocks 3.0 + cans - auto update - Page 4 | Tutorials & Guides …
Stocks 3.0 + cans - auto update
  • NUKE Hyphone [2518628]Hyphone [2518628]
    • Hyphone [2518628]
    • Role: Civilian
    • Level: 55
    • Posts: 57
    • Karma: 22
    • Last Action: 2 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 11:08:55 - 28/07/21 (2 months ago)
    Post link copied to clipboard Copy post link
    super handy - thanks dude!
  • NUKE Stoute_Tovenaar [2321463]Stoute_Tovenaar [2321463]
    • Stoute_Tovenaar [2321463]
    • Role: Civilian
    • Level: 71
    • Posts: 326
    • Karma: 569
    • Last Action: 20 minutes
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 11:22:00 - 28/07/21 (2 months ago)
    Post link copied to clipboard Copy post link

    Hyphone [2518628]

    super handy - thanks dude!
    Consider it a birthday present!
  • HAKA Penetration [2340613]Penetration [2340613]
    • Penetration [2340613]
    • Role: Civilian
    • Level: 89
    • Posts: 2668
    • Karma: 4813
    • Last Action: 5 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 00:39:00 - 29/07/21 (2 months ago)
    Post link copied to clipboard Copy post link

    Hugin [2490688]

    Hey!

    I created a sheet for myself to wrap my head around the different investment options. Here you can see your total investment for the options you choose to check as owned, the ROI for each tier (not the whole block together). All stocks are included, even the passive ones. I have chosen not to evaluate ROI for stocks not paying out sellable things (MSC/EVL/BAG). Feel free to make your own copy of the sheet to play around with.

    Big thanks to Jotero for helping with the sheet.

    Edit: ASS and MUN added to the sheet

    Edit: API calls for stocks now added and updates hourly. Added a TCI eval for a variation of merits, length of investment and size of investment. The TCI RoI is now dependant on the values you feed in regarding merits, investment etc.
    Item dividend value is now automatically updated from Torn market hourly. Bank interest rate is automatically updated daily.


    Hugins stock sheet (click link)



    Set the number of days you want to show ROI for:


    I prefer weekly since I use torn weekly bank interest to compare and it is a value I can relate to.


    Click the checkbox for the stocks and tiers you own:

    and get a visual feedback to which you own



    Check your monthly income from stocks:



    Keep track of your full portfolio:



    Evaluate monthly bank investmet, set your merits and other input values:

    Bank interest rate updates daily.



    See how the bank interest has varied over the past:
    Love this. Thanks fam.
  • RVG randalus [1306671]randalus [1306671]
    • randalus [1306671]
    • Role: Civilian
    • Level: 71
    • Posts: 421
    • Karma: 128
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 11:07:01 - 31/07/21 (2 months ago)
    Post link copied to clipboard Copy post link
    this is really really awesome, I think I posted this before 

    Is there any chance to include this into tornstats.com or something? It would be amazing if I you could save my individual stock benefits for later use or to add changes

  • TR Celesteela [2665269]Celesteela [2665269]
    • Celesteela [2665269]
    • Role: Civilian
    • Level: 50
    • Posts: 63
    • Karma: 52
    • Last Action: 1 minute
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 07:23:09 - 01/08/21 (2 months ago)
    Post link copied to clipboard Copy post link
    Excellent, useful sheet. Super friendly creator as well!
  • PT Five [959585]Five [959585]
    • Five [959585]
    • Role: Civilian
    • Level: 75
    • Posts: 706
    • Karma: 1003
    • Last Action: 1 hour
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 08:26:49 - 12/08/21 (2 months ago)
    Post link copied to clipboard Copy post link
    b

  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 442
    • Karma: 775
    • Last Action: 3 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 09:03:43 - 19/08/21 (1 month ago)
    Post link copied to clipboard Copy post link

    Celesteela [2665269]

    Excellent, useful sheet. Super friendly creator as well!
    Always :)
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 442
    • Karma: 775
    • Last Action: 3 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 06:35:07 - 31/08/21 (1 month ago)
    Post link copied to clipboard Copy post link
    bump
  • Butt gabe97 [2438756]gabe97 [2438756]
    • gabe97 [2438756]
    • Role: Civilian
    • Level: 65
    • Posts: 1013
    • Karma: 197
    • Last Action: 2 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 19:20:24 - 09/09/21 (1 month ago)
    Post link copied to clipboard Copy post link
    love it. thanks!
  • NSO SarmatianEmpire [565880]SarmatianEmpire [565880]
    • SarmatianEmpire [565880]
    • Role: Civilian
    • Level: 50
    • Posts: 58
    • Karma: 44
    • Last Action: 1 minute
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 16:25:38 - 17/09/21 (1 month ago)
    Post link copied to clipboard Copy post link
    This is a fantastic tool. I've been tracking my own stocks, but I'm lazy and don't want to update block and item pricing manually too often. This solves that

    NSO-Not-Dicks-Torn-newspaper.png

  • IRC Maestro3P [2417542]Maestro3P [2417542]
    • Maestro3P [2417542]
    • Role: Civilian
    • Level: 50
    • Posts: 410
    • Karma: 35
    • Last Action: 1 minute
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 08:03:55 - 03/10/21 (14 days ago)
    Post link copied to clipboard Copy post link
    This is awesome!
  • WC Tembrawar [2647532]Tembrawar [2647532]
    • Tembrawar [2647532]
    • Role: Civilian
    • Level: 60
    • Posts: 73
    • Karma: 31
    • Last Action: 1 hour
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:01:58 - 05/10/21 (11 days ago)
    Post link copied to clipboard Copy post link
    I have a question about "TCI" .... the spreadsheet has Torn City Investments as "TCB" ... is "TCI" something different?
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 442
    • Karma: 775
    • Last Action: 3 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 09:11:13 - 06/10/21 (11 days ago)
    Post link copied to clipboard Copy post link

    Tembrawar [2647532]

    I have a question about "TCI" .... the spreadsheet has Torn City Investments as "TCB" ... is "TCI" something different?
    It is the same, before it was called Torn City Bank so that name just stuck in the sheet, plus I think when calling the stock by api it is called TCB still
    Last edited by Hugin on 09:14:07 - 06/10/21
  • LOL CocaineJesus [2129012]CocaineJesus [2129012]
    • CocaineJesus [2129012]
    • Role: Civilian
    • Level: 40
    • Posts: 90
    • Karma: 37
    • Last Action: 3 minutes
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 05:37:55 - 08/10/21 (9 days ago)
    Post link copied to clipboard Copy post link
    Check cell Q20 and Q21
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 442
    • Karma: 775
    • Last Action: 3 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:14:26 - 10/10/21 (7 days ago)
    Post link copied to clipboard Copy post link
    fixed and cleaned up copies
  • AP MrHoneyBadger [2184295]MrHoneyBadger [2184295]
    • MrHoneyBadger [2184295]
    • Role: Civilian
    • Level: 52
    • Posts: 28
    • Karma: 4
    • Last Action: 2 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 09:29:06 - 11/10/21 (6 days ago)
    Post link copied to clipboard Copy post link
    Bank ROI seems to be negative ?
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 442
    • Karma: 775
    • Last Action: 3 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 09:48:01 - 11/10/21 (6 days ago)
    Post link copied to clipboard Copy post link

    MrHoneyBadger [2184295]

    Bank ROI seems to be negative ?
    I think this has to do with the bugging of APIs atm. Torn tools and Yata also seem to have problems
Reply
Thread Title: