Trades

<< Click to Display Table of Contents >>

Navigation:  Import > Excel >

Trades

You can add trades in bulk using excel files (csv, xlsx). There is a Transactions.xls template file under the Program Files\Sword Tech\TradingDiary Pro\GeneralExcelImportSamples directory.

Click on the Transactions tab and fill in the template with your trades and then save as a new file in the Documents folder. Please note you cannot save the file in its original location because those files are read-only.

Set 'Excel Importer' as import module. For detailed information read the Import Introduction chapter.

 

Click on the 'Import/Import - Excel' menu. A file dialog appears. Select the previously saved xlsx file and click on Open.

 

You are done. Now you can see the import manager which shows the number of imported elements.

 

 

Description of the columns:

1.TransactionID                unique identifier for each transaction. TradingDiary Pro use this value to identify duplicated transactions. If you leave it empty TradingDiary Pro generate a value from the based on the row values.

2.DateTime                        Date and time of the transaction

3.Ticker                        Ticker of the instrument

4.Description                        Description

5.Quantity                        Quantity

6.Price                        The price that an investor pays for a security

7.Commission                Commission paid to the brokerage

8.Asset Category                Asset category, possible values are: Stock, Futures, Option, Futures Option, Forex, Bond, Warrant, CFD

9.Multiplier                        Multiplier of the instrument,

10.Currency                        Three digit universal currency code. For example: USD, EUR, AUD, CAD, JPY, HUF

11.Conversion rate                Conversion rate to base currency, used only if the base currency differs from the currency of the transaction

12.Expiration Date                Expiration date of the instrument, available for Futures, Option, Futures Option and Warrant asset categories

13.Call or Put                        Call or Put, available for Option, Futures Option and Warrant asset categories

14.Strike                        Strike of the option or warrant

15.Note                        Note

16.Exchange                        Name of the exchange

17.Tag(s)                        Tags separated by a semicolon character. If the string does not contain semicolon the whole string will be added as a single tag.

 

 

Stock:

18.TransactionID                optional, if it is used please provide a unique identifier for each transaction

19.DateTime                        obligatory

20.Ticker                        obligatory

21.Description                        optional, if the columns is empty ticker is used

22.Quantity                        obligatory

23.Price                        obligatory

24.Commission                optional

25.Asset Category                Stock

26.Multiplier                        1

27.Currency                        optional, if empty base currency is used

28.Conversion rate                optional, use it of the currency differs from the base currency

29.Expiration Date                unused

30.Call or Put                        unused

31.Strike                        unused

32.Note                        optional

33.Exchange                        optional

34.Tags                        optional

 

 

Futures:

35.TransactionID                optional, if it is used please provide a unique identifier for each transaction

36.DateTime                        obligatory

37.Ticker                        obligatory

38.Description                        optional, if the columns is empty ticker is used

39.Quantity                        obligatory

40.Price                        obligatory

41.Commission                optional

42.Asset Category                Futures

43.Multiplier                        obligatory

44.Currency                        optional, if empty base currency is used

45.Conversion rate                optional, use it of the currency differs from the base currency

46.Expiration Date                optional

47.Call or Put                        unused

48.Strike                        unused

49.Note                        optional

50.Exchange                        optional

51.Tags                        optional

 

Options:

52.TransactionID                optional, if it is used please provide a unique identifier for each transaction

53.DateTime                        obligatory

54.Ticker                        obligatory

55.Description                        optional, if the columns is empty ticker is used

56.Quantity                        obligatory

57.Price                        obligatory

58.Commission                optional

59.Asset Category                Option

60.Multiplier                        obligatory

61.Currency                        optional, if empty base currency is used

62.Conversion rate                optional, use it of the currency differs from the base currency

63.Expiration Date                optional

64.Call or Put                        obligatory

65.Strike                        obligatory

66.Note                        optional

67.Exchange                        optional

68.Tags                        optional

 

Future Options:

69.TransactionID                optional, if it is used please provide a unique identifier for each transaction

70.DateTime                        obligatory

71.Ticker                        obligatory

72.Description                        optional, if the columns is empty ticker is used

73.Quantity                        obligatory

74.Price                        obligatory

75.Commission                optional

76.Asset Category                Future Option

77.Multiplier                        obligatory

78.Currency                        optional, if empty base currency is used

79.Conversion rate                optional, use it of the currency differs from the base currency

80.Expiration Date                optional

81.Call or Put                        obligatory

82.Strike                        obligatory

83.Note                        optional

84.Exchange                        optional

85.Tags                        optional

 

Forex:

86.TransactionID                optional, if it is used please provide a unique identifier for each transaction

87.DateTime                        obligatory

88.Ticker                        obligatory

89.Description                        optional, if the columns is empty ticker is used

90.Quantity                        obligatory

91.Price                        obligatory

92.Commission                optional

93.Asset Category                Forex

94.Multiplier                        1

95.Currency                        obligatory

96.Conversion rate                obligatory

97.Expiration Date                unused

98.Call or Put                        unused

99.Strike                        unused

100.Note                        optional

101.Exchange                        optional

102.Tags                        optional