It constantly surprises me that so many cryptocurrency investors -- and all investors -- don't utilize the tools that are in front of their face! Awareness of these tools can lead to greater insights and potentially, improve profitability potential.
In my last few posts, I talked about assessing the correlation between bitcoin and ethereum. In this post, I'd like to address short cuts.
Common Microsoft applications are underlined using a computer language called VBA, or Visual Basic for Applications. Using VBA, you can make shortcuts of virtually all functions, including building a unique application on top of the original Microsoft platform.
To make a keyboard shortcut -- Shift, Ctrl, A (in my case) -- for the correlation analysis, I first assume that I have three columns: column A for date, column B for bitcoin price, and column C for ethereum price.
Then, in the Developer's tool, I enter the following code:
Sub Macro1()
'
' Macro1 Macro
' test
'
' Keyboard Shortcut: Ctrl+Shift+A
'
ActiveCell.FormulaR1C1 = "=CORREL(C[-2],C[-1])"
Range("D3").Select
End Sub
BOOM! Now, with this simple code, every time I highlight my cursor at cell D3 -- the Range("D3").Select -- all I have to do is put in my combo code Ctrl+Shift+A to get the correlation between Bitcoin and Ethereum!
Thanks for checking out my #SteemEd post. For more of my work, please see the following:
- TipRanks profile -- https://www.tipranks.com/bloggers/josh-enomoto
- InvestorPlace profile -- https://investorplace.com/author/joshenomoto/#.WpHykKjwZPY
- Crush The Street profile -- https://crushthestreet.com/about-joshua-enomoto
- Future Money Trends profile -- https://www.futuremoneytrends.com/about-us
- Market Mavens profile -- http://www.marketmavens.com/author/jenomoto/
- Muck Rack profile -- https://muckrack.com/josh-enomoto
- TipRanks "Top Blogger" featured profile
- Kiplinger feature article
- Nasdaq feature article
- MSN Money feature article
- Yahoo Finance feature article
- Financial Survival Network with Kerry Lutz feature
- Citizens For Trump political activism
- The Daily Coin feature article
- Before Its News linked article
- Duane Morris LLP expert reference
- Scutify feature article
- Trading.co.uk featured link to my Top Blogger profile
- ETF Trading Research feature article
- Commodity Trading Research feature article
- Daily Trade Alert expert reference
- Bitcoin Newswire feature article
- Minyanville feature article
- Family Council expert reference
- Radio host James L. Paris Christian Money expert reference
- Korean Community of San Francisco feature article
- Wealth Insider Alert feature article
Frank APPROVED!
Resteem...and Promoted
https://steemit.com/promoted/investing
Thank you so much! :)
As always thanks for the insight, and the time you put into providing it. I can’t tell you how you are making me understand what was foreign to me a month ago. Keep on rocking in the free world!
I genuinely appreciate your support and your incredible encouragement...thank you! :)
Thanks for the tip~~