Support Session Recordings and Code

[Bruce Bitner]

Up

0

Down

::

Hi All!

I’ll post all the recordings and any code discussed in the Q&A Support meetings here!

Bruce

[Bruce Bitner]

Up

0

Down

::

Today’s Support Q&A recording.

Topics Covered:
1. Using Python to investigate Ethereum Crypto Currency
– Rank of range candles using .rank()
– How to quickly find the dates for the top and bottom 2% of the range candles.
2. Can Python be used for for the Ethereum Platform?
3. Error using .shift(1) in a loop
4. Using Python to connect to Goggle sheets (brief overview)

March 5, 2020 Python Support Q&A

• This reply was modified 2 years, 11 months ago by Bruce Bitner.

[Bruce Bitner]

Up

0

Down

::

Code snippets:

1. Rank investigation

cols = ['High','Low','Close', 'PriceRange']
df.loc[:,'PriceRange'] = (df.High - df.Low) / df.Close.shift(1)

df.loc[:,'PRangeRank'] = df.PriceRange.rank(pct=True)

xdf = df[df.PRangeRank > 0.98]

2. Libraries needed for connecting to Google Sheets

#import gspreads as gs
#from oauth2client.service_account import SerivceAccountCredentials

[Bruce Bitner]

Up

0

Down

::

Support Q&A Video from 3/12

Topics Covered include:
1. Collecting FinViz.com stock screener data into Python.
2. Part 1 of using Python to read and write to Google Sheets

March 12, 2020 Python Support Q&A

[Bruce Bitner]

Up

0

Down

::

Code for “Collecting FinViz.com stock screener data into Python”

# -*- coding: utf-8 -*-
"""
Created on Thu Mar 12 07:45:26 2020

@author: Bruce1
"""

import pandas as pd

url = 'https://finviz.com/screener.ashx?v=111&f=ind_aluminum,sec_basicmaterials'

df = pd.read_html(url, header=0)[14]

print(df[['Ticker','Price']])

[Bruce Bitner]

Up

0

Down

::

The recording link above is not working, so here’s another.

Support Q&A Video from 3/12

Topics Covered include:
1. Collecting FinViz.com stock screener data into Python.
2. Part 1 of using Python to read and write to Google Sheets

March 12, 2020 Python Q&A

[Bruce Bitner]

Up

0

Down

::

Here is today’s recording and code:

Topics covered in this session include:

-> Continued work on Risk on / Risk off tool
-> Preparing and merging two dataframes
-> Rolling Correlation between 2 assets
-> Histogram of rolling correlation

April 9th, 2020 Python Q&A

All the session recording may be found here:

Python Q&A Recordings and Code

• This reply was modified 2 years, 10 months ago by Bruce Bitner.

[Bruce Bitner]

Up

0

Down

::

Here is today’s recording and code:

Topics covered in this session include:

-> Extend Risk on / Risk off tool
-> Rolling Correlation between unlimited number of assets
-> Histogram of each rolling correlation with descriptive title

April 16th, 2020 Python Q&A

[Bruce Bitner]

Up

0

Down

::

Here is today’s recording and code:

Topics covered in this session include:

-> Continued development on the Risk on / Risk off tool
-> Introduction and application of the .apply() function
-> Visualization of filter and equity curve together

April 23rd, 2020 Python Q&A

[Bruce Bitner]

Up

0

Down

::

Here is today’s recording and code:

Topics covered in this session include:

-> Forward looking risk/reward range tool for quickly determining edge
-> How to iteratively walk forward window testing across multiple assets
-> Visualize realized risk and reward as histograms for every day in a time series.

May 7th, 2020 Python Q&A

[Author]

Posts