Bitcoin Forum

Other => Beginners & Help => Topic started by: Jeremiah on May 15, 2013, 10:43:48 AM



Title: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: Jeremiah on May 15, 2013, 10:43:48 AM
Hey guys/gals.

I'd like to share my bitcoin excel calculator, I had an hour break at uni so I thought it would be fun to make.

It calculates $ and bitcoin return based on original bitcoin investment and buy / sell prices over a period of 21 days. Handy for people who want to BUY LOW and SELL HIGH (make quick buck lol).

Variable: Input your original bitcoin investment in the [ orange box ]
Variable: buy / sell prices in the [ red box ].

The [ blue box ] is the $ amount at the end of 21 days.
The [ purple box ] is the bitcoin amount at the end of 21 days.

The default data in the excel is based on someone who buys bitcoins low at 100 and sells at a high of 120 over a period of 21 days. They started with 10 bitcoins to invest.

Give it a look, play around by changing the Variables [ orange box ] and [ red box ]. Let me know what you guys think, it's just something I made which during a lunch break so go easy :P

Dropbox Download Link: https://dl.dropboxusercontent.com/u/10258824/BTC%20CALCULATOR.xlsx

Thanks. 


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: giulianoob on May 15, 2013, 11:29:05 AM
Virustotal scan result:
https://www.virustotal.com/en/file/2f09285ac96a5cfab1350f81bddfcb42d59d3fd244d38473b3b50c18048527cd/analysis/1368617289/ (https://www.virustotal.com/en/file/2f09285ac96a5cfab1350f81bddfcb42d59d3fd244d38473b3b50c18048527cd/analysis/1368617289/)


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: Adam Chance Micro Finance on May 15, 2013, 11:59:30 AM
Virustotal scan result:
https://www.virustotal.com/en/file/2f09285ac96a5cfab1350f81bddfcb42d59d3fd244d38473b3b50c18048527cd/analysis/1368617289/ (https://www.virustotal.com/en/file/2f09285ac96a5cfab1350f81bddfcb42d59d3fd244d38473b3b50c18048527cd/analysis/1368617289/)

From the results, it seems a mixed bag of either no detection, or what appears to be a macro virus. Any thoughts?


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: f6gau on May 15, 2013, 12:37:19 PM
Is it safe or not?


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: Jeremiah on May 16, 2013, 12:58:34 PM
Haha guys this file is not malicious. I think Virustotal is probably getting false positives. I'm surprised no one tried any other scanners, but I did just to double check in case there was that I, myself didn't know about. Screenshot below. I used http://virusscan.jotti.org/ which checks with Sophos, ESET, F-Secure and Kaspersky to name a few.
Well if you do decide to have a look at it, let me know what you think. Cheers.

https://i.imgur.com/BeJbvDk.png | Results page. (http://virusscan.jotti.org/en/scanresult/e10ec18df454efa0d38d9928b65b22a5cf2c5339)


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: kaddyd on May 16, 2013, 01:14:59 PM
Maybe will be better if you'll write HTML/Javascript version?


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: Jeremiah on May 16, 2013, 01:56:36 PM
Maybe will be better if you'll write HTML/Javascript version?

Ye I was planning on coding it up, but I wanted some feedback first. I'll defs code it when I'm off uni in a few weeks.


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: nick7 on May 16, 2013, 02:14:55 PM
There are no macros in the workbook. No suspicious activity detected and no suspicious network traffic from the VM, but there's something strange happening in E3:E23.


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: Jeremiah on May 16, 2013, 02:30:02 PM
There are no macros in the workbook. No suspicious activity detected and no suspicious network traffic from the VM, but there's something strange happening in E3:E23.

Thanks for checking Nick. Regarding the sell values inside cells E3:E23 I clicked on E3 and dragged down to E23 which fills all the cells in between with the same value, pretty basic excel stuff really... but maybe that's what you're detecting.

If anyone is interested you can follow me on Twitter: https://i.imgur.com/79NYxKb.png (https://twitter.com/TheKirribilli)
I have a fairly good following on Twitter, and since I also posted this same excel on Twitter, I'm fairly sure they would of found something by now (which they haven't because there's nothing malicious lol).

 


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: nick7 on May 16, 2013, 02:36:16 PM
Thanks for checking Nick.
No problem... but I was really hoping you'd managed to trojan it, or snuck in a few lines of malicious code amongst a bunch of legit VBA.

Regarding the sell values inside cells E3:E23
I was mostly joking in an attempt to point out that you'd used a formula to set static value.


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: Jeremiah on May 16, 2013, 03:30:45 PM
Quote
No problem... but I was really hoping you'd managed to trojan it, or snuck in a few lines of malicious code amongst a bunch of legit VBA.

I'm really glad to see members actually engaging and being diligent.

Quote
I was mostly joking in an attempt to point out that you'd used a formula to set static value.

haha, ye that was actually in cells C3:C23 ... I was probably planning on doing something 'fancier' in the buy/sell cells but I forgot and just left the formula as 100x1 lol. No biggy :)


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: reich on May 16, 2013, 03:33:58 PM
Hey guys/gals.

I'd like to share my bitcoin excel calculator, I had an hour break at uni so I thought it would be fun to make.

It calculates $ and bitcoin return based on original bitcoin investment and buy / sell prices over a period of 21 days. Handy for people who want to BUY LOW and SELL HIGH (make quick buck lol).

Variable: Input your original bitcoin investment in the [ orange box ]
Variable: buy / sell prices in the [ red box ].

The [ blue box ] is the $ amount at the end of 21 days.
The [ purple box ] is the bitcoin amount at the end of 21 days.

The default data in the excel is based on someone who buys bitcoins low at 100 and sells at a high of 120 over a period of 21 days. They started with 10 bitcoins to invest.

Give it a look, play around by changing the Variables [ orange box ] and [ red box ]. Let me know what you guys think, it's just something I made which during a lunch break so go easy :P

Dropbox Download Link: https://dl.dropboxusercontent.com/u/10258824/BTC%20CALCULATOR.xlsx

Thanks. 
. Wow thats awesome


Title: Re: My Bitcoin calculator: Calculate $ & BTC return based on original BTC investment
Post by: Jeremiah on May 16, 2013, 03:51:04 PM
Quote
Wow thats awesome

Thanks :)