View wifey_alpha_research_thread_2022-01-16.md
Wifey Alpha Research Threads
- Regimes & Correlations
- Risk On/Off Bull/Bear Markets
- The Vix
- Normie Starter Pack
- Piglet Pack
- Pig Pack
View list.md
Lecture 1: Introduction to Research — [
Lecture 2: Introduction to Python — [
Lecture 3: Introduction to NumPy — [
Lecture 4: Introduction to pandas — [
Lecture 5: Plotting Data — [
View clear_cell_contents_on_click.vb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Option Explicit | |
Private Sub Worksheet_SelectionChange(ByVal Target As Range) | |
Target.FormulaR1C1 = "" | |
End Sub |
View dmikester1_mod.vb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'don't do this anymore: | |
DataBlock.SpecialCells(xlCellTypeVisible).Copy Destination:=Target.Cells(1, 1) | |
'instead try this: | |
Dim rngDestination As Range 'this should be way up at the top with all the other declarations | |
' ... all the other code | |
Set rngDestination = Target.Cells(1, 1) | |
DataBlock.SpecialCells(xlCellTypeVisible).Copy | |
rngDestination.PasteSpecial xlPasteType:=xlPasteValuesAndNumberFormats |
View CombineManyWorkbooksIntoOneWorksheet.vb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Option Explicit | |
Public Sub CombineManyWorkbooksIntoOneWorksheet() | |
Dim strDirContainingFiles As String, strFile As String, _ | |
strFilePath As String | |
Dim wbkDst As Workbook, wbkSrc As Workbook | |
Dim wksDst As Worksheet, wksSrc As Worksheet | |
Dim lngIdx As Long, lngSrcLastRow As Long, _ | |
lngSrcLastCol As Long, lngDstLastRow As Long, _ | |
lngDstLastCol As Long, lngDstFirstFileRow As Long |
View HighlightCorrespondingCells.vb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Option Explicit | |
Private Sub Worksheet_SelectionChange(ByVal Target As Range) | |
Dim wksLookups As Worksheet | |
Dim lngFirstRow As Long, lngLastRow As Long | |
'Get the Worksheet so we can confidently identify | |
'the Range that we'll be highlighting (if need be) | |
Set wksLookups = Target.Parent | |
View exampleEarlyBindingWithScriptingDictionary.vb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Dim dicCoolDictionary As Scripting.Dictionary | |
Set dicCoolDictionary = New Scripting.Dictionary | |
' then start assembling the dictionary |
View exampleEarlyBinding.vb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Dim variable as SomeObjectType | |
Set variable = New SomeObjectType |
NewerOlder