Tag Archives: spreadsheet

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

YouTube Preview Image 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 

YouTube Preview Image

 

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

 

YouTube Preview Image

 

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

YouTube Preview Image 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!

Is Quant Cell really the big data Excel spreadsheet and end-user programming environment with Hadoop in mind?

 

Is Quant Cell really the big data Excel spreadsheet and end-user programming environment with Hadoop in mind?

As described on the site:

Welcome to QuantCell Research

— the developer of QuantCell, the simple to use big data spreadsheet and end-user programming environment.

http://www.quantcell.com/web/index.html

Thanks to Sholom for sending

Join my FREE newsletter to learn more discoveries from Sholom

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!

Will this Excel spreadsheet be the roadmap to my future in quant trading strategy algo and model development?

Hi there

I am pumping out lots of excting stuff:

Excel spreadsheet roadmap of future quant trading strategy algo and model development complete
– See more at: https://quantlabs.net/blog/2014/02/excel-spreadsheet-roadmap-of-future-quant-trading-strategy-algo-and-model-development-complete/#sthash.Fs1XKYc4.dpuf

Tradestation offers no binary options and other limitations to your retail trading platform – See more at: https://quantlabs.net/blog/2014/02/tradestation-offers-no-binary-options-and-other-limitations-to-your-retail-trading-platform/#sthash.DpfRmqur.dpuf

Is the SPX the magic indicator to look for when the stock market is tanking in 2014?
– See more at: https://quantlabs.net/blog/2014/02/is-the-spx-the-magic-indicator-to-look-for-when-the-stock-market-is-tanking-in-2014/#sthash.GDBYp3ZK.dpuf

Why I dump on Multicharts and other retail trading platforms? What I offer as a solution
– See more at: https://quantlabs.net/blog/2014/02/why-i-dump-on-multicharts-and-other-retail-trading-platforms-what-i-offer-as-a-solution/#sthash.LxtSylA0.dpuf

Tired of all these technical trading limitations? Be an Elite Quant to unleash your profit potential!

->  GET STARTED NOW <-

Thanks for reading

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!

Excel spreadsheet roadmap of future quant trading strategy algo and model development complete

Excel spreadsheet roadmap of future quant trading strategy algo and model development complete

Join my FREE newsletter on how I plan to to attack this

YouTube Preview Image 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!

I am working on an Excel spreadsheet that will highlight all future trading strategy categories by asset class

 

I am working on an Excel spreadsheet that will highlight all future trading strategy categories by asset class.

These are gleaned from the books of:

C# in Financial Markets

Trading Systems and Methods

This will be posted as part of my new Elite membership 

Update: I have finished the C# in Financial Markets so now I test the source code

More Updates: I have completed the source code vetting for C# in Financial Markets:

Hooray! Most source code for DotNet book called C# in Financial Markets work

I now will be focusing on the Trading Systems and Methods book strategies. This is more realistic due to a couple of things:

1. It is the next logical step to experiment in ‘godfather’ quant books like the big series from Paul Wilmott

2. The code is in Tradestation Easy Language which needs to be ported over to .NET C#. That will be fun and lengthy. All of these projects will be entered in to my Elite Membership section. Also, it contains many (I mean many) strategy types which covers a lot.

3. Using a retail platform to source out trading strategies might be a smart way to reverse engineer these due to algos are included. Most of all the programming logic for trading execution is included as well. As a result, it could be one of the better guidelines to code up my own strategies for my trading environment found in my Elite Membership!

4. One last thing: Holy frigging 1200+ pages!!

Join my FREE newsletter once this is ready to go

Here is a sample:

C# IN FINANCIAL MARKETS asset strategy priority (fx=forex, f=futures, o=options, fi=fix income, e=equity)
Strategy name Asset Type
2.9 MINI APPLICATION: OPTION PRICING o
4.3.1 Defining Standard Interfaces fi
4.6 ExplicitEuler: o
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!