Contents

class AddIbContracts < ActiveRecord::Migration

  def change
    create_table(:ib_contracts) do |t|

      t.integer :con_id # int: The unique contract identifier.
      t.string :sec_type, :limit => 5 # Security type. Valid values are: SECURITY_TYPES
      t.float :strike # double: The strike price.
      t.string :currency, :limit => 4 # Only needed if there is an ambiguity e.g. when SMART exchange
      t.string :sec_id_type, :limit => 5 # Security identifier when querying contract details or
      t.string :sec_id # Unique identifier of the given secIdType.
      t.string :legs_description # received in OpenOrder for all combos
      t.string :symbol # This is the symbol of the underlying asset.
      t.string :local_symbol # Local exchange symbol of the underlying asset
      t.integer :multiplier
      t.string :expiry # The expiration date. Use the format YYYYMM or YYYYMMDD
      t.string :exchange # The order destination such as Smart.
      t.string :primary_exchange # Non-SMART exchange where the contract trades.
      t.boolean :include_expired, :limit => 1 # When true contract details requests and historical
      t.string :right, :limit => 1 # Specifies a Put or Call. Valid input values are: P PUT C CALL

      t.string  :type # Contract Subclasses STI
      t.timestamps
    end
  end
end

__END__
rails generate scaffold contract con_id:integer sec_type:string strike:float currency:string 
 sec_id:string sec_id_type:string legs_description:string symbol:string local_symbol:string 
 multiplier:integer expiry:string exchange:string primary_exchange:string 
 include_expired:boolean right:string type:string 

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
ib-ruby-0.9.2	db/migrate/171_add_ib_contracts.rb
ib-ruby-0.9.1	db/migrate/171_add_ib_contracts.rb
ib-ruby-0.9.0	db/migrate/171_add_ib_contracts.rb
ib-ruby-0.8.5	db/migrate/171_add_ib_contracts.rb