Crypto Day Trading Spreadsheet akademiexcel.com

Percentage Based Crypto Portfolio Template

Dear Crypto friends!
Every few months I mention on Reddit how I use a percentage based portfolio management strategy and that I believe it is the "right" way to manage your portfolio. When this comes up I mention the google sheets document I've created over the past three years to organize, view, and react to my portfolio. Every time somebody asks me to share this document, but doing so takes a lot of effort and I've been too lazy. Well last night it happened again and this morning I finally wasn't too lazy. So without further ado here is a way too long post about how I view finances and why I believe you should try to adapt my strategy to fit your needs.
*First things first, I am not a financial advisor, I am an internet bozo that you have never met. Don't invest more than you're willing to lose, do your own research, not your keys not your coin, feel free to comment more cliches and I can add them here.*
I adhere to the belief that the very first step to proper financial management as an adult is to create a monthly budget for your life. I have used mint for years as a way to track my spending and help me figure out what a realistic monthly budget for my lifestyle is. Once I feel good that my monthly budget is accurate I put 3 months worth of my budget in my traditional credit union savings account, 1 months worth in my traditional checking account and then I direct deposit my paycheck into a third traditional savings account. I then place 3 more months of my budget into a high interest DeFi account. Now I want to pause here because everyone comes from very different financial backgrounds. We all hear "Don't invest more than you're willing to lose" but nobody likes to define this. Regardless of how you feel about USD stability (if you're in this community it's probably because you don't trust fiat) most "experts" believe you're first financial priority as an adult is accumulating a 6 month emergency fund. We live in crazy times and if the past 3 months didn't convince you that an emergency fund is necessary I don't know what to say. I understand that even if you have a minuscule $2,000 a month budget(good luck getting a studio apartment in NYC?) my strategy requires $14,000 before you even start investing in crypto. That is way more than most people actually have and I completely empathize if you are unwilling or feel unable to wait until you have that. If you absolutely can't wait that long, I hope you at least start building towards your emergency fund using a high interest DeFi account (I recommend Nexo, Blockfi or DefiSaver). I am not a financial advisor!
Now that I have my bank accounts set up, it is time to invest in my favorite cryptocurrencies. Everyone has their own rules (DYOR!) my rule is, I only invest in coins I use. So for example I feel the C20 token is extremely interesting and I have thought about buying some, however it is an index fund not something I can spend, so at this time I'm not investing in it. I also feel EOS/Steller and some other chains are also really interesting, but same issue, I don't actually use them. What do I use? Personally I regularly spend USD(no shocker there), BTC (I've recently gotten into using the lightning network using the FOLD app), ETH(God's Unchained is better than Hearthstone, fight me!), BCH (Purse has been great!), Nexo, BNB, and Dash. Ok I don't actually spend Dash. Eventually I think I'm going to switch Dash to Monero, but either way I feel holding a privacy coin during extreme civil unrest is reasonable.
I'm definitely not here to say one coin is better than another and that my choices are correct. If you want to tell me how much of an idiot I am for using the lightning network or that spending bcash is a scam feel free to do so in the comments, just know that I don't care and I wont read them. DYOR!!
Once you have the coins you would like to hold I believe you should set a target % that you want each coin to take of your total portfolio. You can do this by saying everything is equal at 10% or as I do where each coin has it's own target percentage based on how I feel about them. DYOR!!! If the roller coaster meme gets posted and your actual percentage held goes from 10% to 15% using my strategy you would sell off that 5% and distribute it to a coin that hasn't skyrocketed(yet!). Conditional formatting in the document triggers a Green fill when a coin passes 103% of it's target % and a Red fill triggers when a coin drops below 96% of it's target %.
That's it, that's my strategy. When the market goes up I trade for some USDC and when it goes down I spend that USDC to accumulate units for the next bull run. It is very simple, but forces you to not care about fancy technical analysis or dollar averaging. Just buy when the market tells you to buy and sell when it tells you to sell. At the end of each day I click the "History" tab, copy the days data and "paste values only(Ctrl+Shift+V)" on the bottom row. When my paycheck comes in I top off my checking account to a full months budget then look to see how much my sheet recommends sending from my traditional bank account to my DeFi savings account.

Those of you who are interested I'm attaching a link to my google sheet. It is going to be able to be viewed but not edited so you will need to duplicate it to your own account to use yourself. I have added lots of tiny notes to explain different sections and help you learn how to interact with the data. One issue that may arise is if you try to copy paste the sheet. When pasting formulas, if you go to copy and paste and are only getting values click "view > show formulas" then copy paste. You wont get my many notes and pretty formatting but it's a start. Another issue is with adding the "CRYPTOFINANCE()" script. For instructions and more information. Hopefully you'll be able to duplicate this document without issue, but if not let me know and I'll do my best to troubleshoot. I'm really proud of this document and have put a lot of time and effort into it the past 3 years, so please be kind in your criticisms but by all means give me advice on ways I can improve it more.
Percentage Based Crypto Portfolio Template

I hope you found this interesting and useful,
Sincerely,
Clark Kent

Edit: One tidbit that I forgot to touch on but that is absolutely necessary to share. The cyptofinance() data pull method isn't perfect. It is not unreasonable for the prices it shares to be 20 minutes delayed. For this reason you should only use the document as a guide. Double check that the price of the coin it is telling to sell is still close to what the document believes it is.
submitted by TnekKralc to CryptoCurrency [link] [comments]

[USA] [H] Rule of Rose, GB/GBC/GBA, Genesis, NES, SNES, N64, PS1, PS2, PS3, Xbox, DS, Gamecube, Atari 400/2600!, PP [W] PayPal Invoice/Zelle/Crypto/Looking to buy rare PS1 & PS2 Games

Hey Guys welcome to my sales/trade thread! Everything has been priced according to PriceCharting/ebay I am willing to negotiate when you buy a couple.
Feedback Thread
My forms of payment are PayPal Invoice or Zelle/Crypto if you feel comfortable. I Pay for shipping on all items. I'm here to do clean/honest business. Also before doing a trade/sale I will make sure who I'm dealing with and make sure a clean transaction will be made.
I will not take transactions less then $20
I will try to get back to everyone in a timely manner so please bare with me!
As per rules, I require everyone to post wants on the thread and discuss in thread. We will transfer over to PM when a deal has been made and ready for payment. If anyone has any questions please feel free to message me.
Disclaimer I do not have a NES/Genesis I have been trying to buy one to test all games, but haven't found any reasonably price so I will be selling those games as is, I can on the other hand insure every other games from the other systems working. I can also open up cartridges, but please be courteous don't ask me to open up low priced items. I will be glad to take as many pictures as you need to ensure happiness.
If allowed I will post a link to my google doc with everything laid out in a much more neat manner as I just copied and pasted from the spreadsheet because it would take me to long otherwise to create a template. I know it looks terrible so please bare with me and ask any questions! Thank you.
Vlexy's Collection

Also Looking to buy these games:
Want List
Main wants so far: PS1 and Ps2 only (CIB & NTSC) Preferred please! As follows:
Castlevania symphony (Case only)
D Case only
Lunar Silver Story
Intelligent Qube
Pepsi Man
LSD
Clock Tower 2
Echo Night Beyond
Echo Night
outrun 2006
DBZ tenkaichi 3
Marvel Vs Capcom
Marven Vs capcom 2
Shadow Tower
Tail Concerto
Castlevania Chronicles
Ghost in the shell
Marvel Super heroes Vs Street fighter
Parasite eve 1 & 2
Kuon "Maybe" It would really depend the trade and value.
And many more games that I can't think of as of right now! Let me know what you got.

::FOR SALE::
Rule of Rose w/Box $220 (Please see images for condition) Only looking to take Zelle for this game.
Disclaimer:: the game has a slight crack on the disk hub/inner disk ring. It does not affect the gameplay of the disk what so ever. If you take care of the game you should be fine with owning it. The data part of the disk itself has very minimal to no scratches almost minty. No manual and the covert art has water damage not visible from the front. If you have any questions please message me!

::Consoles/bundles/Misc::

Atari 400 w/16 games want $150 Shipped
PS1 Bundle $40 (I can also bundle it with different games if you want depending the games it'll be lower or higher price)
Nintendo 3ds XL NES Edition $85 shipped

::NES::

Air fortress Loose $5
AirWolf Loose $5
Friday the 13th Loose $9
Hogans Alley Loose $6
Iron Sword Wizards and Warriors II Loose $4
Jaws Loose $8
life force Loose $10
Magmax Loose $5
Metroid Loose $11
Milons Secret Castle Loose $7
P.O.W Loose $6
R.C Pro-AM Loose $6
Rampage Loose $11
Rush'n Attack Loose $6
Silius Loose $30
Section Z Loose $16
Sky Shark Loose $5
Spy Hunter Loose $4
Star Soldier Loose $8
Star Tropics Loose $10
The adventures of Link Loose $14
The Guardian Legend Loose $13
Top Gun Loose $5
Ultima Loose $8
Wizards and Warriors Loose $6
Xevious Loose $6
Zanac Loose $13

::SNES::

Arkanoid doh it again Loose $11
Batman Forever Loose $7
Batman Returns Loose $14
Biometal Loose $32
Chess Master Loose $4
Darius Twin Loose $12
Drakkhen Loose $7
Gunforce Loose $18
Jurassic Park Loose $8
Mario Paint Loose $9
Final Fantasy Mystic Quest Loose $14
knights of the Round Loose $60
P.T.O Loose $13
Phalanx CIB $55
Robotrek Loose $50
Secret of mana Loose $40
Star Fox Loose $13
Super Battleship Loose $2
Super Empire Strikes Back Loose $10
Super Ghouls 'N Ghost Loose $21
Super Mario All stars Loose $13
Super Mario World Loose $12
Super Star Wars Loose $8
The 7th Saga Loose $15
UN Squadron Loose $20
Wing Commander Loose $6

::N64::

Jet Force Gemini Loose $12
Star Soldier Vanishing Earth Loose $28
Star Wars rogue Squadron Loose $9
Star Wars Shadows of the Empire Loose $7
Wave Race Loose $6
XG2 Loose $6
Goin Quackers loose $20
Mario Party 2 loose $35
Mario 64 $15 repo cartridge

::Genesis::

Air Diver Loose $4
Cyborg Justice Loose $7
Ecco the dolphin Loose $8
F-15 Strike Eagle 2 Loose $4
Jurrasic Park Loose $6
Lightning Force Quest for the darkstar Loose $38
Robo-kid Loose $12
Sonic 2 Loose $5
Sonic Spinball Loose $5
Sonic The Hedge Hog Loose $6
Super Battleship Loose $2
Thunder Force 3 Loose $37
TMNT - Hyperstone Heist Loose $45

::GBA::

Ace Combat Advance Loose $4
Batman Begins Loose $5
Bruce Lee Return of the legend Loose $4
F-14 Tomcat Loose $3
F-A 18F Loose $3
Iridion 2 Loose $32
Iridion 3D Loose $5
Kirby Nightmare in dreamland Loose $16
Mega man Zero 2 Loose $17
Monster Trucks Loose $4
Need for Speed Carbon Own the city Loose $5
Phantasy Star Collection Loose $13
Saber wulf Loose $13
Sim city 2000 Loose $9
Spy Hunter Loose $4
Star Wars Flight of the falcon Loose $4
Star Wars trilogy Apprentice of the force Loose $7
Super Hornet Loose $3
ThunderBirds Loose $3
Top Gun Firestorm advance Loose $3

::GB::

AladdinLoose$6
Donkey Kong Country Loose $9
Donkey Kong Land Loose $7
Game & Watch Gallery 3 Loose $6
Gex Loose $3
Hot wheels stunt track driver Loose $3
Pokemon Blue Loose $20
Pokemon Crystal Loose $35 (No front label sticker)
Pokemon Gold Loose $22
Pokemon Green (Repro) Loose $10
Pokemon Red Loose $22
Star Wars Yoda Stories Loose $8

::PS1::

007 the world is not enough CIB $7
Autin Powers Pinball CIB $4
Descent CIB $8
Descent Maximum CIB $10
jet Moto 2 CIB $7
Killer loop CIB $5
40Nitrous Oxide CIB $8
Novastorm CIB $20
Nuclear Strike CIB $6
Resident Evil 2 CIB $25
Silent Hill 1 CIB Minty $60
Shockwave Assault CIB $1
Star Wars rebels assault 2 CIB $6
Tunnel B1CIB $6
twisted metal 2 CIB $17
Warhawk CIB $15
Wing Commander III Heart of the Tiger CIB $20
Wing Commander the price of freedom CIB $14

::PS2:: (Very Negotiable if buying a few)

Alter Echo CIB $5
Antigrav CIB $4
Bad boys Miami Takedown CIB $4
Baldurs Gate Dark Alliance $12 W/Case/Missing manual
Battlestar Galactica CIB $8
Champions Norath Loose $15
Chaos Legion CIB $10
Demon Stone CIB $7
DT Racer CIB $3
Everblue 2 CIB $12
Final Fantasy x CIB $5
Ford VS Chevy CIB $3
God of War CIB $6
Gran Tursimo 3 CIB $4
GTA San Andreas CIB $8
GTA Vice city CIB $4
Hypersonic Extreme CIB $5
IHRA Drag Racing 2 CIB $3
Jaw Unleashed CIB $8
Kengo Master Bushido CIB $6
Mace griffin Bounty Hunter CIB $4
Medal of Honor Eurpoean Assualt CIB $4
Midnight club 3 remix CIB $12
Mortal kombat Deadly Alliance Loose $5
NBA Street Loose $5
NBA Street Vol. 2 CIB $15
NHL 06 CIB $3
Pro Race Driver CIB $3
R:Racing Evolution CIB $6
Read Dead Revolver CIB$9
Resident Evil Code:Veronica x CIB $8
RUNE: Viking Warlord $6 W case/Missing manual
S driving emotion Type-S CIB $5
Silent hill 3 Loose$30
Silent hill originsLoose/W Manual $25
Splash Down Rides Gone Wild CIB $7
Splinter Cell Pandora tomorrow Loose $3
SRS Street Racing syndicate CIB $10
Sub Rebellion CIB $10
Super Trucks Racing CIB $3
Suzuki TTSuperBikes CIB $3
The Incredibles Loose/W Manual $4
TMNT CIB $10
Top Gun CIB $3
Transformers the game CIB $4
Ultimate Board Game collection CIB $3

::XBOX:: (Very Negotiable if buying a few)

Bloodrayne 2 CIB $12
Dead or Alive 3 CIB $6
Halo 2 CIB $5
Halo 2 Collectors edition CIB $12
Taito Legends CIB $9
Dark Summit CIB $5
Doom 3 CIB $7
Tony Hawk pro Skater 2x CIB $13

::Gamecube::

NCAA football 03 CIB $3
Donkey Kong Jungle Beat CIB $12
Donkey Konga 2 CIB $9
Def Jam loose $50

::PS3::

Bayonetta $9
Def Jam icon $12
Fracture $5
Gran Turismo 5 XL Edition Sealed $18
Minecraft $13
Silent Hill Homecoming $11
The beatles rockband Sealed $10

::DS::

Bakugan Battle Brawlers $4 loose
Crash Mind Over Mutant $10 loose
Igor $3 loose
Pokemon Moon $13 loose
Pokemon Sun $13 loose
Sonic Colors $8 loose
submitted by vlexy to GameSale [link] [comments]

[USA] [H] LOTS OF GAMES FOR SALE!!! GB/GBC/GBA, Genesis, NES, SNES, N64, PS1, PS2, PS3, Xbox, DS, Gamecube, Atari 400/2600! [W] PayPal Inovice/Zelle/Crypto

Hey Guys welcome to my sales/trade thread! Everything has been priced according to PriceCharting/ebay I am willing to negotiate when you buy a couple.
Feedback Thread
My forms of payment are PayPal Invoice or Zelle/Crypto if you feel comfortable. I Pay for shipping on all items. I'm here to do clean/honest business. Also before doing a trade/sale I will make sure who I'm dealing with and make sure a clean transaction will be made.
I will not take transactions less then $20
I will try to get back to everyone in a timely manner so please bare with me!
As per rules, I require everyone to post wants on the thread and discuss in thread. We will transfer over to PM when a deal has been made and ready for payment. If anyone has any questions please feel free to message me.
Disclaimer I do not have a NES/Genesis I have been trying to buy one to test all games, but haven't found any reasonably price so I will be selling those games as is, I can on the other hand insure every other games from the other systems working. I can also open up cartridges, but please be courteous don't ask me to open up low priced items. I will be glad to take as many pictures as you need to ensure happiness.
If allowed I will post a link to my google doc with everything laid out in a much more neat manner as I just copied and pasted from the spreadsheet because it would take me to long otherwise to create a template. I know it looks terrible so please bare with me and ask any questions! Thank you.
Vlexy's Collection

These have been priced a while ago, I have not checked price fluctuation so just ask and I'll let you know!
Consoles/bundles/Misc
Atari 400 w/16 games want $150 Shipped
PS1 Bundle $50 (I can also bundle it with different games if you want depending the games it'll be lower or higher price)
MegaMan X2 Box with printed rental store manual. Its banged up so don't really know what to price it.
::NES::

Air fortress Loose $5
AirWolf Loose $5
Friday the 13th Loose $9
Hogans Alley Loose $6
Iron Sword Wizards and Warriors II Loose $4
Jaws Loose $8
life force Loose $10
Magmax Loose $5
Metroid Loose $11
Milons Secret Castle Loose $7
P.O.W Loose $6
R.C Pro-AM Loose $6
Rampage Loose $11
Rush'n Attack Loose $6
Silius Loose $30
Section Z Loose $16
Sky Shark Loose $5
Spy Hunter Loose $4
Star Soldier Loose $8
Star Tropics Loose $10
The adventures of Link Loose $14
The Guardian Legend Loose $13
Top Gun Loose $5
Ultima Loose $8
Wizards and Warriors Loose $6
Xevious Loose $6
Zanac Loose $13

::SNES::

Arkanoid doh it again Loose $11
Batman Forever Loose $7
Batman Returns Loose $14
Biometal Loose $32
Chess Master Loose $4
Darius Twin Loose $12
Drakkhen Loose $7
Gunforce Loose $18
Jurassic Park Loose $8
Mario Paint Loose $9
Final Fantasy Mystic Quest Loose $14
knights of the Round Loose $60
P.T.O Loose $13
Phalanx CIB $55
Robotrek Loose $50
Secret of mana Loose $40
Star Fox Loose $13
Super Battleship Loose $2
Super Empire Strikes Back Loose $10
Super Ghouls 'N Ghost Loose $21
Super Mario All stars Loose $13
Super Mario World Loose $12
Super Star Wars Loose $8
The 7th Saga Loose $15
UN Squadron Loose $20
Wing Commander Loose $6

::N64::
Jet Force Gemini Loose $12
Star Soldier Vanishing Earth Loose $28
Star Wars rogue Squadron Loose $9
Star Wars Shadows of the Empire Loose $7
Wave Race Loose $6
XG2 Loose $6
Goin Quackers loose $20
Mario Party 2 loose $35

::Genesis::

Air Diver Loose $4
Cyborg Justice Loose $7
Ecco the dolphin Loose $8
F-15 Strike Eagle 2 Loose $4
Jurrasic Park Loose $6
Lightning Force Quest for the darkstar Loose $38
Robo-kid Loose $12
Sonic 2 Loose $5
Sonic Spinball Loose $5
Sonic The Hedge Hog Loose $6
Super Battleship Loose $2
Thunder Force 3 Loose $37
TMNT - Hyperstone Heist Loose $45

::GBA::

Ace Combat Advance Loose $4
Batman Begins Loose $5
Bruce Lee Return of the legend Loose $4
F-14 Tomcat Loose $3
F-A 18F Loose $3
Iridion 2 Loose $21
Iridion 3D Loose $5
Kirby Nightmare in dreamland Loose $16
Mega man Zero 2 Loose $17
Monster Trucks Loose $4
Need for Speed Carbon Own the city Loose $5
Phantasy Star Collection Loose $13
Saber wulf Loose $13
Sim city 2000 Loose $9
Spy Hunter Loose $4
Star Wars Flight of the falcon Loose $4
Star Wars trilogy Apprentice of the force Loose $7
Super Hornet Loose $3
ThunderBirds Loose $3
Top Gun Firestorm advance Loose $3

::GB::

AladdinLoose$6
Donkey Kong Country Loose $9
Donkey Kong Land Loose $7
Game & Watch Gallery 3 Loose $6
Gex Loose $3
Hot wheels stunt track driver Loose $3
Pokemon Blue Loose $20
Pokemon Crystal Loose $35 (No front label sticker)
Pokemon Gold Loose $22
Pokemon Green (Repro) Loose $10
Pokemon Red Loose $20
Star Wars Yoda Stories Loose $8
::PS1::
007 the world is not enough CIB $7
Autin Powers Pinball CIB $4
Descent CIB $8
Descent Maximum CIB $10
jet Moto 2 CIB $7
Killer loop CIB $5
40Nitrous Oxide CIB $8
Novastorm CIB $20
Nuclear Strike CIB $6
Resident Evil 2 CIB $25
Shockwave Assault CIB $1
Star Wars rebels assault 2 CIB $6
Tunnel B1CIB $6
twisted metal 2 CIB $17
Warhawk CIB $15
Wing Commander III Heart of the Tiger CIB $20
Wing Commander the price of freedom CIB $14

::PS2:: (Very Negotiable if buying a few)

007 Agent Under Fire CIB $6
007 Everything or nothing CIB $8
007 Nightfire CIB $7
Alter Echo CIB $5
Antigrav CIB $4
Bad boys Miami Takedown CIB $4
Baldurs Gate Dark Alliance $12 W/Case/Missing manual
Battlestar Galactica CIB $8
Bully CIB $13
Champions Norath Loose $15
Chaos Legion CIB $10
Demon Stone CIB $7
DT Racer CIB $3
Everblue 2 CIB $12
Final Fantasy x CIB $5
Ford VS Chevy CIB $3
God of War CIB $6
Gran Tursimo 3 CIB $4
GTA San Andreas CIB $8
GTA Vice city CIB $4
Hypersonic Extreme CIB $5
IHRA Drag Racing 2 CIB $3
Jaw Unleashed CIB $8
Kengo Master Bushido CIB $6
Mace griffin Bounty Hunter CIB $4
Medal of Honor Eurpoean Assualt CIB $4
Midnight club 3 remix CIB $12
Mortal kombat Deadly Alliance Loose $5
NBA Street Loose $5
NBA Street Vol. 2 CIB $15
NHL 06 CIB $3
Pro Race Driver CIB $3
R:Racing Evolution CIB $6
Read Dead Revolver CIB$9
Resident Evil Code:Veronica x CIB $8
Rogue galaxy CIB $13
RUNE: Viking Warlord $6 W case/Missing manual
S driving emotion Type-S CIB $5
Silent hill 3 Loose$30
Silent hill originsLoose/W Manual $25
Splash Down Rides Gone Wild CIB $7
Splinter Cell Pandora tomorrow Loose $3
SRS Street Racing syndicate CIB $10
Star Trek Encounters CIB $6
Star Wars Jedi Fighters Loose $4
Stolen CIB $9
Sub Rebellion CIB $10
Super Trucks Racing CIB $3
Suzuki TTSuperBikes CIB $3
The IncrediblesLoose/W Manual $4
TMNT CIB $10
Top Gun CIB $3
Transformers the game CIB $4
Ultimate Board Game collection CIB $3

::XBOX:: (Very Negotiable if buying a few)

Bloodrayne 2 CIB $12
Dead or Alive 3 CIB $6
Halo 2 CIB $5
Halo 2 Collectors edition CIB $12
Taito Legends CIB $9
Phantom Crash CIB $13
Dark Summit CIB $5
Doom 3 CIB $7
Tony Hawk pro Skater 2x CIB $13

::Gamecube::

NCAA football 03 CIB $3
Donkey Kong Jungle Beat CIB $12
Donkey Konga 2 CIB $9

::PS3:: (Negotiable if buying a few) (All games CIB unless stated otherwise)

Bayonetta $9
Def Jam icon $12
Folklore $16
Fracture $5
Gran Turismo 5 XL Edition Sealed $18
Minecraft $13
Silent Hill Homecoming $11
The beatles rockband Sealed $10

::DS::
Bakugan Battle Brawlers $4 loose
Crash Mind Over Mutant $10 loose
Igor $3 loose
Pokemon Moon $13 loose
Pokemon Sun $13 loose
Sonic Colors $8 loose
submitted by vlexy to GameSale [link] [comments]

[USA] [H] 100+ Games for sale! GB/GBC, GBA, Genesis, NES, SNES, N64, PS2, PS3, Xbox, DS, Gamecube & MORE!! [W] PayPal Inovice/Zelle/Crypto

Hey Guys welcome to my sales/trade thread! Everything has been priced according to PriceCharting/ebay I am willing to negotiate when you buy a couple.
Feedback Thread
My forms of payment are PayPal Invoice or Zelle/Crypto if you feel comfortable. I Pay for shipping on all items. I'm here to do clean/honest business. Also before doing a trade/sale I will make sure who I'm dealing with and make sure a clean transaction will be made.
I will not take transactions less then $20
I will try to get back to everyone in a timely manner so please bare with me!
As per rules, I require everyone to post wants on the thread and discuss in thread. We will transfer over to PM when a deal has been made and ready for payment. If anyone has any questions please feel free to message me.
Disclaimer I do not have a NES/Genesis I have been trying to buy one to test all games, but haven't found any reasonably price so I will be selling those games as is, I can on the other hand insure every other games from the other systems working. I can also open up cartridges, but please be courteous don't ask me to open up low priced items. I will be glad to take as many pictures as you need to ensure happiness.
If allowed I will post a link to my google doc with everything laid out in a much more neat manner as I just copied and pasted from the spreadsheet because it would take me to long otherwise to create a template. I know it looks terrible so please bare with me and ask any questions! Thank you.
Vlexy's Collection

These have been priced a while ago, I have not checked price fluctuation so just ask and I'll let you know!
Atari 400 w/16 games want $150 Shipped
::NES::

Air fortress Loose $5
AirWolf Loose $5
Faxanadu Loose $8
Festers Quest Loose $6
Final fantasy Loose $15
Flight of the Intruder Loose $8
Frankenstein the monster returns Loose $65
Friday the 13th Loose $9
Gaunlet Loose $7
Hogans Alley Loose $6
Ikari Warriors Loose $8
Iron Sword Wizards and Warriors II Loose $4
Jaws Loose $8
Legend of Zelda Loose $13
life forceLoose $10
MagmaxLoose $5
MetroidLoose $11
Milons Secret CastleLoose $7
P.O.W Loose $6
R.C Pro-AM Loose $6
Rambo Loose $7
Rampage Loose $11
Renegade Loose $5
Rush'n Attack Loose $6
Silius Loose $30
Section Z Loose $16
Sky Shark Loose $5
Spy Hunter Loose $4
Star Soldier Loose $8
Star Tropics Loose $10
The adventures of Link Loose $14
The Guardian Legend Loose $13
Top Gun Loose $5
Ultima Loose $8
Wizards and Warriors Loose $6
Xevious Loose $6
Zanac Loose $13

::SNES::

Arkanoid doh it again Loose $11
Batman Forever Loose $7
Batman Returns Loose $14
Biometal Loose $32
Chess Master Loose $4
Darius Twin Loose $12
Drakkhen Loose $7
Gunforce Loose $18
Indiana Jones Greatest Adventures Loose $15
Jurassic Park Loose $8
Mario Paint Loose $9
Final Fantasy Mystic Quest Loose $14
knights of the Round Loose $60
P.T.O Loose $13
Phalanx CIB $55
Robotrek Loose $50
Secret of mana Loose $40
Star Fox Loose $13
Super Battleship Loose $2
Super Empire Strikes Back Loose $10
Super Ghouls 'N Ghost Loose $21
Super Mario All stars Loose $13
Super Mario World Loose $12
Super Star Wars Loose $8
The 7th Saga Loose $15
UN Squadron Loose $20
Wing Commander Loose $6

::N64::
Jet Force Gemini Loose $12
Star Soldier Vanishing Earth Loose $28
Star Wars rogue Squadron Loose $9
Star Wars Shadows of the Empire Loose $7
Wave Race Loose $6
XG2 Loose $6
Zelda Ocarina of time loose $32
Goin Quackers loose $20
Mario Party 2 loose $35

::Genesis::

Air Diver Loose $4
Cyborg Justice Loose $7
Ecco the dolphin Loose $8
F-15 Strike Eagle 2 Loose $4
Jurrasic Park Loose $6
Lightning Force Quest for the darkstar Loose $38
Robo-kid Loose $12
Sonic 2 Loose $5
Sonic Spinball Loose $5
Sonic The Hedge Hog Loose $6
Super Battleship Loose $2
Thunder Force 3 Loose $37
TMNT - Hyperstone Heist Loose $45

::GBA::

Ace Combat Advance Loose $4
Batman Begins Loose $5
Bruce Lee Return of the legend Loose $4
Castlevania Aria of sorrow Loose $43 On Hold
Castlevania harmony of dissonance Loose $42 On Hold
F-14 Tomcat Loose $3
F-A 18F Loose $3
Iridion 2 Loose $21
Iridion 3D Loose $5
Kirby Nightmare in dreamland Loose $16
Legend of Zelda the minish cap Loose $33 On Hold
Mega man Zero 2 Loose $17
Metroid Loose $12 On Hold
Metroid Fusion Loose $21 On Hold
Monster Trucks Loose $4
Need for Speed Carbon Own the city Loose $5
Phantasy Star Collection Loose $13
Pokemon Fire Red Loose $40 SOLD
Saber wulf Loose $13
Sim city 2000 Loose $9
Spy Hunter Loose $4
Star Wars Flight of the falcon Loose $4
Star Wars trilogy Apprentice of the force Loose $7
Super Hornet Loose $3
The Pinball of the dead Loose $16
ThunderBirds Loose $3
Top Gun Firestorm advance Loose $3

::GB::

AladdinLoose$6
Donkey Kong Country Loose $9
Donkey Kong Land Loose $7
Game & Watch Gallery 3 Loose $6
Gex Loose $3
Hot wheels stunt track driver Loose $3
Pokemon Blue Loose $20
Pokemon Crystal Loose $35 (No front label sticker)
Pokemon Gold Loose $22
Pokemon Green (Repro) Loose $10
Pokemon Red Loose $20
Star Wars Yoda Stories Loose $8

::PS2:: (Very Negotiable if buying a few)

007 Agent Under Fire CIB $6
007 Everything or nothing CIB $8
007 Nightfire CIB $7
Alter Echo CIB $5
Antigrav CIB $4
Bad boys Miami Takedown CIB $4
Baldurs Gate Dark Alliance $12 W/Case/Missing manual
Battlestar Galactica CIB $8
Bully CIB $13
Champions Norath Loose $15
Chaos Legion CIB $10
Demon Stone CIB $7
DT Racer CIB $3
Everblue 2 CIB $12
Final Fantasy x CIB $5
Ford VS Chevy CIB $3
God of War CIB $6
Gran Tursimo 3 CIB $4
GTA San Andreas CIB $8
GTA Vice city CIB $4
Hypersonic Extreme CIB $5
IHRA Drag Racing 2 CIB $3
Jaw Unleashed CIB $8
Kengo Master Bushido CIB $6
Mace griffin Bounty Hunter CIB $4
Medal of Honor Eurpoean Assualt CIB $4
Midnight club 3 remix CIB $12
Mortal kombat Deadly Alliance Loose $5
NBA Street Loose $5
NBA Street Vol. 2 CIB $15
NHL 06 CIB $3
Pro Race Driver CIB $3
R:Racing Evolution CIB $6
Read Dead Revolver CIB$9
Resident Evil Code:Veronica x CIB $8
Rogue galaxy CIB $13
RUNE: Viking Warlord $6 W case/Missing manual
S driving emotion Type-S CIB $5
Silent hill 3 Loose$30
Silent hill originsLoose/W Manual $25
Splash Down Rides Gone Wild CIB $7
Splinter Cell Pandora tomorrow Loose $3
SRS Street Racing syndicate CIB $10
Star Trek Encounters CIB $6
Star Wars Jedi Fighters Loose $4
Stolen CIB $9
Sub Rebellion CIB $10
Super Trucks Racing CIB $3
Suzuki TTSuperBikes CIB $3
The IncrediblesLoose/W Manual $4
TMNT CIB $10
Top Gun CIB $3
Transformers the game CIB $4
Ultimate Board Game collection CIB $3

::XBOX:: (Very Negotiable if buying a few)

Bloodrayne 2 CIB $12
Dead or Alive 3 CIB $6
Halo 2 CIB $5
Halo 2 Collectors edition CIB $12
Taito Legends CIB $9
Phantom Crash CIB $13
Dark Summit CIB $5
Doom 3 CIB $7
Tony Hawk pro Skater 2x CIB $13

::Gamecube::

NCAA football 03 CIB $3
Donkey Kong Jungle Beat CIB $12
Donkey Konga 2 CIB $9

::PS3:: (Negotiable if buying a few) (All games CIB unless stated otherwise)

Bayonetta $9
Def Jam icon $12
Folklore $16
Fracture $5
Gran Turismo 5 XL Edition Sealed $18
Minecraft $13
Silent Hill Homecoming $11
The beatles rockband Sealed $10

::DS::
Bakugan Battle Brawlers $4 loose
Crash Mind Over Mutant $10 loose
Igor $3 loose
Pokemon Moon $13 loose
Pokemon Sun $13 loose
Sonic Colors $8 loose
submitted by vlexy to GameSale [link] [comments]

Why we won't have a long term bear market, and how to systematically pick your future investments in crypto

With so much uncertainty right now it would be a good time to take some time to go over what happened recently and how to invest moving foward. We've seen a peak bubble at around 850 billion total market cap in the first week of January, consolidated down to $750 billion and have now just experienced a 40% correction.

What's happening now and how bad will it get?

First of all you should realize that there is a January Dip that happens every year, when we see a roughly 20-30% decline around mid January. This year its been much more severe though for several additional factors that have compounded on top.
Different theories exist on why this happens (its actually the mirror opposite of the "January Effect" that happens in the US stock market), but the two major theories are:
1) Asian markets pull into fiat because of Asian New Year spending needs
2) People in the US sell in January to defer their capital gains tax liability an extra year
While this cyclic event has lead to a healthy correction in the last few years, this year we got these new factors making more fear as well:
So in essence we got a storm of scary news along with the usual cyclic downturn. Currently I don't see this as being a systematic crash like Mt.Gox was that would lead to a long term bear market because the fundamental ecosystem is still intact, and I suspect that after about a month we should consolidate around a new low. All the exchanges are still operational and liquid, and there is no breakdown in trust nor uncertainty whether you'll be able to cash out. What range the market trades in will all depend how Bitcoin does, right now we've already broken below 10K but I'm seeing a lot of support at around $8000, which is roughly where the long term MA curve settles. We don't know how bad it will get or what the future will bring, but as of right now we shouldn't be in a bear market yet.
What should you do if you recently entered the market?
If you did buy in the last few months at or near ATH, the very worst thing you can do now is sell in panic and lose your principal. You shouldn't have more money in crypto than you can afford to lose, so it shouldn't be a problem to wait. You have to realize that 30% corrections in crypto are relatively common, just last fall we had a 40% flash correction over more China fears. Unless there is a systematic breakdown like we had during Mt.Gox, the market always recovers.
The other worst thing you can do is unload into Tether as your safety net. If there is one thing that could actually cause a long term destruction of trust within the cryptocurrency investment ecosystem, its Tether having a run up on their liabilities and not having enough reserve to cover the leverage. It would not only bring down exchanges but lead to years of litigation and endless media headlines that will scare off everybody from putting fiat in. I don't know when the next Mt.Gox meltdown will occur but I can almost guarantee it will involve Tether. So stay away from it.
What should long term investors do?
For long term holders a good strategy to follow each year is to capture profit each December and swallow the capital gains taxation liability, park a reserve of fiat at Gemini (whose US dollar deposits are FDIC-insured) and simply wait till around late January to early February to re-enter the market at a discount and hold all year until next December. You can keep a small amount in core coins in order to trade around various Q1 opportunities you anticipate. Others may choose to simply do nothing and just keep holding throughout January which is also a perfectly fine strategy. The cyclical correction usually stabilizes toward late January and early February, then we see a rise in March and generally are recovered by end of April. Obviously this decision whether to sell in December to profit on the dip and pay tax liability or to just hold will depend on your individual tax situation. Do your own math sometime in November and follow suit.
Essentially revaluate your positions and trim your position sizes if you don't feel comfortable with the losses.

How to construct your portfolio going forward

Rather than seeing the correction as a disaster see it as a time to start fresh. If you have been FOMO-ing into bad cryptos and losing money now is a time to start a systematic long term approach to investing rather than gambling.
Follow a methodology for evaluating each cryptocurrency
Memes and lambo dreams are fun and all, but I know many of you are investing thousands of dollars into crypto, so its worth it to put some organized thought into it as well. I can't stress enough how important it is to try and logically contruct your investment decisions. If you follow a set methodology, a checklist and template you will be able to do relative comparisons between cryptocurrencies, to force yourself to consider the negatives and alternative scenarios and also sleep comfortably knowing you have a sound basis for your investment decisions (even if they turn out to be wrong).
There is no ideal or "correct" methodology but I can outline mine:
1) Initial information gathering and filtering
Once I identify something that looks like a good potential investment, I first go to the CoinMarketCap page for that symbol and look at the website and blockchain explorer.
  • Critically evaluate the website. This is the first pass of the bullshit detector and you can tell from a lot from just the website whether its a scam. If it uses terms like "Web 4.0" or other nonsensical buzzwords, if its unprofessional and has anonymous teams, stay away. Always look for a roadmap, compare to what was actually delivered so far. Always check the team, try to find them on LinkedIn and what they did in the past.
  • Read the whitepaper or business development plan. You should fully understand how this crypto functions and how its trying to create value. If there is no use case or if the use case does not require or benefit from a blockchain, move on. Look for red flags like massive portions of the float being assigned to the founders of the coin, vague definition of who would use the coin, anonymous teams, promises of large payouts...etc
  • Check the blockchain explorer. How is the token distribution across accounts? Are the big accounts holding or selling? Which account is likely the foundation account, which is the founders account?
  • Read the subreddit and blogs for the cryptocurrency and also evaluate the community. Try to figure out exactly what the potential use cases are and look for sceptical takes. Look at the Github repos, does it look empty or is there plenty of activity?
2) Fill out an Investment Checklist
I have a checklist of questions that I find important and as I'm researching a crypto I save little snippets in Evernote of things that are relevant to answering those questions:
  • What is the problem or transactional inefficiency the coin is trying to solve?
  • What is the Dev Team like? What is their track record? How are they funded, organized?
  • Who is their competition and how big is the market they're targeting? What is the roadmap they created?
  • What current product exists?
  • How does the token/coin actually derive value for the holder? Is there a staking mechanism or is it transactional?
  • What are the weaknesses or problems with this crypto?
3) Create some sort of consistent valuation model/framework, even if its simple
I have a background in finance so I like to do Excel modeling. For those who are interested in that, this article is a great start and also Chris Burniske has a great blog about using Quantity Theory of Money to build an equivalent of a DCF analysis for crypto.
Here is an Excel file example of OMG done using his model. You can download this and play around with it yourself, see how the formulas link and understand the logic.
Once you have a model set up the way you like in Excel you can simply alter it to account for various float oustanding schedule and market items that are unique to your crypto, and then just start plugging in different assumptions. Think about what is the true derivation of value for the coin, is it a "dividend" coin that you stake within a digital economy and collect fees or is it a currency? Use a realistic monetary velocity (around 5-10 for currency and around 1-2 for staking) and for the discount rate use at least 3x the long term return of a diversified equity fund.
The benefit is that this forces you to think about what actually makes this coin valuable to an actual user within the digital economy its participating in and force you to think about the assumptions you are making about the future. Do your assumptions make sense? What would the assumptions have to be to justify its current price? You can create different scenarios in a matrix (optimistic vs. pessimistic) based on different assumptions for risk (discount rate) and implementation (adoption rates).
If you don't understand the above thats perfectly fine, you don't need to get into full modeling or have a financial background. Even a simple model that just tries to derive a valuation through relative terms will put you above most crypto investors. Some simple valuation methods that anyone can do
  • Metcalfe's Law which states that the value of a network is proportional to the square of the number of connected users of the system (n2). So you can compare various currencies based on their market cap and square of active users or traffic.
  • Another easy one is simply looking at the total market for the industry that the coin is supposedly targeting and comparing it to the market cap of the coin. Think of the market cap not only with circulating supply like its shown on CMC but including total supply. For example the total supply for Dentacoin is 1,841,395,638,392, and when multiplied by its price in early January we get a market cap that is actually higher than the entire industry it aims to disrupt: Dentistry.
  • If its meant to be just used as just a currency: Take a look at the circulating supply and look at the amount that is in cold storage or set to be released/burned. Most cryptos are deflationary so think about how the float schedule will change over time and how this will affect price.
Once you have a model you like set up, you can compare cryptos against each other and most importantly it will require that you build a mental framework within your own mind on why somebody would want to own this coin other than to sell it to another greater fool for a higher price. Modeling out a valuation will lead you to think long term and think about the inherent value, rather than price action.
Once you go through this 3-step methodology, you'll have a pretty good confidence level for making your decision and can comfortably sit back and not panic if some temporary short term condition leads to a price decrease. This is how "smart money" does it.
Think about your portfolio allocation
You should think first in broad terms how you allocate between "safe" and "speculative" cryptos.
For new investors its best to keep a substantial portion in what would be considered largecap safe cryptos, primarily BTC, ETH, LTC. I personally consider XMR to be safe as well. A good starting point is to have between 50-70% of your portfolio in these safe cryptocurrencies. As you become more confident and informed you can move your allocation into speculative small caps.
You should also think in terms of segments and how much of your total portfolio is in each segment:
  • Core holdings - BTC, Ethereum, LTC...etc
  • Platform segment - Ethereum, NEO, Ark...etc
  • Privacy segment - Monero, Zcash, PivX..etc
  • Finance/Bank settlement segment - Ripple, Stellar...etc
  • Enterprise Blockchain solutions segment -VeChain, Walton, WABI...etc
  • Promising/Innovative Tech segment - Raiblocks, IOTA, Cardano...etc
You should also think about where we are in the cycle, as now given so much uncertaintly its probably best to stay heavily in core holdings and pick up a few coins within a segment you understand well. If you don't understand how enterprise solutions work or how the value chain is built through corporations, don't invest in the enteprise blockchain solutions segment. If you are a technie who loves the technology behind Cardano or IOTA, invest in that segment.
Think of your "circle of competence"
This is actually a term Buffet came up with, it refers to your body of knowledge that allows you to evaluate an investment. Think about what you know best and consider investing in those type of coins. If you don't know anything about how supply chains functions, how can you competently judge whether VeChain or WaltonChain will achieve adoption?
This where your portfolio allocation also comes into play. You should diversify but really shouldn't be in much more than around 12 cryptos, because you simply don't have enough competency to accurately access the risk across every segment and for every type of crypto you come across. If you had over 20 different cryptos in your portfolio you should probably think about consolidating to a few sectors you understand well.
Continually educate yourself about the technology and markets
If you aren't already doing it: Read a bit each day about cryptocurrencies. There are decent Youtubers that talk about the market side of crypto, just avoid those that hype specific coins and look for more sceptical ones like CryptoInvestor. If you don't understand how the technology works and what the benefits of a blockchain are or how POS/POW works or what a DAG is or how mining actually works, learn first. If you don't care about the technology or find reading about it tedious, you shouldn't invest in this space at all.

Summing it up

I predicted a few days ago that we would have a major correction in 2018 specifically in the altcoins that saw massive gains in Decemebeearly January, and it seems we've already had a pretty big one. I don't think we'll have a complete meltdown like some are predicting, but some more pain may be incoming.
Basically take this time to think about how you can improve your investment style and strategy. Make a commitment to value things rather than chasing FOMO, and take your time to make a decision. Long term investment will grant you much more returns as will a systematic approach.
Take care and have fun investing :)
Edit March 2018: Lol looking back I'm regretting starting the title with "Why we won't have a long term bear market" now, I was more karma whoring with that catchy title than anything. We recovered up to 11K from this post, but then crashed again hard later in February-March because of a slew of reasons from Tether subpeona to unforseen regulatory issues.
submitted by arsonbunny to CryptoCurrency [link] [comments]

[USA] [H] 100+ Games for sale! GB/GBC, GBA, Genesis, NES, SNES, N64, PS2, PS3, Xbox, DS, Gamecube & MORE!! [W] PayPal Inovice/Zelle/Crypto

Hey Guys welcome to my sales/trade thread! Everything has been priced according to PriceCharting/ebay I am willing to negotiate when you buy a couple.
Feedback Thread
My forms of payment are PayPal Invoice or Zelle/Crypto if you feel comfortable. I Pay for shipping on all items. I'm here to do clean/honest business. Also before doing a trade/sale I will make sure who I'm dealing with and make sure a clean transaction will be made.
I will not take transactions less then $20
I will try to get back to everyone in a timely manner so please bare with me!
As per rules, I require everyone to post wants on the thread and discuss in thread. We will transfer over to PM when a deal has been made and ready for payment. If anyone has any questions please feel free to message me.
Disclaimer I do not have a NES/Genesis I have been trying to buy one to test all games, but haven't found any reasonably price so I will be selling those games as is, I can on the other hand insure every other games from the other systems working. I can also open up cartridges, but please be courteous don't ask me to open up low priced items. I will be glad to take as many pictures as you need to ensure happiness.
If allowed I will post a link to my google doc with everything laid out in a much more neat manner as I just copied and pasted from the spreadsheet because it would take me to long otherwise to create a template. I know it looks terrible so please bare with me and ask any questions! Thank you.
Vlexy's Collection

::NES::

Air fortress Loose $5
AirWolf Loose $5
Faxanadu Loose $8
Festers Quest Loose $6
Final fantasy Loose $15
Flight of the Intruder Loose $8
Frankenstein the monster returns Loose $65
Friday the 13th Loose $9
Gaunlet Loose $7
Hogans Alley Loose $6
Ikari Warriors Loose $8
Iron Sword Wizards and Warriors II Loose $4
Jaws Loose $8
Legend of Zelda Loose $13
life forceLoose $10
MagmaxLoose $5
MetroidLoose $11
Milons Secret CastleLoose $7
P.O.W Loose $6
R.C Pro-AM Loose $6
Rambo Loose $7
Rampage Loose $11
Renegade Loose $5
Rush'n Attack Loose $6
Silius Loose $30
Section Z Loose $16
Sky Shark Loose $5
Spy Hunter Loose $4
Star Soldier Loose $8
Star Tropics Loose $10
The adventures of Link Loose $14
The Guardian Legend Loose $13
Top Gun Loose $5
Ultima Loose $8
Wizards and Warriors Loose $6
Xevious Loose $6
Zanac Loose $13

::SNES::

Arkanoid doh it again Loose $11
Batman Forever Loose $7
Batman Returns Loose $14
Biometal Loose $32
Chess Master Loose $4
Darius Twin Loose $12
Drakkhen Loose $7
Gunforce Loose $18
Indiana Jones Greatest Adventures Loose $15
Jurassic Park Loose $8
Mario Paint Loose $9
Final Fantasy Mystic Quest Loose $14
knights of the Round Loose $60
P.T.O Loose $13
Phalanx CIB $55
Robotrek Loose $50
Secret of mana Loose $40
Star Fox Loose $13
Super Battleship Loose $2
Super Empire Strikes Back Loose $10
Super Ghouls 'N Ghost Loose $21
Super Mario All stars Loose $13
Super Mario World Loose $12
Super Star Wars Loose $8
The 7th Saga Loose $15
UN Squadron Loose $20
Wing Commander Loose $6

::N64::
Jet Force Gemini Loose $12
Rampage 2 Universal Tour Loose $18
Star Soldier Vanishing Earth Loose $28
Star Wars rogue Squadron Loose $9
Star Wars Shadows of the Empire Loose $7
Wave Race Loose $6
XG2 Loose $6

::Genesis::

Air Diver Loose $4
Cyborg Justice Loose $7
Ecco the dolphin Loose $8
F-15 Strike Eagle 2 Loose $4
Jurrasic Park Loose $6
Lightning Force Quest for the darkstar Loose $38
Phantasy star 3 Loose $16 Sold
Robo-kid Loose $12
Sonic 2 Loose $5
Sonic Spinball Loose $5
Sonic The Hedge Hog Loose $6
Super Battleship Loose $2
Thunder Force 3 Loose $37
TMNT - Hyperstone Heist Loose $45
Vectorman Loose $6 Sold

::GBA::

Ace Combat Advance Loose $4
Batman Begins Loose $5
Bruce Lee Return of the legend Loose $4
Castlevania Aria of sorrow Loose $43 On Hold
Castlevania harmony of dissonance Loose $42 On Hold
F-14 Tomcat Loose $3
F-A 18F Loose $3
Iridion 2 Loose $21
Iridion 3D Loose $5
Kirby Nightmare in dreamland Loose $16
Legend of Zelda the minish cap Loose $33 On Hold
Mega man Zero 2 Loose $17
Metroid Loose $12 On Hold
Metroid Fusion Loose $21 On Hold
Monster Trucks Loose $4
Need for Speed Carbon Own the city Loose $5
Phantasy Star Collection Loose $13
Pokemon Fire Red Loose $40 SOLD
Saber wulf Loose $13
Sim city 2000 Loose $9
Spy Hunter Loose $4
Star Wars Flight of the falcon Loose $4
Star Wars trilogy Apprentice of the force Loose $7
Super Hornet Loose $3
The Pinball of the dead Loose $16
ThunderBirds Loose $3
Top Gun Firestorm advance Loose $3

::GB::

AladdinLoose$6
Donkey Kong Country Loose $9
Donkey Kong Land Loose $7
Game & Watch Gallery 3 Loose $6
Gex Loose $3
Hot wheels stunt track driver Loose $3
Pokemon Blue Loose $20
Pokemon Crystal Loose $35 (No front label sticker)
Pokemon Gold Loose $22
Pokemon Green (Repro) Loose $10
Pokemon Red Loose $20
Star Wars Yoda Stories Loose $8

::PS2:: (Very Negotiable if buying a few)

007 Agent Under Fire CIB $6
007 Everything or nothing CIB $8
007 Nightfire CIB $7
Alter Echo CIB $5
Antigrav CIB $4
Bad boys Miami Takedown CIB $4
Baldurs Gate Dark Alliance $12 W/Case/Missing manual
Battlestar Galactica CIB $8
Bully CIB $13
Champions Norath Loose $15
Chaos Legion CIB $10
Demon Stone CIB $7
DT Racer CIB $3
Everblue 2 CIB $12
Final Fantasy x CIB $5
Ford VS Chevy CIB $3
God of War CIB $6
Gran Tursimo 3 CIB $4
GTA San Andreas CIB $8
GTA Vice city CIB $4
Hypersonic Extreme CIB $5
IHRA Drag Racing 2 CIB $3
Jaw Unleashed CIB $8
Kengo Master Bushido CIB $6
Mace griffin Bounty Hunter CIB $4
Maximo Ghost to Glory Sealed $35
Medal of Honor Eurpoean Assualt CIB $4
Midnight club 3 remix CIB $12
Mortal kombat Deadly Alliance Loose $5
NBA Street Loose $5
NBA Street Vol. 2 CIB $15
NHL 06 CIB $3
Pro Race Driver CIB $3
R:Racing Evolution CIB $6
Read Dead Revolver CIB$9
Resident Evil Code:Veronica x CIB $8
Rogue galaxy CIB $13
RUNE: Viking Warlord $6 W case/Missing manual
S driving emotion Type-S CIB $5
Silent hill 3 Loose$30
Silent hill originsLoose/W Manual $25
Splash Down Rides Gone Wild CIB $7
Splinter Cell Pandora tomorrow Loose $3
SRS Street Racing syndicate CIB $10
Star Trek Encounters CIB $6
Star Wars Jedi Fighters Loose $4
Stolen CIB $9
Sub Rebellion CIB $10
Super Trucks Racing CIB $3
Suzuki TTSuperBikes CIB $3
The IncrediblesLoose/W Manual $4
TMNT CIB $10
Top Gun CIB $3
Transformers the game CIB $4
Ultimate Board Game collection CIB $3

::XBOX:: (Very Negotiable if buying a few)

Bloodrayne 2 CIB $12
Dead or Alive 3 CIB $6
Halo 2 CIB $5
Halo 2 Collectors edition CIB $12
Taito Legends CIB $9
Phantom Crash CIB $13
Dark Summit CIB $5
Doom 3 CIB $7
Tony Hawk pro Skater 2x CIB $13

::Gamecube::

NCAA football 03 CIB $3
Donkey Kong Jungle Beat CIB $12
Donkey Konga 2 CIB $9

::PS3:: (Negotiable if buying a few) (All games CIB unless stated otherwise)

Bayonetta $9
Def Jam icon $12
Folklore $16
Fracture $5
Gran Turismo 5 XL Edition Sealed $18
Grand theft auto V Normal $8
GTA Episodes from liberty city $6
Kingdom Hearts HD 2.5 Remix $8
Medal of honor war fighter $5
Minecraft $13
Ratchet & clank Future tools of destruction $6
Silent Hill Homecoming $11
The beatles rockband Sealed $10
Uncharted 2 Game of the year edition $4
Uncharted 3Sealed $10
Uncharted Drakes fortune Sealed $6

::DS::
Bakugan Battle Brawlers $4 loose
Crash Mind Over Mutant $10 loose
Igor $3 loose
Pokemon Heart gold $50 loose
Pokemon Moon $13 loose
Pokemon Sun $13 loose
Sonic Colors $8 loose
submitted by vlexy to GameSale [link] [comments]

[USA] [H] MEGA TRADE/SELL THREAD 100s of GAMES!! GB/GBC, GBA, Genesis, NES, SNES, N64, PS2, PS3, Xbox, Gamecube & MORE!! [W] PayPal Inovice/Zelle/Crypto

Hey Guys welcome to my sales/trade thread! Everything has been priced according to PriceCharting I am willing to negotiate on certain things.
Feedback Thread
My forms of payment are PayPal Invoice or Zelle/Crypto if you feel comfortable. I Pay for shipping on all items. I'm here to do clean/honest business and above all have fun. Also before doing a trade/sale I will make sure who I'm dealing with and make sure a clean transaction will be made.
I will try to get back to everyone in a timely manner so please bare with me!
As per rules, I require everyone to post wants on the thread and discuss in thread. We will transfer over to PM when a deal has been made and ready for payment. If anyone has any questions please feel free to message me.
Disclaimer I do not have a NES/SNES/Genesis I have been trying to buy one to test all games, but haven't found any reasonably price so I will be selling those games as is, I can on the other hand insure every other games from the other systems working. I can also open up cartridges, but please be courteous don't ask me to open up low priced items. I will be glad to take as many pictures as you need to ensure happiness.
If allowed I will post a link to my google doc with everything laid out in a much more neat manner as I just copied and pasted from the spreadsheet because it would take me to long otherwise to create a template. I know it looks terrible so please bare with me and ask any questions! Thank you.
Vlexy's Collection

::NES::

Abadox Loose $9 SOLD
Air fortress Loose $5
AirWolf Loose $5
Athena Loose $8 SOLD
Breakthru Loose $5 SOLD
Cabal Loose $6 SOLD
Captain Skyhawk Loose $5 SOLD
Destination Earthstar Loose $3 SOLD
Dr. Chaos Loose $8 SOLD
Dynowarz The Destruction of Spondylus Loose $5 SOLD
Faxanadu Loose $8
Festers Quest Loose $6
Final fantasy Loose $15
Flight of the Intruder Loose $8
Frankenstein the monster returns Loose $65
Friday the 13th Loose $9
Gaunlet Loose $7
Hogans Alley Loose $6
Ikari Warriors Loose $8
Indiana Jones and the temple of doom Loose $8 SOLD
Iron Sword Wizards and Warriors II Loose $4
Jaws Loose $8
Kid Kool Loose $10 SOLD
Legend of Zelda Loose $13
Legendary Wings Loose $10 SOLD
life forceLoose $10
MagmaxLoose $5
Metal Mech Loose $10 SOLD
MetroidLoose $11
Milons Secret CastleLoose $7
P.O.W Loose $6
R.C Pro-AM Loose $6
Raid on bungeling bay Loose $8 SOLD
Rambo Loose $7
Rampage Loose $11
Renegade Loose $5
Rush'n Attack Loose $6
Scilius Loose $30
Section Z Loose $16
Silk Worm Loose $16 SOLD
Sky Shark Loose $5
Solar Jetman Loose $6 SOLD
Space Shuttle Project Loose $16 SOLD
Spy Hunter Loose $4
Star Soldier Loose $8
Star Tropics Loose $10
Star Voyager Loose $4 SOLD
Star Wars Loose $15 SOLD
The adventures of Link Loose $14
The Guardian Legend Loose $13
Top Gun Loose $5
Trojan Loose $7 SOLD
Ultima Loose $8
Wizards and Warriors Loose $6
Xevious Loose $6
Zanac Loose $13

::SNES::

Alien 3 Loose $13 On hold
Arkanoid doh it again Loose $11
Batman Forever Loose $7
Batman Returns Loose $14
Biometal Loose $32
Breath of Fire 2 Loose $50 Sold
Breath of Fire Loose $24 Sold
Chess Master Loose $4
Combatribes Loose $28 On hold
Darius Twin Loose $12
Donkey Kong Country Loose $14 SOLD
Drakkhen Loose $7
Earth Defense Force Loose $13 On hold
Final Fantasy 3 Loose $38 SOLD
Gunforce Loose $18 On Hold
Illusion of Gaia Loose $19 Sold
Indiana Jones Greatest Adventures Loose $15
Jurassic Park Loose $8
Legend of Zelda a Link to the past Loose $20 SOLD
Lock on Loose $7 On hold
Lufia 2 rise of the sinistrals Loose $60 On Hold
Lufia and the fortress of doom Loose $36 On Hold
Mario Paint Loose $9
Final Fantasy Mystic Quest Loose $14
knights of the Round Loose $60
P.T.O Loose $13
Phalanx CIB $55
pit-fighter Loose $5 On hold
Race drivin Loose $5 On hold
Rival Turf! Loose $12 On hold
Robotrek Loose $50
Secret of evermore Loose $26 On hold
Secret of mana Loose $40
Skuljagger Loose $10 On hold
Star Fox Loose $13
Star Trek the next generation Loose $8 On Hold
Strike Gunner S.T.G Loose $32 On hold
Super Battleship Loose $2
Super Empire Strikes Back Loose $10
Super Ghouls 'N Ghost Loose $21
Super Godzilla Loose $11 On Hold
Super Mario All stars Loose $13
Super Mario World Loose $12
Super Pinball Behind the Mask Loose $4 On hold
Super Star Wars Return of the Jedi Loose $10 On Hold
Super Star Wars Loose $8
Super Strike Eagle Loose $5 On hold
Hunt for red October Loose $5 On hold
The 7th Saga Loose $15
Total Carnage Loose $11 On hold
Turn and Burn no fly zone Loose $6 On hold
UN Squadron Loose $20
Uniracers Loose $15 On hold
Urban Strike Loose $7 On hold
Wing Commander Loose $6

::Genesis::

After Burner 2 Loose $13 SOLD
Air Diver Loose $4
Atomic robo.kid Loose $12 SOLD
Cyborg Justice Loose $7
Ecco the dolphin Loose $8
F-15 Strike Eagle 2 Loose $4
Indiana Jones and the Last Crusade CIB $23 SOLD
Jurrasic Park Loose $6
Lightning Force Quest for the darkstar Loose $38
Phantasy star 3 Loose $16
Rambo 3 Loose $15 SOLD
Robo-kid Loose $12
Sonic 2 Loose $5
Sonic Spinball Loose $5
Sonic The Hedge Hog Loose $6
Super Battleship Loose $2
Super Thunder Blade Loose $7 SOLD
Task Force Harrier Loose $15 SOLD
Thunder Force 3 Loose $37
TMNT - Hyperstone Heist Loose $45
Vectorman Loose $6
Wardner Loose $30 SOLD

::GBA::

Ace Combat Advance Loose $4
Batman Begins Loose $5
Bruce Lee Return of the legend Loose $4
Castlevania Aria of sorrow Loose $43 On Hold
Castlevania circle of the moon Loose $19 SOLD
Castlevania harmony of dissonance Loose $42 On Hold
F-14 Tomcat Loose $3
F-A 18F Loose $3
Golden sun Loose $19
Iridion 2 Loose $21
Iridion 3D Loose $5
Kirby Nightmare in dreamland Loose $16
Legend of Zelda the minish cap Loose $33 On Hold
Mega man Zero 2 Loose $17
Metroid Loose $12 On Hold
Metroid Fusion Loose $21 On Hold
Monster Trucks Loose $4
Need for Speed Carbon Own the city Loose $5
Phantasy Star Collection Loose $13
Pokemon Fire Red Loose $40
Saber wulf Loose $13
Sim city 2000 Loose $9
Spy Hunter Loose $4
Star Wars Flight of the falcon Loose $4
Star Wars trilogy Apprentice of the force Loose $7
Super Hornet Loose $3
The Adventures of link Zelda 2 Loose $14 SOLD
The Pinball of the dead Loose $16
ThunderBirds Loose $3
Top Gun Firestorm advance Loose $3

::GB::

AladdinLoose$6
Donkey Kong Country Loose $9
Donkey Kong Land Loose $7
Game & Watch Gallery 3 Loose $6
Gex Loose $3
Hot wheels stunt track driver Loose $3
Pokemon Blue Loose $20
Pokemon Crystal Loose $35 (No front label sticker)
Pokemon Gold Loose $22
Pokemon Green (Repro) Loose $10
Pokemon Red Loose $20
Star Wars Yoda Stories Loose $8

::PS2:: (Very Negotiable if buying a few)

007 Agent Under Fire CIB $6
007 Everything or nothing CIB $8
007 Nightfire CIB $7
Alter Echo CIB $5
Antigrav CIB $4
Bad boys Miami Takedown CIB $4
Baldurs Gate Dark Alliance $12 W/Case/Missing manual
Battlestar Galactica CIB $8
Bully CIB $13
2Champions Norath Loose $15
Champions Return to Arms CIB $26
Chaos Legion CIB $10
Demon Stone CIB $7
DT Racer CIB $3
Everblue 2 CIB $12
Final Fantasy x CIB $5
Ford VS Chevy CIB $3
God of War CIB $6
Gran Tursimo 3 CIB $4
GTA San Andreas CIB $8
GTA Vice city CIB $4
Hypersonic Extreme CIB $5
IHRA Drag Racing 2 CIB $3
Indiana Jones & the emperors tomb CIB $12
Jaw Unleashed CIB $8
Kengo Master Bushido CIB $6
Mace griffin Bounty Hunter CIB $4
Madden 05 CIB $2
Madden 06 CIB $3
Madden 10 CIB $4
Maximo Ghost to Glory Sealed $35
Medal of Honor Eurpoean Assualt CIB $4
Midnight club 3 remix CIB $12
Mortal kombat Deadly Alliance Loose $5
NBA Street Loose $5
NBA Street Vol. 2 CIB $15
NHL 06 CIB $3
Parappatherapper 2 CIB $18
Pro Race Driver CIB $3
R:Racing Evolution CIB $6
Read Dead Revolver CIB$9
Red faction CIB $5
Red Faction II CIB $6
Resident Evil Code:Veronica x CIB $8
Rogue galaxy CIB $13
RUNE: Viking Warlord $6 W case/Missing manual
S driving emotion Type-S CIB $5
Silent hill 3 Loose$30
Silent hill originsLoose/W Manual $25
Splash Down Rides Gone Wild CIB $7
Splinter Cell Pandora tomorrow Loose $3
SRS Street Racing syndicate CIB $10
Star Trek Encounters CIB $6
Star Wars Jedi Fighters Loose $4
Stolen CIB $9
Sub Rebellion CIB $10
Super Trucks Racing CIB $3
Suzuki TTSuperBikes CIB $3
The IncrediblesLoose/W Manual $4
TMNT CIB $10
Top Gun CIB $3
Transformers the game CIB $4
Ultimate Board Game collection CIB $3

::XBOX:: (Very Negotiable if buying a few)

Bloodrayne 2 CIB $12
Dead or Alive 3 CIB $6
Halo 2 CIB $5
Halo 2 Collectors edition CIB $12
Taito Legends CIB $9
Phantom Crash CIB $13
Dark Summit CIB $5
Doom 3 CIB $7
Tony Hawk pro Skater 2x CIB $13

::Gamecube::

NCAA football 03 CIB $3
Donkey Kong Jungle Beat CIB $12
Donkey Konga 2 CIB $9

::PS3:: (Negotiable if buying a few) (All games CIB unless stated otherwise)

Bayonetta $9
Def Jam icon $12
Folklore $16
Fracture $5
Gran Turismo 5 XL Edition Sealed $18
Grand theft auto V Normal $8
GTA Episodes from liberty city $6
Kingdom Hearts HD 2.5 Remix $8
Medal of honor war fighter $5
Metal Gear Rising $7
Minecraft $13
Ratchet & clank Future tools of destruction $6
Silent Hill Homecoming $11
The beatles rockband Sealed $10
Uncharted 2 Game of the year edition $4
Uncharted 3Sealed $10
Uncharted Drakes fortune Sealed $6
submitted by vlexy to GameSale [link] [comments]

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain

TL;DR: I created a spreadsheet that automates pulling trending cryptocurrencies, recent tweets, and bullish/bearish sentiment into Google Sheets. You can find it here:
https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
I know some crypto users prefer to work in spreadsheets (including myself) so I created a spreadsheet that looks at trending symbols and estimates bullish/bearish sentiment. I never had the time to develop software engineering skills, but the recent launch of a few add-ins has allowed regular joes like myself to harness the power of APIs.

The Beauty of Sentiment Trading

According to Google Trends, the word “sentiment analysis” has been gaining steady traction over the past 5 years.
Sentiment refers to the attitude expressed by an individual regarding a certain topic. This is especially relevant in trading, where so much of the change in price is dictated by emotions:
When it is applied to trading, sentiment can be used (with great potential windfall) as a directional signal to figure out whether you should enter a crypto position within your portfolio.
A way you can utilize sentiment when trading crypto, is to measure the positivity or negativity of a tweet. If recent tweets have been overwhelmingly bullish (aka, the person expects the crypto rise) and movement is beginning to happen in the currency, chances are good that the trend will continue.
Luckily for you, StockTwits already does this with around 225 different cryptocurrencies. And if you can combine the sentiment with trending cryptocurrencies, you can catch the wave right as it forms.

Services Used:

  1. Google Sheets
  2. Spreadstreet Google Sheets Add-in
  3. StockTwits
  4. CoinMarketCap API
Full disclosure: The google sheets add-in is a 14-day free trial, and $15 per month after. However, no one should be refused access on the basis of money (especially true for students and less fortunate). Send me a message, and I will make sure you are not left in the dark.

A note on security

Users have expressed hesitation about running a google sheets add-in on their main computer, so I will attempt to ease those concerns:

What it pulls:

AN OVERVIEW OF THE SECTIONS

The Dashboard
Changing the timeframe
Changing the cryptocurrency
Instructions Tab
Summary Tab

How to use the spreadsheet to spot trending cryptocurrencies

You will spend most of your time in the “Analysis” tab, where the trending cryptocurrencies reside.
I am almost always looking at the “By Hour” timeframe, as the “By Day” and “By Week” is usually a missed opportunity…however, those time frames can still be very useful (albeit, for different reasons).
You want to ride the wave on a cryptocurrency under one or both of the following conditions:
  1. The tweets are very recent, preferably within the last hour
  2. Overwhelmingly Bullish sentiment
A Great Example
A Bad Example

Getting the spreadsheet to work for you

1. Install the Spreadstreet add-in for Google Sheets
2. Get sheet ready for use with the add-in
3. After logging into the add-in, refresh the sheet

Troubleshooting

  1. Important Open the template, click the menu Add-ons / Spreadstreet / Help / View in store, and then click Manage and in the dropdown menu click “Use in this document.”
  2. A reload of the entire worksheet fixes quite a few problems.
  3. Deleting and re-pasting the formula in A1 of the “Data” tab fixes things as well.
  4. If all else fails, drop me a message
  5. The “TIMEFRAME” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
Some trending coins are not pulling correctly…what’s going on?
StockTwits has a list of ~225 coins it currently supports. See the “TweetInfo” tab for the full list.
I have tried logging in, activating the template with “Use in this document” and refreshed the sheet…still nothing.
Head to the “Data” tab. Delete the formula in cell A1, and repaste the following: =SS(“tickers-coinmarketcap”, headers, “0”, Currency)
Hoping this is something that is useful to everyone, and I am more than happy to help peeps setup the sheet so they can use it. Just send me a message on here.
Original Medium article can be found here: https://medium.com/@spreadstreet/financial-modeling-for-cryptocurrencies-the-spreadsheet-that-got-me-my-first-1-000-gain-f4d0d1a6e5ed

RESOURCES

Download the spreadsheet: https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
Download the add-in: https://spreadstreet.io/tools/google-sheets-add-in
Help: https://spreadstreet.io/docs
First time install and login: https://www.youtube.com/watch?v=aLjtPR4T2bg
Bitfinex Candles endpoint help: https://spreadstreet.io/knowledge-base/bitfinex-api-candles-endpoint/

RELATED POSTS

Top 12 Cryptocurrencies Ranked by Risk-Adjusted Return
10 Statistical Price Predictions for 10 Cryptocurrencies
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets

ABOUT THE AUTHOR

John Young is the founder of Spreadstreet.io, former Financial Analyst for a big-ass company, and runner-up in the 6th grade spelling bee. He would have invested in Google if he knew about it...and had any money.
He is the author of the Spreadstreet blog, which has over 3 readers (not a typo). He hopes to hit 10, but honestly writing is a lot of work.
submitted by 1kexperimentdotcom to CryptoCurrency [link] [comments]

[USA] [H] HUGE TRADE/SELL COLLECTION!! GB/GBC, GBA, Genesis, Neo Geo Pocket, NES, SNES, N64, PS1, Xbox one, Consoles, Manuals/Cases!! RARES/COMMONS [W] PayPal/Zelle, (PS2 & PS1 Mainly) will look at other stuff!

Hey Guys welcome to my sales/trade thread! Everything has been priced according to PriceCharting I am willing to negotiate on certain things.
My forms of payment are PayPal Invoice or Zelle/Crypto if you feel comfortable. I Pay for shipping on all items, but it is up to the buyer to pay for PayPal Invoice fees! I have will be posting a link to a feedback thread once I've made it. I have traded in other threads, but this one is new to me. I'm here to do clean/honest business and above all have fun. Also before doing a trade/sale I will make sure who I'm dealing with and make sure a clean transaction will be made.
Main wants so far: PS1 and Ps2 only (CIB & NTSC) Preferred please!
Clock Tower Series
Fatal Frame Series
Echo Night Beyong
DBZ tenkaichi 3
Marvel Vs Capcom
Marven Vs capcom 2
Castlevania Symphony of the night
Castlevania Chronicles
Ghost in the shell
Marvel Super heroes Vs Street fighter
Parasite eve 1 & 2
Kuon "Maybe" It would really depend the trade and value.
Pink Panther PS1
and Many more that I can't remember.
I will try to get back to everyone in a timely manner so please bare with me!
As per rules, I require everyone to post wants on the thread and discuss in thread. We will transfer over to PM when a deal has been made and ready for payment. If anyone has any questions please feel free to message me.
Disclaimer I do not have a NES/SNES/Genesis I have been trying to buy one to test all games, but haven't found any reasonably price so I will be selling those systems as is, I can on the other hand insure every other games from the other systems working. I will be glad to take as many pictures as you need to ensure happiness.
If allowed I will post a link to my google doc with everything laid out in a much more neat manner as I just copied and pasted from the spreadsheet because it would take me to long otherwise to create a template. I know it looks terrible so please bare with me and ask any questions! Thank you.
Vlexy's Collection

::NES::

Abadox Loose $9 On hold
Air fortress Loose $5
AirWolf Loose $5
Athena Loose $8 On hold
Breakthru Loose $5 On hold
Cabal Loose $6 On hold
Captain Skyhawk Loose $5 On hold
Destination Earthstar Loose $3 On hold
Dr. Chaos Loose $8 On hold
Dynowarz The Destruction of Spondylus Loose $5 On hold
Faxanadu Loose $8
Festers Quest Loose $6
Final fantasy Loose $15
Flight of the Intruder Loose $8
Frankenstein the monster returns Loose $65
Friday the 13th Loose $9
Gaunlet Loose $7
Hogans Alley Loose $6
Ikari Warriors Loose $8
Indiana Jones and the temple of doom Loose $8 On hold
Iron Sword Wizards and Warriors II Loose $4
Jaws Loose $8
Kid Kool Loose $10 On hold
Legend of Zelda Loose $13
Legendary Wings Loose $10 On hold
life forceLoose $10
MagmaxLoose $5
Metal MechLoose $10 On hold
MetroidLoose $11
Milons Secret CastleLoose $7
P.O.W Loose $6
R.C Pro-AM Loose $6
Raid on bungeling bay Loose $8 on hold
Rambo Loose $7
Rampage Loose $11
Renegade Loose $5
Rush'n Attack Loose $6
Scilius Loose $30
Section Z Loose $16
Silk Worm Loose $16 On hold
Sky Shark Loose $5
Solar Jetman Loose $6 On hold
Space Shuttle Project Loose $16 On hold
Spy Hunter Loose $4
Star Soldier Loose $8
Star Tropics Loose $10
Star Voyager Loose $4 On hold
Star Wars Loose $15 on hold
The adventures of Link Loose $14
The Guardian Legend Loose $13
Top Gun Loose $5
Trojan Loose $7 On hold
Ultima Loose $8
Wizards and Warriors Loose $6
Xevious Loose $6
Zanac Loose $13

::SNES::

Alien 3 Loose $13 On hold
Arkanoid doh it again Loose $11
Batman Forever Loose $7
Batman Returns Loose $14
Biometal Loose $32
Breath of Fire 2 Loose $50
Breath of Fire Loose $24
Chess Master Loose $4
Combatribes Loose $28 On hold
Darius Twin Loose $12
Donkey Kong Country Loose $14 SOLD
Drakkhen Loose $7
Earth Defense Force Loose $13 On hold
Final Fantasy 3 Loose $38 SOLD
Gunforce Loose $18 On Hold
Illusion of Gaia Loose $19
Indiana Jones Greatest Adventures Loose $15
Jurassic Park Loose $8
Legend of Zelda a Link to the past Loose $20 SOLD
Lock on Loose $7 On hold
Lufia 2 rise of the sinistrals Loose $60 On hold
Lufia and the fortress of doom Loose $36 On hold
Mario Paint Loose $9
Final Fantasy Mystic Quest Loose $14
knights of the Round Loose $60
P.T.O Loose $13
Phalanx CIB $55
pit-fighter Loose $5 On hold
Race drivin Loose $5 On hold
Rival Turf! Loose $12 On hold
Robotrek Loose $50
Secret of evermore Loose $26 On hold
Secret of mana Loose $40
Skuljagger Loose $10 On hold
Star Fox Loose $13
Star Trek the next generation Loose $8 On Hold
Strike Gunner S.T.G Loose $32 On hold
Super Battleship Loose $2
Super Empire Strikes Back Loose $10
Super Ghouls 'N Ghost Loose $21
Super Godzilla Loose $11 On Hold
Super Mario All stars Loose $13
Super Mario World Loose $12
Super Pinball Behind the Mask Loose $4 On hold
Super Star Wars Return of the Jedi Loose $10 On Hold
Super Star Wars Loose $8
Super Strike Eagle Loose $5 On hold
Hunt for red October Loose $5 On hold
The 7th Saga Loose $15
Total Carnage Loose $11 On hold
Turn and Burn no fly zone Loose $6 On hold
UN Squadron Loose $20
Uniracers Loose $15 On hold
Urban Strike Loose $7 On hold
Wing Commander Loose $6

::Genesis::

After Burner 2 Loose $13 SOLD
Air Diver Loose $4
Atomic robo.kid Loose $12 SOLD
Cyborg Justice Loose $7
Ecco the dolphin Loose $8
F-15 Strike Eagle 2 Loose $4
Indiana Jones and the Last Crusade CIB $23 SOLD
Jurrasic Park Loose $6
Lightning Force Quest for the darkstar Loose $38
Phantasy star 3 Loose $16
Rambo 3 Loose $15 SOLD
Robo-kid Loose $12
Sonic 2 Loose $5
Sonic Spinball Loose $5
Sonic The Hedge Hog Loose $6
Super Battleship Loose $2
Super Thunder Blade Loose $7 SOLD
Task Force Harrier Loose $15 SOLD
Thunder Force 3 Loose $37
TMNT - Hyperstone Heist Loose $45
Vectorman Loose $6
Wardner Loose $30 SOLD

::GBA::

Ace Combat Advance Loose $4
Batman Begins Loose $5
Bruce Lee Return of the legend Loose $4
Castlevania Aria of sorrow Loose $43
Castlevania circle of the moon Loose $19 SOLD
Castlevania harmony of dissonance Loose $42
F-14 Tomcat Loose $3
F-A 18F Loose $3
Golden sun Loose $19
Iridion 2 Loose $21
Iridion 3D Loose $5
Kirby Nightmare in dreamland Loose $16
Legend of Zelda the minish cap Loose $33
Mega man Zero 2 Loose $17
Metroid Loose $12
Metroid Fusion Loose $21
Monster Trucks Loose $4
Need for Speed Carbon Own the city Loose $5
Phantasy Star Collection Loose $13
Pokemon Fire Red Loose $40
Saber wulf Loose $13
Sim city 2000 Loose $9
Spy Hunter Loose $4
Star Wars Flight of the falcon Loose $4
Star Wars trilogy Apprentice of the force Loose $7
Super Hornet Loose $3
The Adventures of link Zelda 2 Loose $14 SOLD
The Pinball of the dead Loose $16
ThunderBirds Loose $3
Top Gun Firestorm advance Loose $3

::GB::

AladdinLoose$6
Donkey Kong Country Loose $9
Donkey Kong Land Loose $7
Game & Watch Gallery 3 Loose $6
Gex Loose $3
Hot wheels stunt track driver Loose $3
Pokemon Blue Loose $20
Pokemon Gold Loose $22
Pokemon Green (Repro) Loose $10
Star Wars Yoda Stories Loose $8

::N64::

ArrowFighters Assualt Loose $8
Automobili Lamborghini Loose $5
Castlevania Loose $13
Jet Force Gemini Loose $12
Rampage 2 Universal Tour Loose $18
Star Soldier Vanishing Earth Loose $25
Star Wars rogue Squadron Loose $9
Star Wars Shadows of the Empire Loose $7
Starfox 64 Loose $16
Topgear Ralley Loose $5
Wave Race Loose $6
XG2 Loose $6
submitted by vlexy to GameSale [link] [comments]

[USA] [H] MEGA TRADE/SELL THREAD 100s of GAMES!! GB/GBC, GBA, Genesis, NES, SNES, N64, PS2, PS3, Xbox, DS, Gamecube & MORE!! [W] PayPal Inovice/Zelle/Crypto

Hey Guys welcome to my sales/trade thread! Everything has been priced according to PriceCharting I am willing to negotiate on certain things.
Feedback Thread
My forms of payment are PayPal Invoice or Zelle/Crypto if you feel comfortable. I Pay for shipping on all items. I'm here to do clean/honest business and above all have fun. Also before doing a trade/sale I will make sure who I'm dealing with and make sure a clean transaction will be made.
I will try to get back to everyone in a timely manner so please bare with me!
As per rules, I require everyone to post wants on the thread and discuss in thread. We will transfer over to PM when a deal has been made and ready for payment. If anyone has any questions please feel free to message me.
Disclaimer I do not have a NES/SNES/Genesis I have been trying to buy one to test all games, but haven't found any reasonably price so I will be selling those games as is, I can on the other hand insure every other games from the other systems working. I can also open up cartridges, but please be courteous don't ask me to open up low priced items. I will be glad to take as many pictures as you need to ensure happiness.
If allowed I will post a link to my google doc with everything laid out in a much more neat manner as I just copied and pasted from the spreadsheet because it would take me to long otherwise to create a template. I know it looks terrible so please bare with me and ask any questions! Thank you.
Vlexy's Collection

::NES::

Air fortress Loose $5
AirWolf Loose $5
Faxanadu Loose $8
Festers Quest Loose $6
Final fantasy Loose $15
Flight of the Intruder Loose $8
Frankenstein the monster returns Loose $65
Friday the 13th Loose $9
Gaunlet Loose $7
Hogans Alley Loose $6
Ikari Warriors Loose $8
Iron Sword Wizards and Warriors II Loose $4
Jaws Loose $8
Legend of Zelda Loose $13
life forceLoose $10
MagmaxLoose $5
MetroidLoose $11
Milons Secret CastleLoose $7
P.O.W Loose $6
R.C Pro-AM Loose $6
Rambo Loose $7
Rampage Loose $11
Renegade Loose $5
Rush'n Attack Loose $6
Scilius Loose $30
Section Z Loose $16
Sky Shark Loose $5
Spy Hunter Loose $4
Star Soldier Loose $8
Star Tropics Loose $10
The adventures of Link Loose $14
The Guardian Legend Loose $13
Top Gun Loose $5
Ultima Loose $8
Wizards and Warriors Loose $6
Xevious Loose $6
Zanac Loose $13

::SNES::

Arkanoid doh it again Loose $11
Batman Forever Loose $7
Batman Returns Loose $14
Biometal Loose $32
Chess Master Loose $4
Darius Twin Loose $12
Drakkhen Loose $7
Gunforce Loose $18
Indiana Jones Greatest Adventures Loose $15
Jurassic Park Loose $8
Mario Paint Loose $9
Final Fantasy Mystic Quest Loose $14
knights of the Round Loose $60
P.T.O Loose $13
Phalanx CIB $55
Robotrek Loose $50
Secret of mana Loose $40
Star Fox Loose $13
Super Battleship Loose $2
Super Empire Strikes Back Loose $10
Super Ghouls 'N Ghost Loose $21
Super Mario All stars Loose $13
Super Mario World Loose $12
Super Star Wars Loose $8
The 7th Saga Loose $15
UN Squadron Loose $20
Wing Commander Loose $6

::Genesis::

Air Diver Loose $4
Cyborg Justice Loose $7
Ecco the dolphin Loose $8
F-15 Strike Eagle 2 Loose $4
Jurrasic Park Loose $6
Lightning Force Quest for the darkstar Loose $38
Phantasy star 3 Loose $16
Robo-kid Loose $12
Sonic 2 Loose $5
Sonic Spinball Loose $5
Sonic The Hedge Hog Loose $6
Super Battleship Loose $2
Thunder Force 3 Loose $37
TMNT - Hyperstone Heist Loose $45
Vectorman Loose $6

::GBA::

Ace Combat Advance Loose $4
Batman Begins Loose $5
Bruce Lee Return of the legend Loose $4
Castlevania Aria of sorrow Loose $43 On Hold
Castlevania harmony of dissonance Loose $42 On Hold
F-14 Tomcat Loose $3
F-A 18F Loose $3
Iridion 2 Loose $21
Iridion 3D Loose $5
Kirby Nightmare in dreamland Loose $16
Legend of Zelda the minish cap Loose $33 On Hold
Mega man Zero 2 Loose $17
Metroid Loose $12 On Hold
Metroid Fusion Loose $21 On Hold
Monster Trucks Loose $4
Need for Speed Carbon Own the city Loose $5
Phantasy Star Collection Loose $13
Pokemon Fire Red Loose $40 SOLD
Saber wulf Loose $13
Sim city 2000 Loose $9
Spy Hunter Loose $4
Star Wars Flight of the falcon Loose $4
Star Wars trilogy Apprentice of the force Loose $7
Super Hornet Loose $3
The Pinball of the dead Loose $16
ThunderBirds Loose $3
Top Gun Firestorm advance Loose $3

::GB::

AladdinLoose$6
Donkey Kong Country Loose $9
Donkey Kong Land Loose $7
Game & Watch Gallery 3 Loose $6
Gex Loose $3
Hot wheels stunt track driver Loose $3
Pokemon Blue Loose $20
Pokemon Crystal Loose $35 (No front label sticker)
Pokemon Gold Loose $22
Pokemon Green (Repro) Loose $10
Pokemon Red Loose $20
Star Wars Yoda Stories Loose $8

::PS2:: (Very Negotiable if buying a few)

007 Agent Under Fire CIB $6
007 Everything or nothing CIB $8
007 Nightfire CIB $7
Alter Echo CIB $5
Antigrav CIB $4
Bad boys Miami Takedown CIB $4
Baldurs Gate Dark Alliance $12 W/Case/Missing manual
Battlestar Galactica CIB $8
Bully CIB $13
Champions Norath Loose $15
Chaos Legion CIB $10
Demon Stone CIB $7
DT Racer CIB $3
Everblue 2 CIB $12
Final Fantasy x CIB $5
Ford VS Chevy CIB $3
God of War CIB $6
Gran Tursimo 3 CIB $4
GTA San Andreas CIB $8
GTA Vice city CIB $4
Hypersonic Extreme CIB $5
IHRA Drag Racing 2 CIB $3
Jaw Unleashed CIB $8
Kengo Master Bushido CIB $6
Mace griffin Bounty Hunter CIB $4
Madden 05 CIB $2
Madden 06 CIB $3
Madden 10 CIB $4
Maximo Ghost to Glory Sealed $35
Medal of Honor Eurpoean Assualt CIB $4
Midnight club 3 remix CIB $12
Mortal kombat Deadly Alliance Loose $5
NBA Street Loose $5
NBA Street Vol. 2 CIB $15
NHL 06 CIB $3
Pro Race Driver CIB $3
R:Racing Evolution CIB $6
Read Dead Revolver CIB$9
Red faction CIB $5
Red Faction II CIB $6
Resident Evil Code:Veronica x CIB $8
Rogue galaxy CIB $13
RUNE: Viking Warlord $6 W case/Missing manual
S driving emotion Type-S CIB $5
Silent hill 3 Loose$30
Silent hill originsLoose/W Manual $25
Splash Down Rides Gone Wild CIB $7
Splinter Cell Pandora tomorrow Loose $3
SRS Street Racing syndicate CIB $10
Star Trek Encounters CIB $6
Star Wars Jedi Fighters Loose $4
Stolen CIB $9
Sub Rebellion CIB $10
Super Trucks Racing CIB $3
Suzuki TTSuperBikes CIB $3
The IncrediblesLoose/W Manual $4
TMNT CIB $10
Top Gun CIB $3
Transformers the game CIB $4
Ultimate Board Game collection CIB $3

::XBOX:: (Very Negotiable if buying a few)

Bloodrayne 2 CIB $12
Dead or Alive 3 CIB $6
Halo 2 CIB $5
Halo 2 Collectors edition CIB $12
Taito Legends CIB $9
Phantom Crash CIB $13
Dark Summit CIB $5
Doom 3 CIB $7
Tony Hawk pro Skater 2x CIB $13

::Gamecube::

NCAA football 03 CIB $3
Donkey Kong Jungle Beat CIB $12
Donkey Konga 2 CIB $9

::PS3:: (Negotiable if buying a few) (All games CIB unless stated otherwise)

Bayonetta $9
Def Jam icon $12
Folklore $16
Fracture $5
Gran Turismo 5 XL Edition Sealed $18
Grand theft auto V Normal $8
GTA Episodes from liberty city $6
Kingdom Hearts HD 2.5 Remix $8
Medal of honor war fighter $5
Minecraft $13
Ratchet & clank Future tools of destruction $6
Silent Hill Homecoming $11
The beatles rockband Sealed $10
Uncharted 2 Game of the year edition $4
Uncharted 3Sealed $10
Uncharted Drakes fortune Sealed $6

::DS::
Bakugan Battle Brawlers $4 loose
Crash Mind Over Mutant $10 loose
Igor $3 loose
Pokemon Heart gold $50 loose
Pokemon Moon $13 loose
Pokemon Sun $13 loose
Sonic Colors $8 loose
submitted by vlexy to GameSale [link] [comments]

[USA] [H] Huge Sale Thread! 100+ Games GB/GBC, GBA, Genesis, NES, SNES, N64, PS2, PS3, Xbox, DS, Gamecube & MORE!! [W] PayPal Inovice/Zelle/Crypto

Hey Guys welcome to my sales/trade thread! Everything has been priced according to PriceCharting I am willing to negotiate on certain things.
Feedback Thread
My forms of payment are PayPal Invoice or Zelle/Crypto if you feel comfortable. I Pay for shipping on all items. I'm here to do clean/honest business and above all have fun. Also before doing a trade/sale I will make sure who I'm dealing with and make sure a clean transaction will be made.
I will not take transactions less then $20
I will try to get back to everyone in a timely manner so please bare with me!
As per rules, I require everyone to post wants on the thread and discuss in thread. We will transfer over to PM when a deal has been made and ready for payment. If anyone has any questions please feel free to message me.
Disclaimer I do not have a NES/Genesis I have been trying to buy one to test all games, but haven't found any reasonably price so I will be selling those games as is, I can on the other hand insure every other games from the other systems working. I can also open up cartridges, but please be courteous don't ask me to open up low priced items. I will be glad to take as many pictures as you need to ensure happiness.
If allowed I will post a link to my google doc with everything laid out in a much more neat manner as I just copied and pasted from the spreadsheet because it would take me to long otherwise to create a template. I know it looks terrible so please bare with me and ask any questions! Thank you.
Vlexy's Collection

::NES::

Air fortress Loose $5
AirWolf Loose $5
Faxanadu Loose $8
Festers Quest Loose $6
Final fantasy Loose $15
Flight of the Intruder Loose $8
Frankenstein the monster returns Loose $65
Friday the 13th Loose $9
Gaunlet Loose $7
Hogans Alley Loose $6
Ikari Warriors Loose $8
Iron Sword Wizards and Warriors II Loose $4
Jaws Loose $8
Legend of Zelda Loose $13
life forceLoose $10
MagmaxLoose $5
MetroidLoose $11
Milons Secret CastleLoose $7
P.O.W Loose $6
R.C Pro-AM Loose $6
Rambo Loose $7
Rampage Loose $11
Renegade Loose $5
Rush'n Attack Loose $6
Scilius Loose $30
Section Z Loose $16
Sky Shark Loose $5
Spy Hunter Loose $4
Star Soldier Loose $8
Star Tropics Loose $10
The adventures of Link Loose $14
The Guardian Legend Loose $13
Top Gun Loose $5
Ultima Loose $8
Wizards and Warriors Loose $6
Xevious Loose $6
Zanac Loose $13

::SNES::

Arkanoid doh it again Loose $11
Batman Forever Loose $7
Batman Returns Loose $14
Biometal Loose $32
Chess Master Loose $4
Darius Twin Loose $12
Drakkhen Loose $7
Gunforce Loose $18
Indiana Jones Greatest Adventures Loose $15
Jurassic Park Loose $8
Mario Paint Loose $9
Final Fantasy Mystic Quest Loose $14
knights of the Round Loose $60
P.T.O Loose $13
Phalanx CIB $55
Robotrek Loose $50
Secret of mana Loose $40
Star Fox Loose $13
Super Battleship Loose $2
Super Empire Strikes Back Loose $10
Super Ghouls 'N Ghost Loose $21
Super Mario All stars Loose $13
Super Mario World Loose $12
Super Star Wars Loose $8
The 7th Saga Loose $15
UN Squadron Loose $20
Wing Commander Loose $6

::N64::
Jet Force Gemini Loose $12
Rampage 2 Universal Tour Loose $18
Star Soldier Vanishing Earth Loose $25
Star Wars rogue Squadron Loose $9
Star Wars Shadows of the Empire Loose $7
Wave Race Loose $6
XG2 Loose $6

::Genesis::

Air Diver Loose $4
Cyborg Justice Loose $7
Ecco the dolphin Loose $8
F-15 Strike Eagle 2 Loose $4
Jurrasic Park Loose $6
Lightning Force Quest for the darkstar Loose $38
Phantasy star 3 Loose $16 Sold
Robo-kid Loose $12
Sonic 2 Loose $5
Sonic Spinball Loose $5
Sonic The Hedge Hog Loose $6
Super Battleship Loose $2
Thunder Force 3 Loose $37
TMNT - Hyperstone Heist Loose $45
Vectorman Loose $6 Sold

::GBA::

Ace Combat Advance Loose $4
Batman Begins Loose $5
Bruce Lee Return of the legend Loose $4
Castlevania Aria of sorrow Loose $43 On Hold
Castlevania harmony of dissonance Loose $42 On Hold
F-14 Tomcat Loose $3
F-A 18F Loose $3
Iridion 2 Loose $21
Iridion 3D Loose $5
Kirby Nightmare in dreamland Loose $16
Legend of Zelda the minish cap Loose $33 On Hold
Mega man Zero 2 Loose $17
Metroid Loose $12 On Hold
Metroid Fusion Loose $21 On Hold
Monster Trucks Loose $4
Need for Speed Carbon Own the city Loose $5
Phantasy Star Collection Loose $13
Pokemon Fire Red Loose $40 SOLD
Saber wulf Loose $13
Sim city 2000 Loose $9
Spy Hunter Loose $4
Star Wars Flight of the falcon Loose $4
Star Wars trilogy Apprentice of the force Loose $7
Super Hornet Loose $3
The Pinball of the dead Loose $16
ThunderBirds Loose $3
Top Gun Firestorm advance Loose $3

::GB::

AladdinLoose$6
Donkey Kong Country Loose $9
Donkey Kong Land Loose $7
Game & Watch Gallery 3 Loose $6
Gex Loose $3
Hot wheels stunt track driver Loose $3
Pokemon Blue Loose $20
Pokemon Crystal Loose $35 (No front label sticker)
Pokemon Gold Loose $22
Pokemon Green (Repro) Loose $10
Pokemon Red Loose $20
Star Wars Yoda Stories Loose $8

::PS2:: (Very Negotiable if buying a few)

007 Agent Under Fire CIB $6
007 Everything or nothing CIB $8
007 Nightfire CIB $7
Alter Echo CIB $5
Antigrav CIB $4
Bad boys Miami Takedown CIB $4
Baldurs Gate Dark Alliance $12 W/Case/Missing manual
Battlestar Galactica CIB $8
Bully CIB $13
Champions Norath Loose $15
Chaos Legion CIB $10
Demon Stone CIB $7
DT Racer CIB $3
Everblue 2 CIB $12
Final Fantasy x CIB $5
Ford VS Chevy CIB $3
God of War CIB $6
Gran Tursimo 3 CIB $4
GTA San Andreas CIB $8
GTA Vice city CIB $4
Hypersonic Extreme CIB $5
IHRA Drag Racing 2 CIB $3
Jaw Unleashed CIB $8
Kengo Master Bushido CIB $6
Mace griffin Bounty Hunter CIB $4
Maximo Ghost to Glory Sealed $35
Medal of Honor Eurpoean Assualt CIB $4
Midnight club 3 remix CIB $12
Mortal kombat Deadly Alliance Loose $5
NBA Street Loose $5
NBA Street Vol. 2 CIB $15
NHL 06 CIB $3
Pro Race Driver CIB $3
R:Racing Evolution CIB $6
Read Dead Revolver CIB$9
Resident Evil Code:Veronica x CIB $8
Rogue galaxy CIB $13
RUNE: Viking Warlord $6 W case/Missing manual
S driving emotion Type-S CIB $5
Silent hill 3 Loose$30
Silent hill originsLoose/W Manual $25
Splash Down Rides Gone Wild CIB $7
Splinter Cell Pandora tomorrow Loose $3
SRS Street Racing syndicate CIB $10
Star Trek Encounters CIB $6
Star Wars Jedi Fighters Loose $4
Stolen CIB $9
Sub Rebellion CIB $10
Super Trucks Racing CIB $3
Suzuki TTSuperBikes CIB $3
The IncrediblesLoose/W Manual $4
TMNT CIB $10
Top Gun CIB $3
Transformers the game CIB $4
Ultimate Board Game collection CIB $3

::XBOX:: (Very Negotiable if buying a few)

Bloodrayne 2 CIB $12
Dead or Alive 3 CIB $6
Halo 2 CIB $5
Halo 2 Collectors edition CIB $12
Taito Legends CIB $9
Phantom Crash CIB $13
Dark Summit CIB $5
Doom 3 CIB $7
Tony Hawk pro Skater 2x CIB $13

::Gamecube::

NCAA football 03 CIB $3
Donkey Kong Jungle Beat CIB $12
Donkey Konga 2 CIB $9

::PS3:: (Negotiable if buying a few) (All games CIB unless stated otherwise)

Bayonetta $9
Def Jam icon $12
Folklore $16
Fracture $5
Gran Turismo 5 XL Edition Sealed $18
Grand theft auto V Normal $8
GTA Episodes from liberty city $6
Kingdom Hearts HD 2.5 Remix $8
Medal of honor war fighter $5
Minecraft $13
Ratchet & clank Future tools of destruction $6
Silent Hill Homecoming $11
The beatles rockband Sealed $10
Uncharted 2 Game of the year edition $4
Uncharted 3Sealed $10
Uncharted Drakes fortune Sealed $6

::DS::
Bakugan Battle Brawlers $4 loose
Crash Mind Over Mutant $10 loose
Igor $3 loose
Pokemon Heart gold $50 loose
Pokemon Moon $13 loose
Pokemon Sun $13 loose
Sonic Colors $8 loose
submitted by vlexy to GameSale [link] [comments]

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain

TL;DR: I created a spreadsheet that automates pulling trending cryptocurrencies, recent tweets, and bullish/bearish sentiment into Google Sheets. You can find it here:
https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
I know some crypto users prefer to work in spreadsheets (including myself) so I created a spreadsheet that looks at trending symbols and estimates bullish/bearish sentiment. I never had the time to develop software engineering skills, but the recent launch of a few add-ins has allowed regular joes like myself to harness the power of APIs.

The Beauty of Sentiment Trading

According to Google Trends, the word “sentiment analysis” has been gaining steady traction over the past 5 years.
Sentiment refers to the attitude expressed by an individual regarding a certain topic. This is especially relevant in trading, where so much of the change in price is dictated by emotions:
When it is applied to trading, sentiment can be used (with great potential windfall) as a directional signal to figure out whether you should enter a crypto position within your portfolio.
A way you can utilize sentiment when trading crypto, is to measure the positivity or negativity of a tweet. If recent tweets have been overwhelmingly bullish (aka, the person expects the crypto rise) and movement is beginning to happen in the currency, chances are good that the trend will continue.
Luckily for you, StockTwits already does this with around 225 different cryptocurrencies. And if you can combine the sentiment with trending cryptocurrencies, you can catch the wave right as it forms.

Services Used:

  1. Google Sheets
  2. Spreadstreet Google Sheets Add-in
  3. StockTwits
  4. CoinMarketCap API
Full disclosure: The google sheets add-in is a 14-day free trial, and $15 per month after. However, no one should be refused access on the basis of money (especially true for students and less fortunate). Send me a message, and I will make sure you are not left in the dark.

A note on security

Users have expressed hesitation about running a google sheets add-in on their main computer, so I will attempt to ease those concerns:

What it pulls:

AN OVERVIEW OF THE SECTIONS

The Dashboard
Changing the timeframe
Changing the cryptocurrency
Instructions Tab
Summary Tab

How to use the spreadsheet to spot trending cryptocurrencies

You will spend most of your time in the “Analysis” tab, where the trending cryptocurrencies reside.
I am almost always looking at the “By Hour” timeframe, as the “By Day” and “By Week” is usually a missed opportunity…however, those time frames can still be very useful (albeit, for different reasons).
You want to ride the wave on a cryptocurrency under one or both of the following conditions:
  1. The tweets are very recent, preferably within the last hour
  2. Overwhelmingly Bullish sentiment
A Great Example
A Bad Example

Getting the spreadsheet to work for you

1. Install the Spreadstreet add-in for Google Sheets
2. Get sheet ready for use with the add-in
3. After logging into the add-in, refresh the sheet

Troubleshooting

  1. Important Open the template, click the menu Add-ons / Spreadstreet / Help / View in store, and then click Manage and in the dropdown menu click “Use in this document.”
  2. A reload of the entire worksheet fixes quite a few problems.
  3. Deleting and re-pasting the formula in A1 of the “Data” tab fixes things as well.
  4. If all else fails, drop a line to [email protected]. He will get you running in no time.
  5. The “TIMEFRAME” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
Some trending coins are not pulling correctly…what’s going on?
StockTwits has a list of ~225 coins it currently supports. See the “TweetInfo” tab for the full list.
I have tried logging in, activating the template with “Use in this document” and refreshed the sheet…still nothing.
Head to the “Data” tab. Delete the formula in cell A1, and repaste the following: =SS(“tickers-coinmarketcap”, headers, “0”, Currency)
Hoping this is something that is useful to everyone, and I am more than happy to help peeps setup the sheet so they can use it. Just send me a message on here.
Original Medium article can be found here: https://medium.com/@spreadstreet/financial-modeling-for-cryptocurrencies-the-spreadsheet-that-got-me-my-first-1-000-gain-f4d0d1a6e5ed

RESOURCES

Download the spreadsheet: https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
Download the add-in: https://spreadstreet.io/tools/google-sheets-add-in
Help: https://spreadstreet.io/docs
First time install and login: https://www.youtube.com/watch?v=aLjtPR4T2bg
Bitfinex Candles endpoint help: https://spreadstreet.io/knowledge-base/bitfinex-api-candles-endpoint/

RELATED POSTS

Top 12 Cryptocurrencies Ranked by Risk-Adjusted Return
10 Statistical Price Predictions for 10 Cryptocurrencies
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets

ABOUT THE AUTHOR

John Young is the founder of Spreadstreet.io, former Financial Analyst for a big-ass company, and runner-up in the 6th grade spelling bee. He would have invested in Google if he knew about it...and had any money.
He is the author of the Spreadstreet blog, which has over 3 readers (not a typo). He hopes to hit 10, but honestly writing is a lot of work.
submitted by 1kexperimentdotcom to LitecoinMarkets [link] [comments]

10 Statistical Price Predictions for 10 Cryptocurrencies — January 2018

TL;DR: I simulated a 1-year movement of 10 top cryptocurrencies using an advanced statistical method called geometric Brownian motion, which you can find below. I also created a spreadsheet to simulate prices of ~24 different cryptocurrencies, which you can download here: https://docs.google.com/spreadsheets/d/1eUIgBowJs2NyKw7kYbx5z_VeCOxsMQdNELfbngs4XnY/copy. The sheet utilizes a paid add-in, which I provide free of cost to those who are less fortunate.

THE MYSTERY OF PRICE MOVEMENT

So, you’re sitting at your computer with money to invest.
You have made some good money already in the market, but you want more.
Cryptocurrencies have reached a record $600 billion in market value after the recovery, with the inevitable $700 billion mark right around the corner.
The price movement of top currencies remains a mystery. But it doesn’t have to be.

THE PAIN OF UNCERTAINTY

Cryptocurrencies are volatile, irrational beasts.
Simple methods of forecasting grossly oveunderestimate the potential of a volatile currency.
For example, moving averages are used frequently to estimate future prices. Moving averages, however, suffer from many pitfalls that make them poor estimators of volatile markets.
Every great and successful investor has a plan. You will add one more tool to your arsenal today.

A BETTER METHOD FOR ESTIMATING CRYPTO PRICES

In my prior article about estimating the movement of Bitcoin Prices, I spoke of a method that is used frequently in the stock world to estimate prices.
This method is a Monte Carlo simulation using the geometric Brownian motion model.
I won’t cover off on the full methodology here, but essentially I am going to:
  1. Get historical daily prices for 10 top cryptocurrencies
  2. Calculate daily returns
  3. Simulate a year
  4. Simulate a year many times
By the end of the article, you will have the following:
A note on forecasting, simulations, and recommendations: Monte Carlo simulations are to be used as guidelines and tools, not as gospel. I am not offering financial or investing advice.

BITCOIN

What is Bitcoin?

You know what Bitcoin is, stop it.

One-Year Simulation

1-Year Simulation of Bitcoin Prices and Returns

One-Year Simulated 1,000 Times

1-Year Bitcoin Prices Simulated 1,000 times

Verdict

We can be 95% certain that Bitcoin prices will fall between $9,095, and $371,588 with a median of $60,837.

BITCOIN CASH

What is Bitcoin Cash?

From the Bitcoin Cash project website:
“Bitcoin Cash is peer-to-peer electronic cash for the Internet. It is fully decentralized, with no central bank and requires no trusted third parties to operate.”
Really, it was an additional currency that was created after a fork from Bitcoin core.

One-Year Simulation

1-Year Simulation of Bitcoin Cash Prices and Returns

One-Year Simulated 1,000 Times

1-Year Bitcoin Cash Prices Simulated 1,000 times

Verdict

We can be 95% certain that Bitcoin Cash prices will fall between $197, and $180,288 with a median of $4,839.

ETHEREUM

What is Ethereum?

Ethereum is a decentralized platform that runs smart contracts: applications that run exactly as programmed without any possibility of downtime, censorship, fraud or third party interference.
Ethereum has been busy recently. Multiple steps have been pushed in motion for the upcoming large change — reaching a new consensus method.
From Jordan Daniel at ethnews.com:
Ethereum’s Byzantium hard fork was only one half of a two-part process designed to transition the decentralized application platform to a new method for reaching consensus — proof-of-stake. The next hard fork, called Constantinople, was recently discussed during an Ethereum core developer meeting and could include Vitalik Buterin’s Casper update.

One-Year Simulation

1-Year Simulation of Ethereum Prices and Returns

One-Year Simulated 1,000 Times

1-Year Ethereum Prices Simulated 1,000 times

Verdict

We can be 95% certain that Ethereum prices will fall between $193, and $8,027 with a median of $1,267.

EOS

What is EOS?

EOS is a blockchain-based, decentralized operating system, designed to support commercial-scale decentralized applications by providing all of the necessary core functionality, enabling businesses to build blockchain applications in a way similar to web-based applications.

One-Year Simulation

1-Year Simulation of EOS Prices and Returns

One-Year Simulated 1,000 Times

1-Year EOS Prices Simulated 1,000 times

Verdict

We can be 95% certain that EOS prices will fall between $0.98, and $1,386 with a median of $33.

LITECOIN

What is Litecoin?

Litecoin’s claim to fame is faster transaction processing times. It uses a scrypt-based mining proof-of-work algorithm to target the regular computers and GPUs most people already have.
The ability to target regular computers and GPU’s happens to be a huge differentiator from the crowded mining population of Bitcoin.

One-Year Simulation

1-Year Simulation of Litecoin Prices and Returns

One-Year Simulated 1,000 Times

1-Year Litecoin Prices Simulated 1,000 times

Verdict

We can be 95% certain that Litecoin prices will fall between $42, and $12,241 with a median of $745.

OMISEGO

What is OmiseGO?

OmiseGO is building a couple of things:
  1. Decentralized exchange
  2. Liquidity provider mechanism
  3. Clearinghouse messaging network
  4. Asset-backed blockchain gateway
OmiseGO is not owned by any single one party. Instead, it is an open distributed network of validators which enforce behavior of all participants.
According to Blocknight:
Also, OmiseGo counts Vitalik Buterin (Ethereum), and Joseph Poon (Lightning Network Co Author) among their advisers. Joseph Poon is actually billed as author of the OmiseGo whitepaper.
Those are some pretty big names.

One-Year Simulation

1-Year Simulation of OmiseGO Prices and Returns

One-Year Simulated 1,000 Times

1-Year OmiseGO Prices Simulated 1,000 times

Verdict

We can be 95% certain that OmiseGO prices will fall between $0.62, and $185.35 with a median of $8.56.

NEO

What is NEO?

NEO (formerly known as AntShares) is a smart asset platform and the first open source public blockchain project in China. Smart assets are the combination of smart blockchain contracts and digital assets.

One-Year Simulation

1-Year Simulation of NEO Prices and Returns

One-Year Simulated 1,000 Times

1-Year NEO Prices Simulated 1,000 times

Verdict

We can be 95% certain that NEO prices will fall between $3, and $3,076 with a median of $115.

RIPPLE

What is Ripple?

Ripple is a system created for banks to enable immediate payments and lower costs.
The vision of the Ripple creators is to allow a bank transfer in a few seconds (instead of the horribly annoying 2–3 business days).
Of note, is that Ripple is a U.S. based company. From the xrphodor blog:
Ripple is a US-based company.
Why is this an important point to consider? A US-based company like Ripple is subject to some very stringent laws regarding securities trading and money transmission. These include requirements that define how Ripple might interact with crypto markets and both institutional and retail crypto traders.

One-Year Simulation

1-Year Simulation of Ripple Prices and Returns

One-Year Simulated 1,000 Times

1-Year Ripple Prices Simulated 1,000 times

Verdict

We can be 95% certain that Ripple prices will fall between $0.05, and $163 with a median of $2.71.

MONERO

What is Monero?

Monero attempts to solve privacy and fungibility issues that persist in Bitcoin.
Part of the algorithm for Monero automatically mixes transactions with previous transactions and does this by implementing ring signatures.

One-Year Simulation

1-Year Simulation of Monero Prices and Returns

One-Year Simulated 1,000 Times

1-Year Monero Prices Simulated 1,000 times

Verdict

We can be 95% certain that Monero prices will fall between $68, and $8,142 with a median of $760.

Zcash

What is Zcash?

From the Blockchainhub infographic:
Zcash is a permissionless cryptocurrency that can fully protect the privacy of transactions using zero-knowledge cryptography.

One-Year Simulation

1-Year Simulation of ZCash Prices and Returns

One-Year Simulated 1,000 Times

1-Year ZCash Prices Simulated 1,000 times

Verdict

We can be 95% certain that Zcash prices will fall between $54, and $6,259 with a median of $549.

YOUR VERY OWN FORECASTING TOOL

Since i’m so nice, I went ahead and created a forecasting tool for you to use:
https://docs.google.com/spreadsheets/d/1eUIgBowJs2NyKw7kYbx5z_VeCOxsMQdNELfbngs4XnY/copy

SERVICES USED:

  1. Google Sheets
  2. Spreadstreet Google Sheets Add-in
  3. StockTwits
  4. CoinMarketCap API
Full disclosure: The google sheets add-in is a 14-day free trial, and $15 per month after. However, no one should be refused access on the basis of money (especially true for students and less fortunate). Send me a message, and I will make sure you are not left in the dark.

A NOTE ON SECURITY

Users have expressed hesitation about running a google sheets add-in on their main computer, so I will attempt to ease those concerns:

WHAT IT PULLS:

GETTING THE SPREADSHEET TO WORK FOR YOU

Install the Spreadstreet add-in for Google Sheets
Get sheet ready for use with the add-in
After logging into the add-in, change the dropdown reference

TROUBLESHOOTING

  1. Important Open the template, click the menu Add-ons / Spreadstreet / Help / View in store, and then click Manage and in the dropdown menu click “Use in this document.”
  2. A reload of the entire worksheet fixes quite a few problems.
  3. Deleting and re-pasting the formula in A1 of the “Candles” tab fixes things as well.
  4. If all else fails, drop me a message
  5. The “SELECT CURRENCY” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
When I try and change a coin, I get a #DIV/0 error
Login to the Spreadstreet add-in, and keep the window open. Try changing the dropdown again.
I have tried logging in, activating the template with “Use in this document” and refreshed the sheet…still nothing.
Head to the “Data” tab. Delete the formula in cell A1, and repaste the following: =SS(“candles-bitfinex”, ticker, “1D”, “hist”, true, “”, “”, “”, “0”)

CONCLUSION

Whether you are investing in Bitcoin, Ethereum, or SpankCoin, it is imperative to have a plan. Most notably, a worst-case scenario.
The Monte Carlo simulation is a fantastic way to get a range of prices for a cryptocurrency. And after reading this, you can see how the final values change drastically depending on what you are looking at.
I urge you to download the sheet and try your own hand at simulating different coins. The sheet is setup to pull in every single coin from CoinMarketCap.
Cheers, and happy hunting
Original article can be found here: https://medium.com/@spreadstreet/10-statistical-price-predictions-for-10-cryptocurrencies-january-2018-3dcf04bf9d9a

RELATED POSTS

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain
A Super Simple Cryptocurrency Arbitrage Spreadsheet for Finding Mismatched Prices
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets
7 Smart Ethereum Price Prediction Methods for HODL’ers
submitted by 1kexperimentdotcom to CryptoMarkets [link] [comments]

10 Statistical Price Predictions for 10 Cryptocurrencies — January 2018

TL;DR: I simulated a 1-year movement of 10 top cryptocurrencies using an advanced statistical method called geometric Brownian motion, which you can find below. I also created a spreadsheet to simulate prices of ~24 different cryptocurrencies, which you can download here: https://docs.google.com/spreadsheets/d/1eUIgBowJs2NyKw7kYbx5z_VeCOxsMQdNELfbngs4XnY/copy. The sheet utilizes a paid add-in, which I provide free of cost to those who are less fortunate.

THE MYSTERY OF PRICE MOVEMENT

So, you’re sitting at your computer with money to invest.
You have made some good money already in the market, but you want more.
Cryptocurrencies have reached a record $600 billion in market value after the recovery, with the inevitable $700 billion mark right around the corner.
The price movement of top currencies remains a mystery. But it doesn’t have to be.

THE PAIN OF UNCERTAINTY

Cryptocurrencies are volatile, irrational beasts.
Simple methods of forecasting grossly oveunderestimate the potential of a volatile currency.
For example, moving averages are used frequently to estimate future prices. Moving averages, however, suffer from many pitfalls that make them poor estimators of volatile markets.
Every great and successful investor has a plan. You will add one more tool to your arsenal today.

A BETTER METHOD FOR ESTIMATING CRYPTO PRICES

In my prior article about estimating the movement of Bitcoin Prices, I spoke of a method that is used frequently in the stock world to estimate prices.
This method is a Monte Carlo simulation using the geometric Brownian motion model.
I won’t cover off on the full methodology here, but essentially I am going to:
  1. Get historical daily prices for 10 top cryptocurrencies
  2. Calculate daily returns
  3. Simulate a year
  4. Simulate a year many times
By the end of the article, you will have the following:
A note on forecasting, simulations, and recommendations: Monte Carlo simulations are to be used as guidelines and tools, not as gospel. I am not offering financial or investing advice.

BITCOIN

What is Bitcoin?

You know what Bitcoin is, stop it.

One-Year Simulation

1-Year Simulation of Bitcoin Prices and Returns

One-Year Simulated 1,000 Times

1-Year Bitcoin Prices Simulated 1,000 times

Verdict

We can be 95% certain that Bitcoin prices will fall between $9,095, and $371,588 with a median of $60,837.

BITCOIN CASH

What is Bitcoin Cash?

From the Bitcoin Cash project website:
“Bitcoin Cash is peer-to-peer electronic cash for the Internet. It is fully decentralized, with no central bank and requires no trusted third parties to operate.”
Really, it was an additional currency that was created after a fork from Bitcoin core.

One-Year Simulation

1-Year Simulation of Bitcoin Cash Prices and Returns

One-Year Simulated 1,000 Times

1-Year Bitcoin Cash Prices Simulated 1,000 times

Verdict

We can be 95% certain that Bitcoin Cash prices will fall between $197, and $180,288 with a median of $4,839.

ETHEREUM

What is Ethereum?

Ethereum is a decentralized platform that runs smart contracts: applications that run exactly as programmed without any possibility of downtime, censorship, fraud or third party interference.
Ethereum has been busy recently. Multiple steps have been pushed in motion for the upcoming large change — reaching a new consensus method.
From Jordan Daniel at ethnews.com:
Ethereum’s Byzantium hard fork was only one half of a two-part process designed to transition the decentralized application platform to a new method for reaching consensus — proof-of-stake. The next hard fork, called Constantinople, was recently discussed during an Ethereum core developer meeting and could include Vitalik Buterin’s Casper update.

One-Year Simulation

1-Year Simulation of Ethereum Prices and Returns

One-Year Simulated 1,000 Times

1-Year Ethereum Prices Simulated 1,000 times

Verdict

We can be 95% certain that Ethereum prices will fall between $193, and $8,027 with a median of $1,267.

EOS

What is EOS?

EOS is a blockchain-based, decentralized operating system, designed to support commercial-scale decentralized applications by providing all of the necessary core functionality, enabling businesses to build blockchain applications in a way similar to web-based applications.

One-Year Simulation

1-Year Simulation of EOS Prices and Returns

One-Year Simulated 1,000 Times

1-Year EOS Prices Simulated 1,000 times

Verdict

We can be 95% certain that EOS prices will fall between $0.98, and $1,386 with a median of $33.

LITECOIN

What is Litecoin?

Litecoin’s claim to fame is faster transaction processing times. It uses a scrypt-based mining proof-of-work algorithm to target the regular computers and GPUs most people already have.
The ability to target regular computers and GPU’s happens to be a huge differentiator from the crowded mining population of Bitcoin.

One-Year Simulation

1-Year Simulation of Litecoin Prices and Returns

One-Year Simulated 1,000 Times

1-Year Litecoin Prices Simulated 1,000 times

Verdict

We can be 95% certain that Litecoin prices will fall between $42, and $12,241 with a median of $745.

OMISEGO

What is OmiseGO?

OmiseGO is building a couple of things:
  1. Decentralized exchange
  2. Liquidity provider mechanism
  3. Clearinghouse messaging network
  4. Asset-backed blockchain gateway
OmiseGO is not owned by any single one party. Instead, it is an open distributed network of validators which enforce behavior of all participants.
According to Blocknight:
Also, OmiseGo counts Vitalik Buterin (Ethereum), and Joseph Poon (Lightning Network Co Author) among their advisers. Joseph Poon is actually billed as author of the OmiseGo whitepaper.
Those are some pretty big names.

One-Year Simulation

1-Year Simulation of OmiseGO Prices and Returns

One-Year Simulated 1,000 Times

1-Year OmiseGO Prices Simulated 1,000 times

Verdict

We can be 95% certain that OmiseGO prices will fall between $0.62, and $185.35 with a median of $8.56.

NEO

What is NEO?

NEO (formerly known as AntShares) is a smart asset platform and the first open source public blockchain project in China. Smart assets are the combination of smart blockchain contracts and digital assets.

One-Year Simulation

1-Year Simulation of NEO Prices and Returns

One-Year Simulated 1,000 Times

1-Year NEO Prices Simulated 1,000 times

Verdict

We can be 95% certain that NEO prices will fall between $3, and $3,076 with a median of $115.

RIPPLE

What is Ripple?

Ripple is a system created for banks to enable immediate payments and lower costs.
The vision of the Ripple creators is to allow a bank transfer in a few seconds (instead of the horribly annoying 2–3 business days).
Of note, is that Ripple is a U.S. based company. From the xrphodor blog:
Ripple is a US-based company.
Why is this an important point to consider? A US-based company like Ripple is subject to some very stringent laws regarding securities trading and money transmission. These include requirements that define how Ripple might interact with crypto markets and both institutional and retail crypto traders.

One-Year Simulation

1-Year Simulation of Ripple Prices and Returns

One-Year Simulated 1,000 Times

1-Year Ripple Prices Simulated 1,000 times

Verdict

We can be 95% certain that Ripple prices will fall between $0.05, and $163 with a median of $2.71.

MONERO

What is Monero?

Monero attempts to solve privacy and fungibility issues that persist in Bitcoin.
Part of the algorithm for Monero automatically mixes transactions with previous transactions and does this by implementing ring signatures.

One-Year Simulation

1-Year Simulation of Monero Prices and Returns

One-Year Simulated 1,000 Times

1-Year Monero Prices Simulated 1,000 times

Verdict

We can be 95% certain that Monero prices will fall between $68, and $8,142 with a median of $760.

Zcash

What is Zcash?

From the Blockchainhub infographic:
Zcash is a permissionless cryptocurrency that can fully protect the privacy of transactions using zero-knowledge cryptography.

One-Year Simulation

1-Year Simulation of ZCash Prices and Returns

One-Year Simulated 1,000 Times

1-Year ZCash Prices Simulated 1,000 times

Verdict

We can be 95% certain that Zcash prices will fall between $54, and $6,259 with a median of $549.

YOUR VERY OWN FORECASTING TOOL

Since i’m so nice, I went ahead and created a forecasting tool for you to use:
https://docs.google.com/spreadsheets/d/1eUIgBowJs2NyKw7kYbx5z_VeCOxsMQdNELfbngs4XnY/copy

SERVICES USED:

  1. Google Sheets
  2. Spreadstreet Google Sheets Add-in
  3. StockTwits
  4. CoinMarketCap API
Full disclosure: The google sheets add-in is a 14-day free trial, and $15 per month after. However, no one should be refused access on the basis of money (especially true for students and less fortunate). Send me a message, and I will make sure you are not left in the dark.

A NOTE ON SECURITY

Users have expressed hesitation about running a google sheets add-in on their main computer, so I will attempt to ease those concerns:

WHAT IT PULLS:

GETTING THE SPREADSHEET TO WORK FOR YOU

Install the Spreadstreet add-in for Google Sheets
Get sheet ready for use with the add-in
After logging into the add-in, change the dropdown reference

TROUBLESHOOTING

  1. Important Open the template, click the menu Add-ons / Spreadstreet / Help / View in store, and then click Manage and in the dropdown menu click “Use in this document.”
  2. A reload of the entire worksheet fixes quite a few problems.
  3. Deleting and re-pasting the formula in A1 of the “Candles” tab fixes things as well.
  4. If all else fails, drop me a message
  5. The “SELECT CURRENCY” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
When I try and change a coin, I get a #DIV/0 error
Login to the Spreadstreet add-in, and keep the window open. Try changing the dropdown again.
I have tried logging in, activating the template with “Use in this document” and refreshed the sheet…still nothing.
Head to the “Data” tab. Delete the formula in cell A1, and repaste the following: =SS(“candles-bitfinex”, ticker, “1D”, “hist”, true, “”, “”, “”, “0”)

CONCLUSION

Whether you are investing in Bitcoin, Ethereum, or SpankCoin, it is imperative to have a plan. Most notably, a worst-case scenario.
The Monte Carlo simulation is a fantastic way to get a range of prices for a cryptocurrency. And after reading this, you can see how the final values change drastically depending on what you are looking at.
I urge you to download the sheet and try your own hand at simulating different coins. The sheet is setup to pull in every single coin from CoinMarketCap.
Cheers, and happy hunting
Original article can be found here: https://medium.com/@spreadstreet/10-statistical-price-predictions-for-10-cryptocurrencies-january-2018-3dcf04bf9d9a

RELATED POSTS

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain
A Super Simple Cryptocurrency Arbitrage Spreadsheet for Finding Mismatched Prices
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets
7 Smart Ethereum Price Prediction Methods for HODL’ers
submitted by 1kexperimentdotcom to CryptoCurrency [link] [comments]

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain

TL;DR: I created a spreadsheet that automates pulling trending cryptocurrencies, recent tweets, and bullish/bearish sentiment into Google Sheets. You can find it here:
https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
I know some crypto users prefer to work in spreadsheets (including myself) so I created a spreadsheet that looks at trending symbols and estimates bullish/bearish sentiment. I never had the time to develop software engineering skills, but the recent launch of a few add-ins has allowed regular joes like myself to harness the power of APIs.

The Beauty of Sentiment Trading

According to Google Trends, the word “sentiment analysis” has been gaining steady traction over the past 5 years.
Sentiment refers to the attitude expressed by an individual regarding a certain topic. This is especially relevant in trading, where so much of the change in price is dictated by emotions:
When it is applied to trading, sentiment can be used (with great potential windfall) as a directional signal to figure out whether you should enter a crypto position within your portfolio.
A way you can utilize sentiment when trading crypto, is to measure the positivity or negativity of a tweet. If recent tweets have been overwhelmingly bullish (aka, the person expects the crypto rise) and movement is beginning to happen in the currency, chances are good that the trend will continue.
Luckily for you, StockTwits already does this with around 225 different cryptocurrencies. And if you can combine the sentiment with trending cryptocurrencies, you can catch the wave right as it forms.

Services Used:

  1. Google Sheets
  2. Spreadstreet Google Sheets Add-in
  3. StockTwits
  4. CoinMarketCap API
Full disclosure: The google sheets add-in is a 14-day free trial, and $15 per month after. However, no one should be refused access on the basis of money (especially true for students and less fortunate). Send me a message, and I will make sure you are not left in the dark.

A note on security

Users have expressed hesitation about running a google sheets add-in on their main computer, so I will attempt to ease those concerns:

What it pulls:

AN OVERVIEW OF THE SECTIONS

The Dashboard
Changing the timeframe
Changing the cryptocurrency
Instructions Tab
Summary Tab

How to use the spreadsheet to spot trending cryptocurrencies

You will spend most of your time in the “Analysis” tab, where the trending cryptocurrencies reside.
I am almost always looking at the “By Hour” timeframe, as the “By Day” and “By Week” is usually a missed opportunity…however, those time frames can still be very useful (albeit, for different reasons).
You want to ride the wave on a cryptocurrency under one or both of the following conditions:
  1. The tweets are very recent, preferably within the last hour
  2. Overwhelmingly Bullish sentiment
A Great Example
A Bad Example

Getting the spreadsheet to work for you

1. Install the Spreadstreet add-in for Google Sheets
2. Get sheet ready for use with the add-in
3. After logging into the add-in, refresh the sheet

Troubleshooting

  1. Important Open the template, click the menu Add-ons / Spreadstreet / Help / View in store, and then click Manage and in the dropdown menu click “Use in this document.”
  2. A reload of the entire worksheet fixes quite a few problems.
  3. Deleting and re-pasting the formula in A1 of the “Data” tab fixes things as well.
  4. If all else fails, drop a line to [email protected]. He will get you running in no time.
  5. The “TIMEFRAME” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
Some trending coins are not pulling correctly…what’s going on?
StockTwits has a list of ~225 coins it currently supports. See the “TweetInfo” tab for the full list.
I have tried logging in, activating the template with “Use in this document” and refreshed the sheet…still nothing.
Head to the “Data” tab. Delete the formula in cell A1, and repaste the following: =SS(“tickers-coinmarketcap”, headers, “0”, Currency)
Hoping this is something that is useful to everyone, and I am more than happy to help peeps setup the sheet so they can use it. Just send me a message on here.
Original Medium article can be found here: https://medium.com/@spreadstreet/financial-modeling-for-cryptocurrencies-the-spreadsheet-that-got-me-my-first-1-000-gain-f4d0d1a6e5ed

RESOURCES

Download the spreadsheet: https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
Download the add-in: https://spreadstreet.io/tools/google-sheets-add-in
Help: https://spreadstreet.io/docs
First time install and login: https://www.youtube.com/watch?v=aLjtPR4T2bg
Bitfinex Candles endpoint help: https://spreadstreet.io/knowledge-base/bitfinex-api-candles-endpoint/

RELATED POSTS

Top 12 Cryptocurrencies Ranked by Risk-Adjusted Return
10 Statistical Price Predictions for 10 Cryptocurrencies
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets

ABOUT THE AUTHOR

John Young is the founder of Spreadstreet.io, former Financial Analyst for a big-ass company, and runner-up in the 6th grade spelling bee. He would have invested in Google if he knew about it...and had any money.
He is the author of the Spreadstreet blog, which has over 3 readers (not a typo). He hopes to hit 10, but honestly writing is a lot of work.
submitted by 1kexperimentdotcom to ethtrader [link] [comments]

CRYPTOSHEET the cryptocurrency portfolio spreadsheet Trade using excel with real time data Cryptocurrency Portfolio Template Tutorial Cryptocurrencies: Spreadsheet For Tracking Profit & Loss ... ULTIMATE ALTCOIN DAYTRADERS SPREADSHEET Demo :) (1of3)

This spreadsheet has been made to help you keep track and make sense of where you are based on what you've bought and sold on different platforms. How to use: 1. Make a copy of the spreadsheet (file -> make a copy) 2. Modify if you'd like to add a new cryptocurrency or add another indicator. (optional) 3. The Trading Journal Spreadsheet began in 2005 as a way to track my own personal trading progress.By early 2007, I had shared what I created with a handful of other trading cohorts. They all loved it, and more importantly, they benefited from the analysis it provided, and were adamant that it should be available to other aspiring traders. This spreadsheet will enable you to track returns on your Cryptocurrency investments. ... template excel bitcoin ethereum cryptocurrency tracker. 1,588 Discuss add_shopping_cart. free ... This is easy-to-use handy Google sheet for calculating the gains in bitcoin and other crypto trading using LIFO method. Monthly Crypto Trading Spreadsheet Template – Courtesy of Young & Investing. Cryptopay Ltd is a company registered in England and Wales (company number: 08730592) whose registered office is at the Wework Building, 12 Hammersmith Grove, London W6 7AP, UK. We provide tools to help you analyze crypto markets and find data-driven opportunities to ... 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.

[index] [112] [850] [807] [558] [689] [133] [890] [8] [11] [330]

CRYPTOSHEET the cryptocurrency portfolio spreadsheet

How to Create Crypto portfolio using Power Query in Excel (pull ... 5:03. Str82ThePoint 7,576 views. 5:03. Trading Journal - My Excel Spreadsheet Trading Journal (+ Free Trading Journal ... Excel Crypto Spreadsheet (Free Download) - Imports Current Price of Each Coin from the Web ... My Excel Spreadsheet Trading Journal (+ Free Trading Journal Spreadsheet!) - Duration: 6:33 ... Learn about our new offering in API trading. Use excel to monitor feeds, order, and positions in real time. Also, build your own strategies in excel using real-time data. Open Upstox account ... https://CryptoInvestingInsider.com Click to get our free course and see how to make high returns in the cryptocurrency space. https://CryptoInvestingInsider.... This video is unavailable. Watch Queue Queue. Watch Queue Queue

#