Stocks 3.0 + cans - auto update - Page 3 | Tutorials & Guides …
Stocks 3.0 + cans - auto update
  • |X| The_Serpent [2537964]The_Serpent [2537964]
    • The_Serpent [2537964]
    • Role: Civilian
    • Level: 60
    • Posts: 30
    • Karma: 18
    • Last Action: 6 minutes
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:27:26 - 15/05/21 (5 months ago)
    Post link copied to clipboard Copy post link
    talked to OP, the sheet i was looking at did not refresh and was in weekly ROI not annual.  Should be fixed now
  • |X| The_Serpent [2537964]The_Serpent [2537964]
    • The_Serpent [2537964]
    • Role: Civilian
    • Level: 60
    • Posts: 30
    • Karma: 18
    • Last Action: 6 minutes
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:40:46 - 15/05/21 (5 months ago)
    Post link copied to clipboard Copy post link
    bump
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 443
    • Karma: 777
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 10:04:02 - 19/05/21 (5 months ago)
    Post link copied to clipboard Copy post link
    Not really fixed, more that you need to set the RoI to annually (365 days) if you want that view
  • dDos Lysandra [2198698]Lysandra [2198698]
    • Lysandra [2198698]
    • Role: Civilian
    • Level: 71
    • Posts: 135
    • Karma: 117
    • Last Action: 2 months
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:24:15 - 29/05/21 (4 months ago)
    Post link copied to clipboard Copy post link
    Thanks for this! I love how it lets you choose how many merits and how much money you have in banking. It makes it very easy to decide where to invest, especially if you have something other than 0 or 10 merits in banking. 

    56293b59-bc9b-408f-1533238.gif56293b59-bcab-18a3-1533238.gif

  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 443
    • Karma: 777
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 07:24:21 - 03/06/21 (4 months ago)
    Post link copied to clipboard Copy post link
    bump
  • B3 Markshark [2328279]Markshark [2328279]
    • Markshark [2328279]
    • Role: Civilian
    • Level: 50
    • Posts: 351
    • Karma: 220
    • Last Action: 3 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 10:34:45 - 03/06/21 (4 months ago)
    Post link copied to clipboard Copy post link
    Sweet piece of spreadsheet this, thanks so much for sharing this! 

    I don't know if it's just me, but I can't seem to enable YAZ as an owned BB?

    10/10 for this though, very good!
  • dDos Lysandra [2198698]Lysandra [2198698]
    • Lysandra [2198698]
    • Role: Civilian
    • Level: 71
    • Posts: 135
    • Karma: 117
    • Last Action: 2 months
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 14:15:06 - 05/06/21 (4 months ago)
    Post link copied to clipboard Copy post link

    Markshark [2328279]

    Sweet piece of spreadsheet this, thanks so much for sharing this!

    I don't know if it's just me, but I can't seem to enable YAZ as an owned BB?

    10/10 for this though, very good!
    It works for me. Have you tried refreshing?

    56293b59-bc9b-408f-1533238.gif56293b59-bcab-18a3-1533238.gif

  • B3 Markshark [2328279]Markshark [2328279]
    • Markshark [2328279]
    • Role: Civilian
    • Level: 50
    • Posts: 351
    • Karma: 220
    • Last Action: 3 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 05:11:29 - 06/06/21 (4 months ago)
    Post link copied to clipboard Copy post link

    Markshark [2328279]

    Sweet piece of spreadsheet this, thanks so much for sharing this!

    I don't know if it's just me, but I can't seem to enable YAZ as an owned BB?

    10/10 for this though, very good!

    Lysandra [2198698]

    It works for me. Have you tried refreshing?
    Yah, that's sorted it for me!

    Thank you, excellent piece of work!
  • 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:58:33 - 14/06/21 (4 months ago)
    Post link copied to clipboard Copy post link
    Is the ROI of TCB calculated correctly? It seems as if it considers the total interest from the bank investment, not just the differnece between the interest with and without TCB, doesn't it?
    Last edited by randalus on 12:04:10 - 14/06/21

  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 443
    • Karma: 777
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 14:31:57 - 14/06/21 (4 months ago)
    Post link copied to clipboard Copy post link

    randalus [1306671]

    Is the ROI of TCB calculated correctly? It seems as if it considers the total interest from the bank investment, not just the differnece between the interest with and without TCB, doesn't it?
    It takes into consideration that you only need to hold the TCI for one week, the rest of the time you can do something different with the TCI money. So that weeks investment will carry a high RoI. But if you look at doing shorter bank investments, like one week or two weeks, you will see that the RoI for TCI would probably be negative (because of the fee for selling x2 per investment period).
  • 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 15:25:34 - 14/06/21 (4 months ago)
    Post link copied to clipboard Copy post link
    OK, I see. Thank you. So I can buy the BB one week before the Bank is due, then sell it again after the Bank investment ended and repeat this 3 months later. nice.

  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 443
    • Karma: 777
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 20:32:55 - 14/06/21 (4 months ago)
    Post link copied to clipboard Copy post link
    Exactly :)
  • DiS Tanebel [2279733]Tanebel [2279733]
    • Tanebel [2279733]
    • Role: Civilian
    • Level: 29
    • Posts: 59
    • Karma: 11
    • Last Action: 19 days
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 04:22:43 - 05/07/21 (3 months ago)
    Post link copied to clipboard Copy post link
    new stock: Alcoholics  Synonymous. is it profitable?
  • TM Goodboy21 [2439530]Goodboy21 [2439530]
    • Goodboy21 [2439530]
    • Role: Civilian
    • Level: 71
    • Posts: 34
    • Karma: 7
    • Last Action: 55 minutes
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:42:35 - 05/07/21 (3 months ago)
    Post link copied to clipboard Copy post link
    If I am reading the spreasheet correctly, no BB is better than bank with full merits right now? 

    Putting aside passive BBs of course
  • NUKE icedom [2636764]icedom [2636764]
    • icedom [2636764]
    • Role: Civilian
    • Level: 27
    • Posts: 94
    • Karma: 32
    • Last Action: 8 minutes
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 16:00:11 - 06/07/21 (3 months ago)
    Post link copied to clipboard Copy post link
    Thanks Hugin, google noob question, Is my google acc / api safe if i get a copy on my drive and use run the script ?
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 443
    • Karma: 777
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 19:56:50 - 06/07/21 (3 months ago)
    Post link copied to clipboard Copy post link

    Goodboy21 [2439530]

    If I am reading the spreasheet correctly, no BB is better than bank with full merits right now?

    Putting aside passive BBs of course
    yes, that would be correct (I think a little depending on merits/legnth of investment etc).
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 443
    • Karma: 777
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 19:59:23 - 06/07/21 (3 months ago)
    Post link copied to clipboard Copy post link

    icedom [2636764]

    Thanks Hugin, google noob question, Is my google acc / api safe if i get a copy on my drive and use run the script ?
    I would think so since you dont have to enter your api. The sheet calls on another (private) sheet that does the api calls, so should be pretty much unlimited users with same amount of api calls towards torn.
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 443
    • Karma: 777
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 06:49:25 - 07/07/21 (3 months ago)
    Post link copied to clipboard Copy post link
    And added ASS and MUN now to the sheet too
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 443
    • Karma: 777
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 07:52:54 - 14/07/21 (3 months ago)
    Post link copied to clipboard Copy post link
    bump :)
  • HAKA Hugin [2490688]Hugin [2490688]
    • Hugin [2490688]
    • Role: Civilian
    • Level: 65
    • Posts: 443
    • Karma: 777
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 09:56:49 - 23/07/21 (2 months ago)
    Post link copied to clipboard Copy post link
    bump
Reply
Thread Title: