Deriscope

The Excel Derivatives Periscope

Deriscope_VBA_Documentation


Deriscope supports Visual Basic.
Any function or subroutine from the list shown further below may be inserted in a Visual Basic code in order to access Deriscope from within VBA.
The following 4 lines should be inserted in the VBA code so that they run before any Deriscope functions are called:

Dim addin As COMAddIn
Dim adxModule As Object
Set addin = Application.COMAddIns.Item("DeriscopeGui.AddinModule")
Set adxModule = addin.Object

Next you may call a Deriscope subroutine named XYZ that returns no value and takes as input the arguments a1, a2, ..., with or without the Call keyword as follows:

Call adxModule.XYZ(a1, a2, ...)
adxModule.XYZ(a1, a2, ...)

If the Deriscope subroutine named XYZ takes no arguments, you should omit the parentheses:

Call adxModule.XYZ
adxModule.XYZ

If the Deriscope function named XYZ returns a value, you cannot use the Call keyword if you want to access the returned value:

x = adxModule.XYZ(a1, a2, ...)

Below is the list of supported routines:
IsDeriscopeAnalyticsLoaded
IsDeriscopeWizardEnabled
LoadDeriscope
UseWizard
QuitWizard
ShowWizard
MinimizeWizard
HideWizard
TutorialsAndWarnings
ForceRecalc
SetLiveFeeds
StartLiveFeeds
StopLiveFeeds
StopAllLiveFeeds
CheckLiveFeedsCredentials
SetTimeOut
SetAutoCalc
SetManualCalc
SetAutoRefresh
SetFlash
SetFlashDuration
ToggleFlash
GetTradeDate
SetTradeDate