Download Excel Addin 64bit Download Excel Addin 32bit

OpenDataDepot Excel Addin Help

Get Tickers Values:
=odd_get( ticker [,date] [,mode] )
  • Ticker: ( string, required ): indicates what's the ticker query.
  • Date: ( date, optional ): indicates the query's date. The current date is the default value is not indicated.
  • Mode: ( integer, optional ): indicates the mode of working. The default value is 1.
Modes:
Mode Mode behaviour Prior to oldest date in DB In between dates in the DB On date in DB In the future
0 Exact Date Return Value not Available Return Value not Available Return value for date Return Value not Available
1 Closest date Return oldest value Return closest value Return value for date Return latest value
2 Interpolate Return oldest value Interpolate Return value for date Return latest value
3 Random value from distribution Return oldest value Interpolate Return value for date Return random value from distribution
Set Tickers Values:
=odd_set( ticker [,date] ,value [,update] )
  • Ticker: ( string, required ): indicates what's the ticker query.
  • Date: ( date, optional ): indicates the query's date. The current date is the default value is not indicated.
  • Value: ( double, required ): indicates the value to be set.
  • Update: ( boolean, optional ): indicates if the function must override a value if already exists for this date. The default value is True.
Get Tickers Info:
=odd_info( ticker, argument )
  • Ticker: ( string, required ): indicates what's the ticker query.
  • Ticker: ( string, required ): indicates what's the query attribute. Options: owner | ticker | name | last_update | description | source.