Skip to content

Instantly share code, notes, and snippets.

View danwagnerco's full-sized avatar

Dan Wagner danwagnerco

89 followers · 393 following
View GitHub Profile
@danwagnerco
danwagnerco / fair_option_pricing.ipynb
Created September 7, 2024 16:03
How much value is there in attempting to out-model your counterparty?
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@danwagnerco
danwagnerco / grainger.md
Created June 6, 2024 11:17
Image access for Grainger documents

image

@danwagnerco
danwagnerco / wifeyalpha_books.md
Last active January 7, 2024 15:04
WifeyAlpha recommended reading
@danwagnerco
danwagnerco / sentiment.md
Created March 6, 2022 05:39
Market sentiment
@danwagnerco
danwagnerco / nasa_notes.md
Last active February 27, 2022 19:19
Notes on NASA presentations
@danwagnerco
danwagnerco / wifey_alpha_research_thread_2022-01-16.md
Last active June 4, 2024 13:49
Wifey Alpha Research Thread 2022-01-16
@danwagnerco
danwagnerco / list.md
Created January 28, 2022 02:48 — forked from ih2502mk/list.md
Quantopian Lectures Saved
@danwagnerco
danwagnerco / clear_cell_contents_on_click.vb
Created April 14, 2017 17:50
Placed in the Worksheet you'd like this mode to work in, you can clear cell contents by simply clicking the cell, which allows for instant editing
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.FormulaR1C1 = ""
End Sub
@danwagnerco
danwagnerco / dmikester1_mod.vb
Created March 29, 2017 20:01
small adjustment
'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
@danwagnerco
danwagnerco / CombineManyWorkbooksIntoOneWorksheet.vb
Last active May 16, 2019 16:51
This VBA macro combines data from many workbooks in a single folder into a single worksheet
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