 Show Posts
|
|
Pages: [1] 2 3 4 »
|
ito yung code ko to get the coins.ph rates directly from my google sheets file: sa google sheets file nyo click TOOLS >> SCRIPT EDITOR and paste this code below. function updateCoinsPH() {
var btcphp = UrlFetchApp.fetch("https://quote.coins.ph/v1/markets/BTC-PHP");
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("buy");
var c1=JSON.parse(btcphp.getContentText());
sheet.getRange(1, 3).setValue(c1.market.ask);
sheet.getRange(1, 4).setValue(c1.market.bid);
}Once ma paste nyo na code, click nyo yung project trigger (yung icon na prang CLOCK TIMER) then ilagay nyo 1 minute interval para sa pag refresh ng rate. pwede nyo din baguhin like every 5 mins or something na gusto nyo. How to read the above code? dun sa .getSheetByName("buy") palitan nyo na name ng sheet nyo kung saan nyo gusto ilagay yung coins.ph rate. sheet.getRange(1, 3).setValue(c1.market.ask); ito naman yung BUY rate sa coins.ph, yung number 1 is row number yan, yung 3 yan yung column number. so ikaw na ma decide kung saan mo ilalagay yung na row at column base sa design mo. sheet.getRange(1, 4).setValue(c1.market.bid); same din dito. sa coins summary naman ito codes ko: para sa real time rate ito code ko: =CRYPTOFINANCE("BITTREX:BTC/USDT", "price", "", $L$1)so ilalagay nyo yan sa cell ng coin na gusto nyo makuha rate. palitan nyo lang yung exchange na gamit nyo at yung trading pair and ok na yan. yung logo ng bawat coin ito naman code: =IMAGE("https://files.coinmarketcap.com/static/img/coins/32x32/bitcoin.png", 1)so baguhin nyo lang yung name ng png file like ethereum.png for ethereum or litecoin.png for litecoin and so on. yung name ng file kinuha ko yan sa coinmarketcap kung ano ginamit nila sa code nila sa website. yung SYSMBOL column ko sa coin summary nilagay ko lang yan so type nyo lang name ng coins. yung QTY yan yung bilang ng coins nyo so either may link kayo form another spreadsheet or just type it lang. then yung AMOUNT formula lang yan by multiplying QTY and PRICE. ok guys pag may question ask nyo lang. Thanks Salamat po ulit sa very informative share, question lang po, pwede po ba set yung refresh nong CRYPTOFINANCE like every mins? off topic: Meron bang lumalabas na graph kay bittrex sa inyo? kanina pa ako clear nang clear nang cache/cookies ko, ayaw na lumabas nong graph, sinobukan kuna din sa ibang browser ayaw parin. |
|
|
|
|
Does anyone also experiencing Bittrex graph not showing? I already tried 2 different browser and its still the same, I did also did clear the cache and cookies but its still the same.
|
|
|
|
Hi there! I just need your advice. I invested the money instead of paying my school fees. Yeah, i know this is wrong because education is more important to us and it can't be stealed from us, i'm still studying but my fees will be doubled on the next payment. But i believe this will end a good result. What do you think about this ? Your advice will be highly appreciated. Thanks!
Even the people I personally know who's been in trading for a long time still suffered loses from time to time in trading because of its unpredictable price but here you are taking a bold risk. Goodluck buddy! |
|
|
|
Hello,
I kwow it is profitable to buy when the price is low and sell when the price is high.
What I see in the currency exchange I am trading on are 24 hr percentages.
Sometimes the percentages show a 'minus' -, and sometimes they show a 'plus' +.
Is it a goog idea (when you think in terms of profit) to buy a coin when the percentage shows for example -5% and then sell when the percentage shows +5%?
Thanks
Its a good idea to buy when the price percentage is negative but NOT the idea that you have that when you buy at -5% then sell it at +5%, you will gonna stock in that coins for a long time. The percentage shown in exchange is not what you think it is, so better study the candle stick and make youre own calculation base on the candle stick. |
|
|
|
Hi everyone, I'm just start trading and I don't have too much experience in chart or technical analyse. So I joined some signal groups with monthly fee. Is it good, in your opnion? I hear about Alanmaster and his VIP signal, anyone hear about him or join his VIP member. Since I want to try so it's good if I have some feedback about it. Thanks  I haven't joined a paid signal group but I joined a free signal group (which later on, turn-out paid group) and with my experience I can say that it wont help you grow as a trader. The best you can do is learn little by little, dont rush, dont be afraid to make mistake. All signal group have common factor, they only give signal when the price of coin/s is RED, which is you can simply do it yourself without joining any signal group. |
|
|
|
If you believe you have already have enough knowledge in trading then go for it, if not then read/learn more. And as many advice, Dont invest what you CANT afford to lose. |
|
|
|
I'm new to cryptocurrency trading and still I'm leaning it. I watched some YouTube videos and learnt something about day trading. But, I think still it is not enough to ehter to the market. I want to learn some strategies which make more profits. Please tell me, if anybody knows a good place to learn day trading, candlestick chart analysis and those things.
Day trading is a "High Risk, High Return" strategy, my only advice is dont be greedy, set youre goal to minimum, when you get lucky trade DONT ASSUME you get the pattern and go all-in because there is no pattern and youre just lucky. |
|
|
|
|
bitcoin still considered an unsecured investment, one of the reason why our government reluctant to support cryptocurrencies. Even thou bitcoin itself is safe from hacker, we cant denied that possibility exist that one day bitcoin will be gone like bubble because it live in digital world and we dont have hard copy of our investment.
|
|
|
|
|
Government banned (or not supporting) bitcoin because
1. They dont gain tax from bitcoin.
2. Its decentralized, they cant control it.
3. Its not a secure investment.
|
|
|
|
|
"You can ride the dump but NEVER ride the pump" when you see the price is all red (or some called it bloodbath) you can buy coins without worry (except for shitcoin of course) thats the start of the dump, BUT when you see the price started to green and you did not start from the dump price, NEVER buy from that coin or never attempt to join the pump. This is a lesson i learned the hard way.
|
|
|
|
|
I really doubt there is such a tool, if it does, then trading is not profitable as today. There is no easy way in trading, you have to learn it yourself either the easy way by reading some experts advice or the hard when you make mistake. Also since you are looking for that kind of tool, i think you will stumble in a thing they called "Signal Group" and be advice it will not do any good so dont fall for there bit.
|
|
|
|
|
there is no way to know the "exact" price of any coin because the developer of coins does not control the price but the trader/holder/buyer/seller itself, its not centralize so no one control the price. Price will always vary from different different exchange.
|
|
|
|
|
If you compare the growth of top altcoins like ETH and LTC to BTC you can see that altcoins grow faster than BTC in its time. So given about 2-3years with the current speed growth of ETH maybe the price of ETH will be much higher than the BTC.
|
|
|
|
Hi,
there are so many cryptos and I find it hard to identify the ones where I should have a closer look.
Obviously one can find cryptos e.g. by listening to shilling on Reddit. But I'm looking for more professional sources like YouTube channels, free/ paid Telegram/Discord groups and so on. What do you use?
To find a good crypto to invest in, you should do you're own intensive research in crypto itself and dont depend on other opinions. I think what you are looking for is a "Signal Group" but be advice that this group does not do any good, if you want to stay long in Cryto Trading then its best if you learn it yourself how the market move. |
|
|
|
|
No one really knows how deep a coin will fall or how the coins will jump high, everyone has there own speculation base on experience and I would suggest you too should built youre own speculation
|
|
|
|
|
Just think of if as expensive lesson, Its not a waste since it taught you a very important lesson. It might be possible to return to the price you bought it, but who knows when will it come? specially if you bought it during its highest pump price? Next time stick to top 100 coins and dont be fooled again
|
|
|
|
|
I was waiting for this price down since my friend told me, almost every January BTC price will be drop down and it would be the best chance to profit, then 2 days ago market price start to turn red, good coins start to drop down by 15%, and thought to myself this is the moment, use all my reserve funds to buy coins, then yesterday market price drop down drastically! F^*&CK!!! If only I knew that 2 days ago price drop down is only tip of an iceberg!!
So to my fellow HODLer! A little bit more and the market is recovering
|
|
|
|
Do the exchanges charge fees if you send an order and cancel it before it gets filled?
In Cryptopia it doest not. Also i really doubt any exchange will charge you fee when you cancel order, If it does, then you will lose all youre investment in "cancel fee" rather than you lose you're investment because the price of coins falls down. |
|
|
|
|
this current bloodbath is just like a tip of an iceberg, a few days ago when the price of almost coins started to drop down I just use all my reserve funds to buy coins hoping I will do a good trade since the price of coins is low but then yesterday it drop down drastically beyond expectation. Lucky for those who buy at very low price. Hopefully it will recover soon
|
|
|
|
|
