Cryptocurrency Excel Spreadsheet Tracker – CNCryptoNews

Financial news and views

Welcome to Finance! No Personal Finance, Homework, Personal blogs, or Career-related posts. All questions go in Monday Morning catch-all threads.
[link]

Advice for a novice bookkeeping contractor?

DISCLAIMER: I looked through the sub's rules and didn't see anything that forbid this kind of post. Please refer me to another source that can help if I am violating your rules. Also, I am NOT holding anyone liable for any advice given on this post. I am only looking to broaden my narrow perspective and protect myself as best as I can.
Now, sorry in advance if I ramble on but I'm still trying to sort this situation out in my head. Typing it out will help, but I'm thinking only questions, answers, and general discussion will help me.
I'm a college student in his mid-twenties looking for work. Recently I came across an ad online for a temporary bookkeeping contract. The client is a long-time entrepreneur and is currently trading crypto currency. They have a backlog of trades starting from January that need to be sorted and organized by by date, currency, cost basis, and profit. I am being contracted only to organize the books and track their taxable gains (as far as I know, hence novice). Once done the books will be sent to a CPA to file for the 2017 tax year.
A couple days ago I met with them at their house and had a brief, casual interview/conversation. We talked about the work as they gauged my understanding and comprehension ability while I sated my skeptical side (as best as I could). Today we met for just under two hours. We got into the meat of the work, actually working out cost basis, profit, and the like on some simple problems. At the end of the session they wrote me a check for $40 and it's currently pending.
The work seems pretty simple, but the situation seems a bit...off. I've talked with them openly about my inexperience with the work and I've been told they will train me regardless.
Now that we're past the exposition, the red flags.
  1. They are paying me $20/hr, and I am a college student (math major albeit), with no accounting experience. That rate includes training (literally a crash course in accounting, crypto trading, excel, and general investing). This seems too good to be true honestly, and I know the old addage.
  2. Throughout my own fact-finding I have learned they are Scientologists, so there is that whole stigma floating about. Now I'm not judging anyone based on their values, but subsequent research has revealed multiple situations where bookkeepers were pulled into fraud investigations involving Scientologists. Thus I feel there is genuine cause for concern on my part.
  3. They want me to sign a Non-disclosure (to protect their privacy presumably) and a 1099. The 1099 I'm not too worried about, but I am unsure of what to look out for in the NDA. Advice?
What I am looking for is general advice on whether or not I should continue. I have a couple interviews lined up for some office jobs paying around $15/hr, but needless to say the contractor's pay is much better, in addition to the knowledge, experience, and potential reference I can gain. I need money now which only weakens my position in this situation (but I am willing to walk away if convinced).
If I am to move forward, I'm concerned with how exactly I protect myself from liability in any IRS audit (I've found that the IRS will hold only them responsible but the whole crypto trading thing throws a wrinkle into that) and how to protect myself from any fraud investigations.
Any advice, redirects, referrals, questions, or answers are greatly appreciated.
Cheers.
submitted by Kazedeus to Accounting [link] [comments]

[X-post from /r/Accounting] Advice for a novice bookkeeping contractor?

DISCLAIMER: I looked through the sub's rules and didn't see anything that forbid this kind of post. Please refer me to another source that can help if I am violating your rules. Also, I am NOT holding anyone liable for any advice given on this post. I am only looking to broaden my narrow perspective and protect myself as best as I can.
Now, sorry in advance if I ramble on but I'm still trying to sort this situation out in my head. Typing it out will help, but I'm thinking only questions, answers, and general discussion will help me.
I'm a college student in his mid-twenties looking for work. Recently I came across an ad online for a temporary bookkeeping contract. The client is a long-time entrepreneur and is currently trading crypto currency. They have a backlog of trades starting from January that need to be sorted and organized by by date, currency, cost basis, and profit. I am being contracted only to organize the books and track their taxable gains (as far as I know, hence novice). Once done the books will be sent to a CPA to file for the 2017 tax year.
A couple days ago I met with them at their house and had a brief, casual interview/conversation. We talked about the work as they gauged my understanding and comprehension ability while I sated my skeptical side (as best as I could). Today we met for just under two hours. We got into the meat of the work, actually working out cost basis, profit, and the like on some simple problems. At the end of the session they wrote me a check for $40 and it's currently pending.
The work seems pretty simple, but the situation seems a bit...off. I've talked with them openly about my inexperience with the work and I've been told they will train me regardless.
Now that we're past the exposition, the red flags.
  1. They are paying me $20/hr, and I am a college student (math major albeit), with no accounting experience. That rate includes training (literally a crash course in accounting, crypto trading, excel, and general investing). This seems too good to be true honestly, and I know the old addage.
  2. Throughout my own fact-finding I have learned they are Scientologists, so there is that whole stigma floating about. Now I'm not judging anyone based on their values, but subsequent research has revealed multiple situations where bookkeepers were pulled into fraud investigations involving Scientologists. Thus I feel there is genuine cause for concern on my part.
  3. They want me to sign a Non-disclosure (to protect their privacy presumably) and a 1099. The 1099 I'm not too worried about, but I am unsure of what to look out for in the NDA. Advice?
What I am looking for is general advice on whether or not I should continue. I have a couple interviews lined up for some office jobs paying around $15/hr, but needless to say the contractor's pay is much better, in addition to the knowledge, experience, and potential reference I can gain. I need money now which only weakens my position in this situation (but I am willing to walk away if convinced).
If I am to move forward, I'm concerned with how exactly I protect myself from liability in any IRS audit (I've found that the IRS will hold only them responsible but the whole crypto trading thing throws a wrinkle into that) and how to protect myself from any fraud investigations.
Any advice, redirects, referrals, questions, or answers are greatly appreciated.
Cheers.
submitted by Kazedeus to AccountingDepartment [link] [comments]

I made a complete bitcoin spreadsheet (excel) with live crypto price updates, moon math, and a full history of your Portfolio and trading performance.

I made a complete bitcoin spreadsheet (excel) with live crypto price updates, moon math, and a full history of your Portfolio and trading performance.
This is a spreadsheet that I have developed for myself over the last year or so. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes) and how well my trading decisions have been (not great). I figure it's time to share.
There is a lot in here including;
Automatically updates prices from coinmarketcap. Nearly 2000 coins included. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.

https://preview.redd.it/zgsggn369pk11.png?width=602&format=png&auto=webp&s=8db3d0b1118d5d7b402988339f696e620a69f780
No need to record details of every trade. Just keep track of your bitcoin purhcases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time.

https://preview.redd.it/yqt28sf79pk11.png?width=602&format=png&auto=webp&s=c4b5c4aecc226cbc39139e4d5d050e0f7430a494

This data gets saved every time you save the spreadsheet.

https://preview.redd.it/b00vize89pk11.png?width=602&format=png&auto=webp&s=152d1a0698712941b643a063270174378f4bd6e5
I find this very handy to see if your trading is actually profitable compared to the HODL method.

https://preview.redd.it/0d8o7dba9pk11.png?width=929&format=png&auto=webp&s=e17d0f256465b24bb9c67a4e14a7ad55c9e0dc01

Oh yes and there are plenty of 'moon math' and analytics to see how bitcoin is trending and how far off you are from a lambo. This includes a full history of bitcoins price which updates every time you open the sheet.


https://preview.redd.it/pveh8ehb9pk11.png?width=602&format=png&auto=webp&s=e750e06735558f34a7bddcb13b2092f641f49db9
Also includes a bitcoin block countdown time (i.e number of days until halvening), and a 'regret calculator' among others.
free download from here. Instructions inside. You will need macros enabled (if you want it to do the fancy stuff).
https://www.dropbox.com/s/2n8xpn9r8oyetli/Cryptoprices9%20-%20For%20others.xlsm?dl=0
Let me know if you have any issues.
submitted by Fly115 to Bitcoin [link] [comments]

I made a complete crypto portfolio tracking spreadsheet (excel) with live price updates and a full history of your Portfolio and trading performance

I made a complete crypto portfolio tracking spreadsheet (excel) with live price updates and a full history of your Portfolio and trading performance
This is a spreadsheet that I have developed for myself over the last year or so. I have found it very helpful for keeping track of my crypto holdings (great for tax purposes) and how well my trading decisions have been (not great). I figure it's time to share.

There is a lot in here including;

Automatically updates crypto prices from coinmarketcap. Nearly 2000 coins. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.
https://preview.redd.it/ts3717egfkk11.png?width=602&format=png&auto=webp&s=c4ff0033cab639e9e8ae7809cba8faab4fa3173d

No need to record details of every trade. Just keep track of your crypto purhcases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time.
https://preview.redd.it/zeon8s8xfkk11.png?width=602&format=png&auto=webp&s=d60791ce434aa6c3b33cdda2f2bf8b22643b1b6d
This data gets saved every time you save the spreadsheet.
https://preview.redd.it/gne0jd2agkk11.png?width=602&format=png&auto=webp&s=4c4bd70ab88f597b66a5a552b111a160aedcf07d
I find this very handy to see if your trading is actually profitable compared to the HODL method.
https://preview.redd.it/x71gvgj2ikk11.png?width=929&format=png&auto=webp&s=0f7987b48997a97f18ad30aa53bad369de6ddab4
Oh yes and there are plenty of 'moon math' and analytics to see how bitcoin is trending and how far off you are from a lambo. This includes a full history of bitcoins price which updates every time you open the sheeet.

https://preview.redd.it/cyn98q63hkk11.png?width=602&format=png&auto=webp&s=094ee5528d48984b29f47e1aba9ba208f2086b4d
Plenty more bits and pieces that I have tinkered with over time.
free download from here. Instructions inside. You probably need a fairly recent version of microsft excel with macros enabled (if you want it to do the fancy stuff).
https://www.dropbox.com/s/2n8xpn9r8oyetli/Cryptoprices9%20-%20For%20others.xlsm?dl=0

Let me know if you have any issues.

submitted by Fly115 to CryptoCurrency [link] [comments]

I created a website where Crypto traders and investors could go to get easy access to datasets and trading tools. This platform would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.

https://spreadstreet.io
My name is John, and back in February of this year I started working on a website where Digital Currency traders and investors could go to get easy access to datasets and trading tools (such as add-ins, charting, and technical analysis templates). This platform would require no coding knowledge, and would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.
Quick About Me
I am a former Fortune 500 financial analyst, where I managed two $3 billion portfolios. I've been investing/trading since 2002/2003. If you take a look at my kindle cloud reader, you will see over 100 books dedicated to trading and investing of all sorts - technical analysis, fundamental analysis, daily options trading strategies, value investing, volatility trading, quantitative trading, algorithmic trading, and bullshit trading.
I think crypto is the future, and I believe that it is on an unstoppable path. My ultimate goal is to become a cost-leader in the field, and be tailored towards the individual investor. You shouldn't have to pay hundreds to thousands of dollars for top-notch tools.
Features at a Glance
Databases currently included (updated daily)
All datasets are available as a tab-delimited, CSV file. The datasets are a mix between raw tick data, OHLCV, spreads, mining and economic statistics. They can be used for backtesting, analysis, and charting.
Investing/Trading Templates and Strategies
On The Horizon
Potential Ideas
I'm open to answer questions or talk more about the project if there's interest. Hope it helps the traders and investors out there.
John
submitted by 1kexperimentdotcom to CryptoMarkets [link] [comments]

I made a complete bitcoin spreadsheet (excel) with live crypto price updates, moon math, and a full history of your Portfolio and trading performance. /r/Bitcoin

I made a complete bitcoin spreadsheet (excel) with live crypto price updates, moon math, and a full history of your Portfolio and trading performance. /Bitcoin submitted by ABitcoinAllBot to BitcoinAll [link] [comments]

#XCARD is the platform that provides an excellent trading and payment environment for converting cryptocurrencies by implementing an intelligent atomic swap system. #mbmtoken #Blockchain #Crypto #Payments #BTC #fintech #cryptowallet #cardpayments http://xcard.io/

#XCARD is the platform that provides an excellent trading and payment environment for converting cryptocurrencies by implementing an intelligent atomic swap system. #mbmtoken #Blockchain #Crypto #Payments #BTC #fintech #cryptowallet #cardpayments http://xcard.io/ submitted by phungploi to xcardbymobilum [link] [comments]

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel www.youtube.com

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel www.youtube.com submitted by ingebo to Bitcoin_News [link] [comments]

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel www.youtube.com

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel www.youtube.com submitted by ingebo to YOLO4LIFE [link] [comments]

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel submitted by ingebo to CryptocurrencyICO [link] [comments]

BIZpaye is excellent project. it has a good potential .there is lots of hope from this project. I'm sure it will success! Initially, they succeeded in the IEO on DOBI exchange! Go to DOBI and check with CRYPTO/BTC trading pairs!

BIZpaye is excellent project. it has a good potential .there is lots of hope from this project. I'm sure it will success! Initially, they succeeded in the IEO on DOBI exchange! Go to DOBI and check with CRYPTO/BTC trading pairs! submitted by Dexis202 to AllThingsCrypto [link] [comments]

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel submitted by ingebo to btc [link] [comments]

Decoin is a fast rising crypto exchange built with maximum security and excellent support for users in mind. Decoin is a next generation digital assets trading platform that will benefit both new and experienced traders.

Decoin is a fast rising crypto exchange built with maximum security and excellent support for users in mind. Decoin is a next generation digital assets trading platform that will benefit both new and experienced traders. submitted by AbaYomiOla to CryptoCurrencies [link] [comments]

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel www.youtube.com

Crypto News: How to analyze and track your cryptocurrency trading portfolio live using Excel www.youtube.com submitted by ingebo to WealthMindset [link] [comments]

ADAB is excellent project is the crypto currency market place .this is uniqe and very secure platform for the investment.#Adab #Muslims #investments #crypto-economy #Islamic #finance #cryptocurrency #exchange #FICE #Shariah#trading #cryptocurrencies

submitted by rickyis786 to adabsolutions [link] [comments]

#ooobtc #obx #crypto #bitcoin #ethereum #blockchain #btc #toqqn Your project is developing very quickly. Your team shows fast and excellent results. Good ideas! https://www.ooobtc.com/trading

submitted by Alex-Sem to toqqn [link] [comments]

koinex india shutting down is terrible news for the Indian #crypto community. An excellent exchange goes down. We welcome users of Koinex to COSScrypto. Quick sign-up process. $COS token holders are entitled to 50% of trading fees generated through our Fee Split Allocation.

koinex india shutting down is terrible news for the Indian #crypto community. An excellent exchange goes down. We welcome users of Koinex to COSScrypto. Quick sign-up process. $COS token holders are entitled to 50% of trading fees generated through our Fee Split Allocation. submitted by lalaworldmod to LaLa_World [link] [comments]

#ooobtc #obx #crypto #bitcoin #ethereum #blockchain #btc #toqqn Your project is developing very quickly. Your team shows fast and excellent results. Good ideas! https://www.ooobtc.com/trading

#ooobtc #obx #crypto #bitcoin #ethereum #blockchain #btc #toqqn Your project is developing very quickly. Your team shows fast and excellent results. Good ideas! https://www.ooobtc.com/trading submitted by bluelagoon88 to CryptoCurrencyTrading [link] [comments]

#ooobtc #obx #crypto #bitcoin #ethereum #blockchain #btc #toqqn Your project is developing very quickly. Your team shows fast and excellent results. Good ideas! https://www.ooobtc.com/trading

submitted by Alex-Sem to toqqn [link] [comments]

#ooobtc #obx #crypto #bitcoin #ethereum #blockchain #btc #toqqn Your project is developing very quickly. Your team shows fast and excellent results. Good ideas! https://www.ooobtc.com/trading

submitted by Alex-Sem to toqqn [link] [comments]

#ooobtc #obx #crypto #bitcoin #ethereum #blockchain #btc #toqqn Your project is developing very quickly. Your team shows fast and excellent results. Good ideas! https://www.ooobtc.com/trading

submitted by Alex-Sem to toqqn [link] [comments]

#ooobtc #obx #crypto #bitcoin #ethereum #blockchain #btc #toqqn Your project is developing very quickly. Your team shows fast and excellent results. Good ideas! https://www.ooobtc.com/trading

submitted by Alex-Sem to toqqn [link] [comments]

Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet CellBot - Excel Crypto Trading Bot - YouTube Planilha Excel para trader Bitcoin 100% GRATUITA - Aumente seus lucros com trade! Excel Crypto Trading bot for Binance Crypto spreadsheet - Download link in description - YouTube

Introducing Cryptosheets, the world's first real-time cryptocurrency data add-in for Microsoft Excel. Discover the program thousands of traders are using on a daily basis. Cryptosheet is intuituve to use, but we’ve included a user guide that explains exactly how to input your crypto transactions into the spreadsheet. Ease-of-use was a top priority, and providing easy-to-follow instructions is part of that effort. I wrote my own fiat/crypto/precious metals tracker in PHP/mysql. I made it for my own purpose. I preffer to write something once, and don't waste time later on to update rates in Excel, everytime. While it was ready, I placed it on the server for everybody: https://assetbalance.info. You are welcome to use it. Crypto Currency Trading vs Betfair Trading: • CellBot works very similarly as our Betfair Excel Bots. You can try your already made betfair strategies on CellBot with some modifications. • However, Betfair’s trading fee is at least 2-5% !While Binance‘s trading fee is only 0.075% per trade! it’s much easier to make profit on a much lower fee market! Track Your Bitcoin & Crypto Profits in Excel for 2020 3.8 (7 ratings) Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.

[index] [146] [922] [359] [219] [904] [528] [669] [1012] [983] [804]

Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet

Excel Crypto Spreadsheet (Free Download) - Imports Current Price of Each Coin from the Web ... Trading Journal - My Excel Spreadsheet Trading Journal (+ Free Trading Journal Spreadsheet ... https://CryptoInvestingInsider.com Click to get our free course and see how to make high returns in the cryptocurrency space. https://CryptoInvestingInsider.... CellBot - Excel Crypto Trading Bot Recommended for you. 10:10. Estrategias de Day Trade para Iniciantes - Duration: 26:56. Jota Trader 79,039 views. 26:56. Pivot Table Excel Tutorial - Duration ... TOP 5 Cryptocurrency Trading Bots - Crypto Trading Bot Review - Duration: 8:09. Marc Zwygart 234,035 views. 8:09. ... Cryptocurrency Excel Spreadsheet Tracker - Duration: 7:29. The Excel Trading Bot is a tool designed to execute Trading Signals from my tradingview script Ultimate Crypto Trading Strategy into Binance exchange.

#