Posts

Showing posts from June, 2018

VBA Randomize a 3x3 Filter for Convoluted Neural Network

Image
EXCEL FOR FINANCE How to Randomize a 3x3 Filter for a Convoluted Neural Network in VBA Option Explicit Private Sub CommandButton1_Click()    Application.ScreenUpdating = False    Application.DisplayStatusBar = False     Dim i, j As Integer     Dim randomNumber As Double        For i = 1 To 3       Randomize                     For j = 1 To 3               randomNumber = rnd()                 'Application.ActiveWorkbook.ActiveSheet.Cells(i + 20, j + 29).Select                Application.ActiveWorkbook.Active...

Setting Up The Sublime Text Editor for Python

Image
Setting Up Sublime Text Editor for Python Install the Sublime Text 3 Go to View > Show Console Click on Ctrl+Shift+P and type INSTALL You can now install packages like gitsavy etc. Useful packages: Python Checker, Python Completions, Python Debugger or Xdebug, Python Improved, BracketHighlighter,SideBarEnhancements, Anaconda (this is not the same as the anaconda python distro, rather it is a Python IDE for Sublime ) Yor Sublime is now a Python IDE. You should be able to get bracket tracking, syntax checks, and debugging capabilities with XDebug.