Automated Trading Accelerator Program › Forums › Python for Financial Analysis › Support Session Recordings and Code
- This topic has 9 replies, 1 voice, and was last updated 2 years, 9 months ago by
Bruce Bitner.
-
AuthorPosts
-
March 5, 2020 at 12:24 pm #5599
Bruce Bitner
KeymasterMarch 5, 2020 at 2:10 pm #5603Bruce Bitner
Keymaster::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.
March 5, 2020 at 4:11 pm #5605Bruce Bitner
Keymaster::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
March 13, 2020 at 9:17 am #5625Bruce Bitner
Keymaster::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 SheetsMarch 13, 2020 at 9:21 am #5629Bruce Bitner
Keymaster::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']])
March 15, 2020 at 3:45 pm #5636Bruce Bitner
Keymaster::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 SheetsApril 9, 2020 at 10:03 am #5767Bruce Bitner
Keymaster::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 correlationAll 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.
April 16, 2020 at 3:38 pm #5792Bruce Bitner
Keymaster::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 titleApril 23, 2020 at 9:48 am #5881Bruce Bitner
Keymaster::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 togetherMay 7, 2020 at 3:13 pm #5949Bruce Bitner
Keymaster::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. -
This reply was modified 2 years, 11 months ago by
-
AuthorPosts
- You must be logged in to reply to this topic.