• MNK1434

    @thesudio

    Updated 1/14/2018 -
    Changes:
    -API Calls are only made once per coin (Fetched Data), this will lessen the chance you run out of Google's API Call limit per day.
    -Current Holdings and Gain / Loss on the Main Sheet now grabs the coin symbol/names from the Symbol field, you will not have to edit the formula for new coins, simply add a new symbol
    -Corrected totals for Row 63 and Row 97 on the Main Sheet. Remember when you add new coins to change the totals formula.
    -Added query formula to pull API from Crypto-Bridge.org for Polytimos price. (This site seems more stable then previous coinsmarkets)

    https://docs.google.com/spreadsheets/d/1N00IYMgqrHFib6O3A5ompXJZ6ofqvDyuzV1MDyb9jQc/copy

    posted in Exchange Discussion read more
  • MNK1434

    love that 3d version, i was staring at it for a while, that's pretty cool.

    posted in Polytimos Discussion read more
  • MNK1434

    Just wondering, whats the correct pronunciation ?
    from some youtube vids, I heard :

    Poly-Tee-Moss

    Poly-Tai-Moss

    Po-Lie-Dee-Moss

    posted in OFF-TOPIC read more
  • MNK1434

    That logo goes really well with the "PShield" title. I really like it as well. Also, the Silver/Gray tone seems to be a lot easier on your eyes.

    posted in Polytimos Discussion read more
  • MNK1434

    Hey guys, I made some adjustments on the Sheet, I just noticed randomly the CoinsMarket data fetching error's out. It's probably from cloud flare, or maybe just CoinsMarket's stability.

    I made a function called "CopyForError()" which would copy the value of the price (I35) to a new field (J35). It will copy only when value is greater then 0, this way if the site ever errors out, it still has old data and once the new data is finally fetched, it'll update to the newest price.

    0_1515053240134_e01d8b73-c03e-4851-af65-d99955db2a23-image.png

    It's time driven to check every 30 mins.

    Also remember to make sure script triggers are set! Inside Script Editor , goto Edit --> Current Project Triggers
    0_1515053301906_304b70dc-9976-4874-937e-075c2edd9c20-image.png

    I believe you have to open the script editor once the file is copied, and ran once, It may prompt you to allow script to run (ImportJSON). Just select function and hit the "Play" button , do this for both RefreshHouly and CopyForError

    0_1515053367165_a8b8ecf9-e1fe-4fb2-9642-bda70f5c7a6c-image.png

    I guess Final edit (1/4/2017):
    https://docs.google.com/spreadsheets/d/1N00IYMgqrHFib6O3A5ompXJZ6ofqvDyuzV1MDyb9jQc/copy

    posted in Exchange Discussion read more
  • MNK1434

    @thesudio You can delete the old sheet and copy the new one to get the latest copy with POWR. It's still the same link at the top.

    posted in Exchange Discussion read more
  • MNK1434

    on to the MAIN section:
    Only formula that needs to be changed is "Market Price"

    0_1515045831928_a053dd31-b7d4-4236-93e2-f8ea08250c3d-image.png

    This time, just edit the very top one, and get the formula, it's gonna be long best thing to do is just DOUBLE CLICK it, so you can see the edit box right on top of the sheet:
    0_1515045877797_fb1bba93-53f0-4cca-a30f-ac6e38e97b61-image.png

    So we have...

    =IF(COUNTBLANK(B5:D5)=0, IFS(B5="BTC",$N$4,B5="ETH",$N$5,B5="LTC",$N$6,B5="VTC",$N$7,B5="XRP",$N$8,B5="XMR",$N$9,B5="DASH",$N$10,B5="XEM",$N$11,B5="ZEC",$N$12,B5="HUSH",$N$13,B5="PXC",$N$14,B5="MONA",$N$15,B5="BTG",$N$16,B5="GRS",$N$17,B5="TZC",$N$18,B5="HYP",$N$19,B5="RAIN",$N$20,B5="DOGE",$N$21,B5="ALTCOM",$N$22,B5="SIA",$N$23,B5="VIVO",$N$24,B5="ENT",$N$25,B5="POLY",$N$26), "")

    It's pretty straight forward, we just need to add the new coin symbol so it grabs the data from the Currency Data section

    the part we need to watch for is here:
    0_1515046036669_91aab677-b400-481f-83cc-55ce3c20a489-image.png

    ,B5="POLY",$N$26
    remember there's comma in front of B5. Since it's gonna be added as the last line of formula. We are going to be adding after that $N$26:
    ,B5="POWR",$N$27

    Basically we are reference if there is POWR in B5, get the price from N27

    then hit ENTER.
    It will save the formula and you should still be seeing the data for the first line.
    now we have to copy in series, so best thing to do is grab the bottom right block handle and drag it all the way down, a good amount of cells past the last data row.

    0_1515046348885_32d14110-5925-45e7-b721-63fb31598b78-image.png

    0_1515046382119_2c050295-f407-4a74-a058-673434e087b3-image.png

    So now
    when I add "POWR" having 1000 coins, It gives me the current value of having 1000 of them.
    0_1515046596080_193fb79d-53fa-471b-9128-31e050bce98d-image.png

    At the same time, i can see that 14% of my total value is POWR, and I'm holding total 1000, with detailed info
    0_1515046658022_ce1473f8-a408-4f16-91a6-6c29e7cacbf4-image.png

    And at gains section is for when you actually have a book value

    And that should do it!

    posted in Exchange Discussion read more
  • MNK1434

    For GAINS AND LOSSES section:
    You have to edit all 3 fields on this one
    do the same Copy and Pasting of last data we have, and change the symbols in all 3 Fields "Book Value" "Market Value" "Net Profit"
    (I have Book Value, because my original Book has a seperate sheet for 'investments' where I had actually purchased coins with money at certain prices, so I can see both loss and gains)

    0_1515045575539_aca8152b-e58c-4479-aee7-98fa23b23e8b-image.png

    0_1515045592147_1a20174c-9933-40e3-8d74-34215052ba29-image.png

    0_1515045630809_309133f3-5f00-47c2-b636-a62128417e75-image.png

    0_1515045699578_b582f828-e82e-4391-b9cc-02cbb8fd58a8-image.png

    posted in Exchange Discussion read more
  • MNK1434

    For CURRENT HOLDINGS section:
    (I'm not copying and pasting the POLY line because it's only USD value data that's coming from CoinsMarket instead of the more detailed CoinMarketCap)

    Copy the Previous data again
    CTRL+C
    0_1515044625845_6268fd98-2663-4996-9157-80a7f6b05ead-image.png
    then CTRL+V
    0_1515044670598_0943322d-ac15-4b40-9c7a-271fbe8101eb-image.png

    This time we need to change the Symbol, but will also need to edit the cell formulas. I changed the name from ENT to POWR , and also if you look at M61, I've changed the =SUMIFS($C$5:$C$300,$B$5:$B$300,"=ENT") to =SUMIFS($C$5:$C$300,$B$5:$B$300,"=POWR")
    0_1515044761397_7ac04894-5054-497e-bcce-8bcd041ae8ed-image.png

    rest of the field will calculate automatically.

    posted in Exchange Discussion read more