Tag Archives: spreadsheet

Math skills vs stage of life: Excel spreadsheet to python

Is this true? I think so if you ain’t programming. I have never seen anything as popular as thing. Must ring true if you end in a spreadsheet like Microsoft Excel or even in python.

Most traders and analysts use spreadsheets such as Excel. It makes we wonder how useful they would be if they decided to go to Python.

https://www.bleepingcomputer.com/news/microsoft/microsoft-considers-adding-python-as-an-official-scripting-language-to-excel/

Go to Python?

This may go somewhere. They even teach kids Python skills. Why are you not learning? This is especially true with your algorithmic/automated trading. We are wrapping up our live component  of this course this week.

Python Algo Trading Infrastructure with Crypto Currency

As you know the pricing of this course will be going in up in about 1 week. I will keep discounts in place if you want to transact in crypto currency like Bitcoin.  Ask away how we set that up!!

Thanks Bryan

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

New view of automated crypto analysis spreadsheet and Word doc

This document will showcase the new views of the crypto data from Binance. This is important but convenient for those who join Analytics listed below. These are the same spreadsheets and Word documents with short/long reports.

I have also included the charts from many deep technical analysis with 10+ indicators. Check out this video

Quant Analytics

 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Analytics provides embedded spreadsheet for crucial cryptocurrency analysis

This enables you not needing to download attachments of Excel spreadsheets and Word documents. Ugh… what a mess that could be. Well, I searched high and low with a decent result. I can now post these demonstrated in this video

Here is a video to demonstrate this POV

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Positions Spreadsheet of up 5% in market: Continue trading same day?

 

I posted this on my private Telegram last night with spreadsheet you can download

Here is an example of last nite. it is up 5.45% for all the positions. Is it worth to stop on the first one? Or continue to risk losing first return of the position of 4.27%? in this case, I was lucky but I can easily lose the profit or go negative entirely. this is my point of what can happen. I am able to control the losing positions when my weight average of the big 5 cryptos coins are >%1. This was the case last night so I include the mock positions. the crypto market is still >1% right now So i reset to see what happens from this point on. what would you do ?

positionsExitLog

If you want to be part of my Telegram group, you can join via the 2 trials I offer which are:

$37 7 day trial to Analytics

introduction to quant analytics

or $497 for 2 month trial for algo trading course

Quant Elite Trial v2

 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

LIVE Overview of spreadsheet data for crypto currency optimal automated trading

This will be covered live at youtube.com/quantlabs live on Mon Jul at 7PM EDT. More details at youtube.com/quantlabs

Let me present the short video

This includes the details of how you can use my spreadsheet from the Quant Analytics everyday

Hi there,

You are invited to a Zoom webinar.
When: Jul 9, 2018 7:00 PM Eastern Time (US and Canada)
Topic: LIVE Overview of spreadsheet data for crypto currency optimal automated trading

Please click the link below to join the webinar:
https://zoom.us/j/303876354

Or iPhone one-tap :
US: +16465588656,,303876354# or +16699006833,,303876354#
Or Telephone:
Dial(for higher quality, dial a number based on your current location):
US: +1 646 558 8656 or +1 669 900 6833
Webinar ID: 303 876 354
International numbers available: https://zoom.us/u/bUN9jPlP9

 

Important notes of spreadsheet columns:

slope : slope of the regression line

intercept : intercept of the regression line

r-value : correlation coefficient

p-value : two-sided p-value for a hypothesis test whose null hypothesis is that the slope is zero

stderr : Standard error of the estimate

https://stackoverflow.com/questions/9538525/calculating-slopes-in-numpy-or-scipy

Understand the relationship: https://www.researchgate.net/post/What_is_the_relationship_between_R-squared_and_p-value_in_a_regression

Extra momentum as calculated from: https://github.com/bukosabino/ta

 

Latest learning on Algo trading with Crypto currency with Binance market data

 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Trend and momentum added for sorting criteria automated cryptocurrency ranking spreadsheet

 

Some of you may have seen my latest webinar video playback from last night on Jul 2. I just added another video to my Youtube channel demonstrating a new data set of data from another technical assistance Python package found below. I also have new sorting criteria for optimal trading opportunity as well.

Here are the benefits

These include a new range of trend and momentum criteria which is added to the spreadsheet I show. I also add this to my sorting criteria which already included volume, and volatility. I am hoping this this new sorting criteria will make the chosen crypto pairs more optimal for trading opportunity.

https://github.com/bukosabino/ta

 

In the Trenches with Crypto Currencies video replay

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Roadmap Excel spreadsheet to 250 videos for premium quant

Roadmap Excel spreadsheet to 250 videos for premium quant

I posted this for my new Premium members

Join my FREE newsletter to learn about joining this membership

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Demo of Matlab Spreadsheet Link to Microsoft Office Excel

Demo of Matlab Spreadsheet Link to Microsoft Office Excel

Here is an updated version of a powerful combination

A Visual Studio C# source code project has been updated for Quant Elite members 

Join my FREE newsletter to learn more about Matlab tricks 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Download this Excel spreadsheet sample of automatically generated trading opportunity list of stocks of this small European exchange

Download this Excel spreadsheet sample of automatically generated trading opportunity list of stocks of this small European exchange

This was generated automatically as explained in this video below

This link is connected with the video as well

Join my FREE newsletter to learn more about how i generate spreadsheets like this

Here is the Excel file:

greekgift

 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Here is A List of All Yahoo Finance Stock Tickers as an Excel Spreadsheet

Here is A List of All Yahoo Finance Stock Tickers as an Excel Spreadsheet

Very neat compiled list with a necessary

A List of All Yahoo Finance Stock Tickers

Join my FEEE newsletter to see what other cool resource I get

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!