For Trading January 29th CORONA VIRUS CRUSH Is it over? MMM, PFE, XLNX, & EBAY MISS AAPL BEATS Join Us Every Day, Link Below Today’s market started off higher from the start and built until we had made up a bit over half of yesterday’s loss and hit +289 before coming back to close +187.05 (.66%), NASDAQ +130.37 (1.43%), S&P 500 +32.61 (1.01%), the Russell +14.18 (.86%) and the DJ Transports + 64.51 (.60%). Honestly, I’m far from impressed. Coronavirus is not over, and there are going to be some major supply-chain disruptions. Like SPR, a supplier for BA is down from $92 to $68, there will be plenty of small to intermediate sized businesses that will fail. Market internals were “okay” with A/D 2.3:1 on NYSE and 2.2:1 on the NAZ. The DJIA was 5:1 UP and the biggest winner AAPL +60 and MMM -68 DPs. The Consumer confidence number was a surprise was 131.6 vs. consensus 128. Strong sectors included Info Tech, Financials and Communication Services and Consumer staples was weak. Our “open forum” on Discord, which allows me to interact with subscribers and others to allow direct questions and chart opinions on just about any stock, continues to grow with more participants every day. It is informative and allows me to share insights as the market is open and moving. The link is: https://discord.gg/ATvC7YZ and I will be there and active from before the open and all day. It’s a great place to share ideas and gain some insights. SECTORS: Other names in the news: MMM was the biggest drain on the DJIA with an earnings miss and the stock was down from yesterday’s high of $180.59 to open $172 and continue to fall to $165.05 and closing $165.58 -10.05 (5.72%). Besides the numbers, this is a company that also has a major issue with the dumping of chemicals (PFOA and PFOS) in several rivers including the Tennessee and Mississippi, and even the partial settlements have been a multiple of the money “set aside” for that purpose. PFE was just under $41 on Friday and missed and the stock opened $39.32, traded up to $39.49 and then fell to $37.95 and finished $38.14 -2.02 (5.03%). Apple (AAPL) beat both top and bottom and after closing $317.69 +8.74 (2.83%) and then traded to a new all-time high of $327.90and is currently $322.29 another 2.2%. Starbucks (SBUX) reported and while the numbers were ok, I think that they didn’t address the Coronavirus to my satisfaction. I have always prided myself on the fact that I have a very common mentality, and if it didn’t satisfy me, others will feel the same. The stock moved higher to $91.58 but quickly fell back to finish extended hours at $87.05. I think tomorrow will be worse after that fool Cramer has the CEO on CNBC. I’m guessing that $85 is in the cards. And, the DISASTER DU JOUR today was a name you’ve seen here several times in the past week, Nanoviricides (NNVC) that moved from $3.31 to $17.77, and today most of that was reversed and it fell back to $7.82 before closing $8.40 – 7.40 (46.84%). BIOPHARMA: was HIGHER with BIIB +1.37, ABBV -.25, REGN +4.66, ISRG +2.23, MYL +.68, TEVA +.12, VRTX +4.60, BHC +.94, INCY +.39, ICPT +1.57, LABU +2.69 and IBB $117.43 +1.34 (1.15%). CANNABIS: stocks were HIGHER with CGC + 2.44 (11.32%) and CRON +.44 (6.07%) and the rest of the group generally +2.5%). MJ $17.29 +.44 (2.61%). DEFENSE: was HIGHER with no major moves except TDY +10.12 (2,73% and ITA $231.93 +1.88 (.82%) and ITA $228.88 -2.90 (1.25%). RETAIL was HIGHER with the market and M +.45, JWN +.23, KSS +.40, DDS -.09, JCP +.017, WMT +.89, TGT -.56, TJX +.37, RL -.30, UAA +.24, LULU +2.61, TPR +.16, CPRI -.70 and XRT $44.72 +.25 (.56%). FAANG and Big Cap: were HIGHER with GOOGL +18.77, AMZN +25.66, AAPL (see above), FB +3.68, NFLX +4.82, NVDA +5.12, TSLA +13.48, BABA +3.43, BIDU -.07, IBM +.98, BA -2.25, CAT +1.22, and XLK 96.93 +1.82 (1.91%). FINANCIALS were HIGHER with GS +3.86, JPM +2.27, BAC +.40, MS +.89, C +.53, PNC +1.16, AIG +.28, TRV+ .66, AXP +1.81 and XLF $30.27 +.35 (1.17%). OIL, $53.98 +.74. Today’s action was a continued stabilization and a small bounce away from the support at $52.75. The $52.00 area was support and we’ll have to see if it holds in the next few days. The stocks were HIGHER with the market and XLE $55.30 +.25 (.45%). METALS, GOLD: $1,569.80 -7.60 after breaking out “of the box” earlier last week, and the Iran news, we traded as high as $1,613 before turning down. I bought the GLD calls after we traded down to my area of support around $1,545 and after the small consolidation started higher. We ran into some excessive supply at $1,588 and turning back today. We bought the GLD 2/149 calls @ $1.10 and they closed $1.18 today. BITCOIN: closed $9,060 +70. We broke to the upside today and managed a close on the highs. Yesterday I said, “I now expect a test of $9,200 to $9,500”. Tonight we are trading $9,390. We own 750 GBTC with an average of $8.89. GBTC closed $10.12 +.30 today. Tomorrow is another day. CAM
Hello and welcome to Post Pull Depression, the only thread that knows best Garnet is not long haired or short haired Garnet, but the Garnet that can’t talk. Hey, it’s the two month delayed FF9 banner! Miracles can happen! That guy who does the banner guessing posts should be fired! At least that gave me plenty of time to replay FF9 since my reviews are the singular voice of this sub and you need to know what I think so you can think the same! Too bad I initially didn’t make it too far since it plays in 30 FPS. It only took about five minutes before I was profusely vomiting from 30 FPS sickness. Totally unplayable on PC, so I booted it up on the PS1 and since it doesn’t display FPS in the bottom left corner everything was fine! I was able to complete my 4th or 5th(?) playthrough! FF9 is one of the few games that’s actually better played when you’re an adult. The themes of mortality, purpose in life, the amazing bond between Zidane and Vivi are all lost on bratty, angsty teenagers. Plus, there’s a peeing scene! What more can you ask for? Go replay it! Now, before this gets delayed another 2 months, let’s take a look at the units!
Black Mage: Steroids The Black Waltz are the early game bad guys who are sent to re-kidnap Garnet.
”I exist only to kill!”
Yeah, that’s the guy we should send to get the princess back. I see no problems here!
”I brought her back… in pieces…”
Presents Garnet’s severed head to Queen Brahm Thus ends my FF9 guro fanfic. (Note: do not google image search guro at work, or at home, or anywhere really…) Mist: LoL
Mist - Inflict poison and paralyze (100%) to all enemies
And we all know that the best PS1 rpg with mist is… Legend of Legaia! That game had fantastic fishing in it. We need a Legend of Legaia crossover! And a Legend of the River King one too! You all got your doggo, let me have a 5* river king flopping around Magikarp style. It’s been awhile since I’ve done a list, here’s the best JRPG fishing:
Legend of Legaia
Breath of Fire 3/4
Dark Cloud 2
I just heard that Stardew Valley has good fishing. IS THIS TRUE!? I’ve never felt like playing “knockoff” Harvest Moon, but if the fishing is great, then I’ll do it. Also, I’m looking for a good cell phone fishing game (already tried A Girl Adrift) tell me if you know one. Also, tell me how I went from Black Waltz 3 to fishing, stream of consciousness is a crazy thing. TMR: MEH
Black Impulse: +20% MAG & +25% Fire/Ice/Thunder Resist
For when your magic tank also needs to do magic damage! Let me do a little cross-referencing here… [units that benefit from MAG] intersect [units that benefit from element resist] = . Oh, shoot it’s that damn empty set again...
Regret: VERY HIGH
A five star max unit is a slap in the face at this point in the game… is what I want to say. But let’s be real here… if Bee Dubs 3 could go to 6* would anyone use him? No. So let’s just pretend he’s a 3* max unit because no one will level him anyways to find out.
Comic: Relief Every game needs its comic relief character! Oh wait that’s Quina… what the hell does Steiner do then? Or does that mean Quina is not a comic relief character? Maybe s/he is the entire point of FF9? THIS CHANGES EVERYTHING! Steiner > Beatrix
When he was 23, he dueled with Alexandria's best swordsman, Beatrix, and won due to sheer luck.
Wow! I did not know that! Be grateful those of you who don’t pull Beatrix but get Steiner instead! Lucky you! Skills: One Oh! He has multiple skills that start with “Sword Art!”
Sword Art - Thunder Sword Physical damage (3x) to one enemy Decrease lightning resistance (50%) for 3 turns to one enemy Sword Art - Stock Break Physical damage (2x) to all enemies Decrease DEF/SPR (40%) for 3 turns to all enemies Sword Art - Shock Physical damage (2x) with ignore DEF (50%) to one enemy
Sweet! So I’m sure he learns W-Sword Art, right? Right? WRONG! Way to set the standard and then not follow it... TMR: 12 HRS
Excalibur II - 130 ATK Light Element Greatsword
Excalibur TWO? This needs some ‘splaining! Oshiete TomAto-sensei! Excalibur II is obtained by reaching the final dungeon of the game within 12 hrs! That’s right, you have to go all the way through the game super quick, oh and FMV times count which is closer to a full hour than not! FF9 Excalibur I Stats:
It provides 77 Attack, its element is Holy, and teaches Climhazzard.
FF9 Excalibur II Stats:
It has an attack power of 108, its element is Holy, and teaches Minus Strike, Climhazzard, and Stock Break.
Totally worth ruining your entire playthrough for! LB: Vivi
Flare Sword - Physical damage (4.7x) with ignore DEF (50%) to one enemy
I already posted this in Lowered Expectations aka Pre-Pull Depression, but here’s Steiner summoning Vivi in his LB. Figured I’d post it for you since no one will actually put Rusty in their party. Regret: HIGH Fuck you Beer Steiner for making me pull for you just to get 10 more ATK on my Orlandu. The only thing that could get me to lower this is if you had fantastic Yoshitaka Amano artwork, but I don’t see something that specific ever happen-- oh… ok that’s pretty badass. Fine. MEDIUM.
Loli: S Finally this game is playable now that we have BS Sakura and Eiko. Soon Kid Rydia soon… We all know why Kid Rydia is more powerful than Adult Rydia. The Power of Loli! Please read that like the Power of Greyskull. Also, I’m counting this as my 80’s song for this PPD. Also, I will probably reuse this joke when I do the actual PPD for Kid Rydia’s banner. Skills: Bit
Crypto Performance - Heal (1000 HP, 10x) to all allies Increase evocation gauge (1-3)
Really, cryptocurrency has to appear here too? What next? A special 5* guaranteed bitcoin summon? TMR: Flute
Angel Flute - Harp 10 ATK, 48 MAG, 98 SPR, HP +10%
Summoner's Horn - Can summon Espers equipped by other allies
This horny little girl… goddammit I said stop that! She literally has a horn! Anyways, this girl WITH A HORN can summon any party member’s esper. Freeing up Bahamut for your damage dealers, or Carbuncle reflect shenanigans etc. Why goomie also gave this to 6* Garnet the day before they released Eiko is beyond me, but thank you!
Her 7* form pushes her more toward healing: AoE revive, HP Barriers and AoE MP regen. Combined with her previous kit that makes her an extremely viable healer. Sadly no reraise though. Oh and she’s a loli, so that pretty much gets her an automatic LOW at worst.
Earth Shrine: Hero Finally we get a unit that’s custom made for the Earth Shrine! Is there any other character in FF history with more rat killing experience? #Burmecia #WarCriminal Eye: Patch Is Beatrix the one who started the whole girls with eyepatches thing? I am a man of many fetishes, but I have never gotten this one. I sorta get the bandaged girl thing which occasionally overlaps with eyepatches (Rei Ayanami) and the whole forbidden power eyepatch (Megumin aka best girl), but just straight up eyepatch? No thanks. Seiken: Densetsu?
Seiken - Shock: Physical damage (2.65x) with ignore DEF (50%) to one enemy
I just saw Seiken! SEIKEN! Are we getting the Seiken Densetsu 3 collab? No? Don’t tell me seiken is just some super common anime term that means holy sword or something… oh it does… sigh… well at least unlike Rusty she can W-Seiken, right? Right? WRONG AGAIN! As long as DW doesn’t screw up her chaining I guess she’s… oh shit it does, doesn’t it? Hey goomie, if you fix her chaining in GL on her release, guess what? People will pull for her! It’s in all our best interests if you don’t release broken units! TMR: SAD!
Save the Queen - Greatsword +135 ATK, +25% LB Fill Rate, Resist Fire(30%)
Save the Queen, huh? How’d that work out for you Bea? I guess you and Agrias can go hang out with your failed swords. Maybe start a club? The “I Let My Queen Die And Now Have a Misnamed Sword” Club? We can work on the name...
Regret: MEDIUM (eventually LOW)
If it makes you Beatrix lovers feel better (weirdos) eventually Beatrix becomes great. Her enhancements fix her wonky chaining and her 7* form adds a ridiculous 4200% hybrid attack. Until then though just listen to this fantastic rendition of her theme. I think I may be allergic to this song as it makes my eyes water. Very weird how allergies work.
Post Pull Depression
Did I mention that FF9 is a very good game? Definitely grab the Steam port (unlike CT) and make sure to turn off the FPS counter (so you don’t get ill). I recommend playing with the boosters that max out your abilities as soon as you get the weapon for it (this gives you all Blue Magic immediately though…) and max out your gil too! Also, when you get sick of fighting just turn off random encounters! Oh, and when you’re close enough to the end just set all your character to level 99 and breeze right through it! I don’t know what impact this would have on a first playthrough, but it’s a godsend for the working man who has a stack of games to get through! Just be sure not to play too long or you’ll get cancer! Don’t forget to check out ET’s full banner review here. Whoops wrong link, but too funny to change it. Here is the correct one. He dropped the letter ranking so now I have to read what he actually wrote before I go tell him how wrong he is in the comments. I don’t approve of this change… Hey Meme’s still posting on reddit too! Here’s his Eiko review. Most people give up by now! How long will he last? And in the eleventh hour the Beatrix review gets posted, so that too now gets the PPD bump. And now I’ll leave-- You stand before the final dimension, and I am the darkness of eternity… Huh? Oh shit, is that you Necron? What are you doing here? All life bears death from birth. Life fears death, but lives only to die. It starts with anxiety. Anxiety becomes fear. Fear leads to anger... anger leads to hate... hate leads to suffering... The only cure for this fear is total destruction. Ok, first you can’t just randomly pop up at the end of things. Second, you stole part of that from Yoda. ...Now, the theory is undeniable. All things live to perish. At last, life has uncovered this truth. Now, it is time to end this world. Yeah.. have you tried posting on im14andthisisdeep? I exist for one purpose... To return everything back to the zero world, where there is no life and no crystal to give life. In a world of nothing, fear does not exist. This is the world that all life desires. Yeah, yeah, whatever. See ya next banner!
Indonesia's military chief believes the fuselage of the crashed Lion Air plane has been found. The aircraft carrying 189 people, including crew, from Jakarta crashed into the sea off the island of Java on Monday, shortly after take-off. (Reuters)
One of the Alphabet (GOOGL) executives accused of sexual misconduct in a bombshell New York Times' report resigned on Tuesday. Richard DeVaul, a director at Alphabet's research lab X, left without an exit package, CNBC confirmed. Axios first reported the news.
Robert Mueller, special counsel investigating Russia influence on the 2016 election, has referred to the FBI allegations that women were "offered money" to make "false claims" about him. A conservative commentator tweeted about revealing a "victim" tomorrow. (CNBC)
Kanye West said he's "distancing" himself from politics. The controversial rapper, who has become one of Trump's highest-profile celebrity supporters, tweeted: "My eyes are now wide open and now realize I've been used to spread messages I don't believe in." (USA Today)
American automaker Ford (F) and Chinese internet giant Baidu (BIDU) announced a tie-up today that will see the two firms jointly test self-driving vehicles in China for two years. Autonomous vehicles developed by the two will not require intervention from a human driver. (CNBC)
CVS (CVS) is piloting a membership program called CarePass, which includes free delivery on most prescriptions and online purchases, among other perks. At $48 annually or $5 monthly, the program is less than half the price of an Amazon (AMZN) Prime membership. (CNBC)
Bitcoin celebrates its 10th birthday today. The world's first cryptocurrency spawned a multitude of others, brought blockchain technology to global attention, and vexed regulators worried about its misuse. Bitcoin prices have fluctuated wildly. (Reuters)
General Motors – The automaker reported adjusted quarterly profit of $1.87 per share, well above the consensus estimate of $1.25 a share. Revenue also beat forecasts, and GM expects to hit the top end of its projected earnings outlook for the full year. GM's results were helped by higher prices in North America.
Anthem – The health insurer earned an adjusted $3.81 per share for the third quarter, 11 cents a share above estimates. Revenue also cam in above forecasts and Anthem increased its full-year forecast amid a rise in medical enrollment and favorable medical cost trends.
Clorox – The household products maker earned $1.62 per share for its latest quarter, 4 cents a share above estimates. Revenue also topped forecasts, however Clorox lowered its full-year outlook, citing cost pressures and unfavorable currency trends.
Estee Lauder – Estee Lauder beat estimates by 19 cents a share, with quarterly profit of $1.41 per share. Revenue also came in above Street projections. The cosmetics maker saw stronger demand for its luxury skincare products, and also raised its quarterly dividend to 43 cents per share from 38 cents.
Garmin – The maker of GPS products earned an adjusted $1 per share for its latest quarter, beating the 76 cents a share consensus estimate. Revenue also beat expectations and Garmin raised its full-year earnings forecast amid sales growth across all its product segments.
Yum Brands – The parent of KFC, Taco Bell, and Pizza Hut beat estimates by 21 cents a share, with adjusted quarterly profit of $1.04 per share. Revenue also came in above estimates. Pizza Hut sales fell, but KFC and Taco Bell saw better-than-expected same-store sales growth.
Facebook – Facebook reported quarterly profit of $1.76 per share, beating consensus estimates by 29 cents a share. Revenue came in slightly below forecasts, as did its user growth, but Facebook also showed better-than-expected expense control in its latest quarterly numbers.
Electronic Arts – Electronic Arts earned 83 cents per share for its fiscal second quarter, well above the consensus estimate of 58 cents per share. The video game publisher's revenue also came in above forecasts, however the shares are being pressured by weaker-than-expected guidance for net bookings — a metric combining physical and digital sales.
T-Mobile US – T-Mobile beat estimates by 8 cents a share, with quarterly profit of 93 cents per share. The mobile service provider's revenue also came in above forecasts. T-Mobile's results were driven by the addition of 774,000 postpaid phone customers during the quarter.
Amgen – Amgen reported adjusted quarterly earnings of $3.69 per share, 24 cents a share above Street forecasts. The biotech firm saw revenue beat estimates as well, and it also raised its full-year guidance. However, Amgen is also seeing lower-than-expected sales of drugs like cholesterol treatment Repatha because of price concessions.
MGM Resorts – MGM came in 5 cents a share ahead of estimates, with adjusted quarterly profit of 24 cents per share. Revenue also came in above forecasts and the casino operator saw better-than-expected revenue in Las Vegas, but its China revenue did not meet forecasts.
Yum China – Yum China reported quarterly earnings of 51 cents per share, 6 cents a share above estimates. The restaurant operator's revenue missed forecasts, however, as comparable-store sales fell by one percent compared to a year earlier. Yum China also announced a 2 cent a share dividend increase to 12 cents per share, and also increased its stock buyback plan.
Cheesecake Factory – Cheesecake Factory beat estimates by 4 cents a share, reporting adjusted quarterly profit of 62 cents per share. The restaurant chain's revenue came in below Street forecasts, however, as comparable-restaurant sales increased by a lower than expected 1.5 percent.
EBay – EBay reported adjusted quarterly profit of 56 cents per share, 2 cents a share above estimates. The online marketplace operator's revenue was in line with forecasts. EBay saw a 5 percent increase in gross merchandise volume, and a 7 percent revenue jump at its StubHub ticket selling unit.
FireEye – FireEye earned an adjusted 6 cents per share for its latest quarter, tripling the consensus estimate of 2 cents a share. The cybersecurity company reported better-than-expected revenue as well, as it signed up more subscribers.
Baidu – Baidu issued a lower-than-expected sales forecast for the remainder of the year, with the China-based search engine operator citing uncertainty over the economy, trade issues, and tougher regulations.
Arconic – Arconic is in advanced talks to be bought by private-equity firm Apollo Global, according to sources quoted by Reuters. The reported price for the aluminum products maker would be more than $11 billion.
bigbear0083 has no positions in any stocks mentioned. Reddit, moderators, and the author do not advise making investment decisions based on discussion in these posts. Analysis is not subject to validation and users take action at their own risk. bigbear0083 is an admin at the financial forums Stockaholics.net where this content was originally posted.
What is on everyone's radar for today's trading day ahead here at StockMarket?
I hope you all have an excellent trading day ahead today on this Wednesday, October 31st, 2018! :)
Tron v7.1.1 (2015-11-12) // Definitions and subtools refresh
NOTE: IF you're coming here from a google search or reddit link, this version of Tron is significantly out of date. Get the latest version at /TronScript
Tron is a script that "fights for the User"; basically a glorified batch file that automates a bunch of scanning/disinfection/cleanup tools on a Windows system. I got tired of running everything manually and decided to just script the whole thing. The goal is to automate ~85-90% of the tasks a technician would usually perform. I hope this helps other techs and admins. Tron supports all versions of Windows from XP to Windows 10.
Quaternary method: Source code All the code for Tron is available here on Github (Note: this doesn't include many of the utilities Tron relies on to function). If you want to see the code without downloading a big package, or want to contribute to the project, the Git page is a good place to do it.
Tron has full command-line support. All flags are optional, can be combined, and override their respective script default when used.
Usage: tron.bat [-a -c -d -dev -e -er -m -o -p -r -sa -sb -sd -se -sfr -sk -sm -sp -spr -srr -ss -str -sw -v -x] | [-h] Optional flags (can be combined): -a Automatic mode (no welcome screen or prompts; implies -e) -c Config dump (display current config. Can be used with other flags to see what WOULD happen, but script will never execute if this flag is used) -d Dry run (run through script without executing any jobs) -dev Override OS detection (allow running on unsupported Windows versions) -e Accept EULA (suppress display of disclaimer warning screen) -er Email a report when finished. Requires you to configure SwithMailSettings.xml -m Preserve OEM Metro apps (don't remove them) -np Skip the pause at the end of the script -o Power off after running (overrides -r) -p Preserve power settings (don't reset power settings to default) -r Reboot automatically (auto-reboot 30 seconds after completion) -sa Skip anti-virus scans (MBAM, KVRT, Sophos) -sb Skip de-bloat (OEM bloatware removal; implies -m) -sd Skip defrag (force Tron to ALWAYS skip Stage 5 defrag) -se Skip Event Log clearing -sfr Skip filesystem permissions reset (saves time if you're in a hurry) -sk Skip Kaspersky Virus Rescue Tool (KVRT) scan -sm Skip Malwarebytes Anti-Malware (MBAM) installation -sp Skip patches (do not patch 7-Zip, Java Runtime, Adobe Flash or Reader) -spr Skip page file settings reset (don't set to "Let Windows manage the page file") -srr Skip registry permissions reset (saves time if you're in a hurry) -ss Skip Sophos Anti-Virus (SAV) scan -str Skip Telemetry Removal (don't remove Windows user tracking, Win7 and up only) -sw Skip Windows Updates (do not attempt to run Windows Update) -v Verbose. Show as much output as possible. NOTE: Significantly slower! -x Self-destruct. Tron deletes itself after running and leaves logs intact Misc flags (must be used alone): -h Display this help text
\tron\integrity_verification\checksums.txt contains SHA-256 checksums for every file and is signed with my PGP key (0x07d1490f82a211a2; pubkey included). You can use this to verify package integrity. Please suggest modifications and fixes; community input is helpful and appreciated. Donations (bitcoin): 1LSJ9qDzuHyRx6FfbUmHVSii4sLU3sx2TF QuietProfessionals
12-17 19:22 - 'Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain' (self.Bitcoin) by /u/1kexperimentdotcom removed from /r/Bitcoin within 125-135min
''' 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: [[link]20 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]2 , 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.
[Spreadstreet Google Sheets Add-in]3
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:
I am located in the U.S., and my business is registered in the state of Maryland
If this were malicious, people would have downvoted the add-in into oblivion, and it would have been removed from the store
If you are still worried, you can open it within a virtual machine and test it first
Here is my LinkedIn. Come say hi. My reputation is very important to me. [link]21
What it pulls:
Trending Symbols (30 at a time)
Historical Price Data
Bullish/Bearish Sentiment of recent tweets
AN OVERVIEW OF THE SECTIONS
[The Dashboard]4 [Changing the timeframe]5 [Changing the cryptocurrency]6 [Instructions Tab]7 [Summary Tab]8
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:
The tweets are very recent, preferably within the last hour
Overwhelmingly Bullish sentiment
[A Great Example]9 [A Bad Example]10
Getting the spreadsheet to work for you
1. Install the Spreadstreet add-in for Google Sheets
[Click this link to download the Spreadstreet Google Sheets Add-in]11
Follow the installation instructions included with the add-in and log-in
2. Get sheet ready for use with the add-in
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.
Numbers in row 26 and below should populate. If they do not, refresh the sheet
3. After logging into the add-in, refresh the sheet
In the analysis tab, change the “TIMEFRAME” dropdown to one of the other choices…this refreshes the pull
Note: CoinMarketCap API has limits. Be careful when attempting to refresh the sheet too many times
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.”
A reload of the entire worksheet fixes quite a few problems.
Deleting and re-pasting the formula in A1 of the “Data” tab fixes things as well.
If all else fails, drop a line to [email protected]. He will get you running in no time.
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: [link]22
Download the spreadsheet: [[link]20 Download the add-in: [[link]24 Help: [[link]25 First time install and login: [[link]26 Bitfinex Candles endpoint help: [[link]27
[Top 12 Cryptocurrencies Ranked by Risk-Adjusted Return]17 [10 Statistical Price Predictions for 10 Cryptocurrencies]18 [Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets]19
Bitcoin ist ein mit viel Energie ausgestatteter Rappe aus dem Stutenstamm der Schliesserin, einem der bedeutendsten der hannoverschen Pferdezucht. Beeindruckend ist seine Einstellung, er ist ein moderner Hengst mit viel Leistungsbereitschaft, der immer eine Aufgabe haben möchte. Sein hohes Maß an Rittigkeit und der bedeutende Ablauf in allen drei Grundgangarten machen ihn zu einem ... Search the world's information, including webpages, images, videos and more. Google has many special features to help you find exactly what you're looking for. SpreadCoin (SPR) is a cryptocurrency . Users are able to generate SPR through the process of mining. SpreadCoin has a current supply of 11,159,260.35458148. The last known price of SpreadCoin is 0.00195485 USD and is down -0.34 over the last 24 hours. It is currently trading on 1 active market(s) with $0.00 traded over the last 24 hours. Spreadcoin (SPR) price based on hundreds of cryptocurrency exchanges. Charts, ranks, volume, ROI, ATH, EMA & other analytics - everything you may need. Watchlist, alerts & price levels predictions - use or lose. Market Info. Total Cap 325B-6.33B (1.91%) 24h Volume 38.7B + 10.9B (39.27%) BVI 129.43 + 5.23 (4.21%) BITEX 90.23-1.88 (2.04%) BTC dominance 63.1%. Bitgur news Now you can follow us on ... 1 Bitcoin to SpreadCoin Price for today is 14282964.58840442 SPR. Bitcoin SpreadCoin price details will give you the exact conversion rate, which is equivalent to 1 BTC = 14282964.58840442 SPR as of now. Here you can check the highest conversion rate from 1 Bitcoin SpreadCoin in the last 24 hours, that has been recorded at 1360289.65280659 SPR and the lowest has been recorded at 2138471 ...
We aim to accelerate the world’s transition to blockchain and cryptocurrency. Crypto 10X is your one-stop-show for all things bitcoin and altcoins, including... Gaming and bitcoin were made for each other. Score 50 points playing fly chris fly on android and you'll get $0.50 in bitcoin via https://Gamerholic.com, available soon on ios. Download game here ... Free Bitcoin Only WiFi BITCOIN PRICE , BITCOIN FUTURE in doubt http://youtu.be/eO-yrpQpIT8 What is NAMECOIN BITCOIN'S First Fork http://youtu.be/oBkhPhu3_B4 ... Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. Nachdem der Bitcoin die Marke bei 10.000 Dollar erfolgreich verteidigt hat, steht der Bitcoin Preis nun nahe der 13.600 Dollar Marke. Wenn diese Marke durchb...