Генератор налоговой декларации из отчетов IB


Ирина
Сообщения: 3
Зарегистрирован: 02 апр 2021, 19:54

Генератор налоговой декларации из отчетов IB

Сообщение Ирина »

добрый день,подскажите,пожалуйста, как расчитывается вкладка аренда ценных бумаг?
у меня было очень много шортовых операций,но во вкладке аренда ценных бумаг они отражены не все,только несколько за каждый месяц,и сумма большая


Ника
Сообщения: 2
Зарегистрирован: 14 апр 2021, 21:13

Генератор налоговой декларации из отчетов IB

Сообщение Ника »

Здравствуйте! Подскажите пожалуйста как заполнять вкладку доходы за пределами РФ в декларации 3-ндфл? Во вкладке источники выплат перечислять каждую зафиксированную акцию и соответственно ее даты и суммы? А если было много реализаций? Нельзя ли как-то одной строкой указать?

Аватара пользователя

Автор темы
ElectrostaticMister
Сообщения: 185
Зарегистрирован: 12 май 2020, 23:14

Генератор налоговой декларации из отчетов IB

Сообщение ElectrostaticMister »

Ирина писал(а): 14 апр 2021, 20:07 добрый день,подскажите,пожалуйста, как расчитывается вкладка аренда ценных бумаг?
у меня было очень много шортовых операций,но во вкладке аренда ценных бумаг они отражены не все,только несколько за каждый месяц,и сумма большая
По отчетам IB списывает плату за шорт в начале следующего месяца за весь предыдущий одной суммой, я использую эту сумму. Хотя у него есть и подневная детализация, можно самостоятельно пересчитывать при желании. Кроме того, в этой вкладке могут быть другие расходы, связанные с шортом, например доплата дивидендов ареднодателю бумаги.

Аватара пользователя

Автор темы
ElectrostaticMister
Сообщения: 185
Зарегистрирован: 12 май 2020, 23:14

Генератор налоговой декларации из отчетов IB

Сообщение ElectrostaticMister »

Ника писал(а): 14 апр 2021, 21:25 Здравствуйте! Подскажите пожалуйста как заполнять вкладку доходы за пределами РФ в декларации 3-ндфл? Во вкладке источники выплат перечислять каждую зафиксированную акцию и соответственно ее даты и суммы? А если было много реализаций? Нельзя ли как-то одной строкой указать?
По-разному делают. Я собираю доходы по тикеру за один день в один доход для программы Декларация. Кто-то рассчитывает доходы и расходы в рублях за весь год и вводит полученный результат одним доходом в конце года. Итоговый результат будет почти одинаковый, главное самому понимать как происходит расчет и при необходимости это объяснить.


Ника
Сообщения: 2
Зарегистрирован: 14 апр 2021, 21:13

Генератор налоговой декларации из отчетов IB

Сообщение Ника »

Спасибо огромное за ответ!


Ирина
Сообщения: 3
Зарегистрирован: 02 апр 2021, 19:54

Генератор налоговой декларации из отчетов IB

Сообщение Ирина »

ElectrostaticMister писал(а): 15 апр 2021, 04:31
Ирина писал(а): 14 апр 2021, 20:07 добрый день,подскажите,пожалуйста, как расчитывается вкладка аренда ценных бумаг?
у меня было очень много шортовых операций,но во вкладке аренда ценных бумаг они отражены не все,только несколько за каждый месяц,и сумма большая
По отчетам IB списывает плату за шорт в начале следующего месяца за весь предыдущий одной суммой, я использую эту сумму. Хотя у него есть и подневная детализация, можно самостоятельно пересчитывать при желании. Кроме того, в этой вкладке могут быть другие расходы, связанные с шортом, например доплата дивидендов ареднодателю бумаги.
Большое спасибо за обратную связь


vdm
Сообщения: 2
Зарегистрирован: 23 янв 2021, 02:36

Генератор налоговой декларации из отчетов IB

Сообщение vdm »

>>Исходные данные: flex-отчет IB, выписка IB, пользовательский отчет IB
Для генератора нужны все три документа или можно один flex-отчет?

Аватара пользователя

Автор темы
ElectrostaticMister
Сообщения: 185
Зарегистрирован: 12 май 2020, 23:14

Генератор налоговой декларации из отчетов IB

Сообщение ElectrostaticMister »

vdm писал(а): 15 апр 2021, 22:15 >>Исходные данные: flex-отчет IB, выписка IB, пользовательский отчет IB
Для генератора нужны все три документа или можно один flex-отчет?
Один из трех, лучше flex, если выписка или пользовательский отчет - лучше на английском языке.


vdm
Сообщения: 2
Зарегистрирован: 23 янв 2021, 02:36

Генератор налоговой декларации из отчетов IB

Сообщение vdm »

Выдал лог с ошибками :( FLEX-отчет у меня с расширением txt сформировался в IB. Когда загружаю в генератор FLEX-отчет, то после нажатия кнопки Отправить, кнопка отправить остается нажатой и ничего не формируется - так и висит пока не нажмешь Очистить. Когда загружаю IB-выписку, то выдает архив с логом ошибок.
Могу выслать FLEX и выписку для анализа.

[2021-04-15 22:31:40.898326] NOTICE: Current version {"portfolio":"2021-04-15-68472ab","cbr":"2021-03-26-499fcb8","declaration":"2021-04-15-fb70501"}
[2021-04-15 22:31:41.127521] ERROR: Unknown dividend/WHT/fee description {"description":"RDSA.RTS(GB00BMWWHV73) Expire Dividend Right (Ordinary Dividend)"}
[2021-04-15 22:31:41.127649] ERROR: Unknown dividend/WHT/fee description {"description":"RDSA.RTS(GB00BMWWHV73) Expire Dividend Right (Ordinary Dividend)"}
[2021-04-15 22:31:41.127718] ERROR: Unknown dividend/WHT/fee description {"description":"FP.DIVRTS(FR0013517257) Expire Dividend Right (Ordinary Dividend)"}
[2021-04-15 22:31:41.127774] ERROR: Unknown dividend/WHT/fee description {"description":"FP.DIVRTS(FR0013517257) Expire Dividend Right (Ordinary Dividend)"}
[2021-04-15 22:31:41.130480] ERROR: Unknown dividend/WHT/fee description {"description":"RDSA.RTS(GB00BMWWHV73) Expire Dividend Right - XX TAX"}
[2021-04-15 22:31:41.130556] ERROR: Unknown dividend/WHT/fee description {"description":"RDSA.RTS(GB00BMWWHV73) Expire Dividend Right - XX TAX"}
[2021-04-15 22:31:41.130612] ERROR: Unknown dividend/WHT/fee description {"description":"FP.DIVRTS(FR0013517257) Expire Dividend Right - FR TAX"}
[2021-04-15 22:31:41.130660] ERROR: Unknown dividend/WHT/fee description {"description":"FP.DIVRTS(FR0013517257) Expire Dividend Right - FR TAX"}
[2021-04-15 22:31:41.136384] NOTICE: Set base broker currency {"currency":"USD"}
[2021-04-15 22:31:41.136469] NOTICE: Date ranges ["2020-01-01 2020-12-31"]
[2021-04-15 22:31:41.156592] ERROR: Security info doesn't match {"symbol":"RDSA","name":"currency","value":"GBP","newValue":"EUR"}
[2021-04-15 22:31:41.156686] ERROR: Security info doesn't match {"symbol":"RDSA","name":"currency","value":"GBP","newValue":"USD"}
[2021-04-15 22:31:41.156848] ERROR: Security info doesn't match {"symbol":"RDSA","name":"currency","value":"GBP","newValue":"EUR"}
[2021-04-15 22:31:41.156888] ERROR: Security info doesn't match {"symbol":"RDSA","name":"currency","value":"GBP","newValue":"USD"}
[2021-04-15 22:31:41.157071] ERROR: Security info doesn't match {"symbol":"HGM","name":"currency","value":"GBP","newValue":"USD"}
[2021-04-15 22:31:41.157286] ERROR: Security info doesn't match {"symbol":"HGM","name":"currency","value":"GBP","newValue":"USD"}
[2021-04-15 22:31:41.157569] ERROR: Security info doesn't match {"symbol":"RDSA","name":"currency","value":"GBP","newValue":"USD"}
[2021-04-15 22:31:41.157772] ERROR: Security info doesn't match {"symbol":"RDSA","name":"currency","value":"GBP","newValue":"USD"}
[2021-04-15 22:31:41.158074] ERROR: Security info doesn't match {"symbol":"RDSA","name":"currency","value":"GBP","newValue":"USD"}
[2021-04-15 22:31:41.158267] ERROR: Security info doesn't match {"symbol":"RDSA","name":"currency","value":"GBP","newValue":"USD"}
[2021-04-15 22:31:41.177151] NOTICE: Dividend WHT adjustment {"symbol":"PM","originalDate":"2020-04-09","originalWHT":"-0.59","adjustmentDate":"2020-04-09","newWHT":-0.02}
[2021-04-15 22:31:41.180924] WARNING: Skip unknown corporate action {"date":"2020-05-13","descripiton":"RDSA(GB00B03MLX29) Dividend Rights Issue 1 for 1 (RDSA.RTS, ROYAL DUTCH SHELL PLC-A SHS - DIVIDEND RIGHTS MAY 2020, GB00BMWWHV73)"}
[2021-04-15 22:31:41.181978] NOTICE: Dividend with fee and without WHT added {"symbol":"BTI","amount":"9.64","date":"2020-05-18"}
[2021-04-15 22:31:41.185403] NOTICE: Dividend without WHT added {"symbol":"HGM","amount":"29.09","date":"2020-06-05"}
[2021-04-15 22:31:41.185937] NOTICE: Dividend with fee and without WHT added {"symbol":"GLTR","amount":"61.98","date":"2020-06-09"}
[2021-04-15 22:31:41.187661] ERROR: Unknown dividend/WHT/fee description {"description":"RDSA.RTS(GB00BMWWHV73) Expire Dividend Right (Ordinary Dividend)"}
[2021-04-15 22:31:41.187799] ERROR: Unknown dividend/WHT/fee description {"description":"RDSA.RTS(GB00BMWWHV73) Expire Dividend Right - XX TAX"}
[2021-04-15 22:31:41.187874] ERROR: Strange negative dividend {"date":"2020-06-22","amount":"-0.43","description":"RDSA.RTS(GB00BMWWHV73) Expire Dividend Right - XX TAX","file":"/home/webmaster/uploaded/tax/101/1618515100/U1234567_U1234567_20200102_20201231_AS_Fv2_7a0941d0e31336ce4420053366c5f50d.csv#Dividends","lineno":587}
[2021-04-15 22:31:41.188004] ERROR: Can't apply row {"file":"/home/webmaster/uploaded/tax/101/1618515100/U1234567_U1234567_20200102_20201231_AS_Fv2_7a0941d0e31336ce4420053366c5f50d.csv#Dividends","lineno":587}
[2021-04-15 22:31:41.188078] ERROR: Can't handle all history events

Аватара пользователя

Автор темы
ElectrostaticMister
Сообщения: 185
Зарегистрирован: 12 май 2020, 23:14

Генератор налоговой декларации из отчетов IB

Сообщение ElectrostaticMister »

vdm писал(а): 15 апр 2021, 22:34 FLEX-отчет у меня с расширением txt сформировался в IB. Когда загружаю в генератор FLEX-отчет, то после нажатия кнопки Отправить, кнопка отправить остается нажатой и ничего не формируется - так и висит пока не нажмешь Очистить. Когда загружаю IB-выписку, то выдает архив с логом ошибок.
Могу выслать FLEX и выписку для анализа.
Flex-отчету надо просто поменять расширение с txt на csv, не изменяя содержание. Генератор ломается на конструкции Expire Dividend Right, он ее не знает, неважно выписка это или отчет. Присылайте flex и выписку через личные сообщения.

Аватара пользователя

Автор темы
ElectrostaticMister
Сообщения: 185
Зарегистрирован: 12 май 2020, 23:14

Отчет о движении средств

Сообщение ElectrostaticMister »

Вместе с расчетом налогов генератор создает отчет о движении средств. Полноценный отчет создается для брокеров с полноценными выписками (сейчас это только IB), для других брокеров рассчитывается только оборот, остатки надо брать откуда-то вручную.
Обычно отчет о движении рассчитывается правильно и сверяется по остаткам с выпиской, но иногда возможны ошибки, они выводятся в лог. Возможные причины ошибок:
  • когда-то была сделана смена базовой валюты брокера
  • брокер в качестве бонуса возвращал комиссии
  • портфель в целом рассчитан с ошибками
  • смена года оказывается внутри выписки/flex (например, она сделана за период с 1 декабря 2020 по 31 марта 2021)
По оборотам обнаружить ошибки в расчетах практически невозможно, по остаткам достаточно посмотреть в начало выписки в формате pdf. Если есть сомнения, остатки можно взять из выписки, обороты из расчета и проверить формулу исходящий остаток = входящий остаток + зачисления - списания.


vadimvs
Сообщения: 3
Зарегистрирован: 21 апр 2021, 08:44
Контактная информация:

Генератор налоговой декларации из отчетов IB

Сообщение vadimvs »

Делал flex отчет по инструкции, ошибки

[2021-04-21 15:21:27.656934] NOTICE: Current version {"portfolio":"2021-04-21-2e7a6af","cbr":"2021-03-26-499fcb8","declaration":"2021-04-17-32d8590"}
[2021-04-21 15:21:27.688554] NOTICE: Set base broker currency {"currency":"USD"}
[2021-04-21 15:21:27.688716] NOTICE: Date ranges ["2020-08-31 2020-12-31"]
[2021-04-21 15:21:27.715823] NOTICE: Dividend with fee and without WHT added {"symbol":"QIWI","amount":"17","date":"2020-12-09"}
[2021-04-21 15:21:27.717571] NOTICE: No bond position found
[2021-04-21 15:21:27.717629] NOTICE: No option position found
[2021-04-21 15:21:27.717661] NOTICE: No futures position found
[2021-04-21 15:21:27.717780] WARNING: Cash flow didn't match report {"year":2020,"currency":"USD","mode":"ending","flow":"14008.68","report":"14004.63"}
[2021-04-21 15:21:27.718235] ERROR: CASH didn't match report {"currency":"USD","amount":14008.68,"Report":14004.633807751}
[2021-04-21 15:21:27.718341] ERROR: Total commission didn't match report {"Commissions":-86.881040249,"Report":-90.92619225}
[2021-04-21 15:21:27.718415] ERROR: Transaction tax didn't match report {"TransactionTax":null,"Report":"-4.045152"}
[2021-04-21 15:21:27.718518] ERROR: Some problems in the final report


vasechka
Сообщения: 2
Зарегистрирован: 11 апр 2021, 23:28

Генератор налоговой декларации из отчетов IB

Сообщение vasechka »

Привет. Куда донат слать?

Аватара пользователя

Автор темы
ElectrostaticMister
Сообщения: 185
Зарегистрирован: 12 май 2020, 23:14

Генератор налоговой декларации из отчетов IB

Сообщение ElectrostaticMister »

vadimvs писал(а): 21 апр 2021, 15:35 Делал flex отчет по инструкции, ошибки

...
[2021-04-21 15:21:27.717780] WARNING: Cash flow didn't match report {"year":2020,"currency":"USD","mode":"ending","flow":"14008.68","report":"14004.63"}
[2021-04-21 15:21:27.718235] ERROR: CASH didn't match report {"currency":"USD","amount":14008.68,"Report":14004.633807751}
[2021-04-21 15:21:27.718341] ERROR: Total commission didn't match report {"Commissions":-86.881040249,"Report":-90.92619225}
[2021-04-21 15:21:27.718415] ERROR: Transaction tax didn't match report {"TransactionTax":null,"Report":"-4.045152"}
[2021-04-21 15:21:27.718518] ERROR: Some problems in the final report
Надо добавить в отчет секцию Transaction Fees, подсекция Detail, все поля - в сводном отчете есть небольшие комиссии из этой секции, а самой секции видимо нет, поэтому сверка портфеля не сходится.

Аватара пользователя

Автор темы
ElectrostaticMister
Сообщения: 185
Зарегистрирован: 12 май 2020, 23:14

Генератор налоговой декларации из отчетов IB

Сообщение ElectrostaticMister »

vasechka писал(а): 21 апр 2021, 15:48 Привет. Куда донат слать?
Пока не сделаны донаты.


vasechka
Сообщения: 2
Зарегистрирован: 11 апр 2021, 23:28

Генератор налоговой декларации из отчетов IB

Сообщение vasechka »

ElectrostaticMister писал(а): 21 апр 2021, 15:51 Пока не сделаны донаты.
У многих банков (Альфа, Тинек) есть возможность сгенерить ссылку, не афишируя своих реквизитов. Если такое есть - скинь, плз.


vadimvs
Сообщения: 3
Зарегистрирован: 21 апр 2021, 08:44
Контактная информация:

Генератор налоговой декларации из отчетов IB

Сообщение vadimvs »

ElectrostaticMister писал(а): 21 апр 2021, 15:50
vadimvs писал(а): 21 апр 2021, 15:35 Делал flex отчет по инструкции, ошибки

...
[2021-04-21 15:21:27.717780] WARNING: Cash flow didn't match report {"year":2020,"currency":"USD","mode":"ending","flow":"14008.68","report":"14004.63"}
[2021-04-21 15:21:27.718235] ERROR: CASH didn't match report {"currency":"USD","amount":14008.68,"Report":14004.633807751}
[2021-04-21 15:21:27.718341] ERROR: Total commission didn't match report {"Commissions":-86.881040249,"Report":-90.92619225}
[2021-04-21 15:21:27.718415] ERROR: Transaction tax didn't match report {"TransactionTax":null,"Report":"-4.045152"}
[2021-04-21 15:21:27.718518] ERROR: Some problems in the final report
Надо добавить в отчет секцию Transaction Fees, подсекция Detail, все поля - в сводном отчете есть небольшие комиссии из этой секции, а самой секции видимо нет, поэтому сверка портфеля не сходится.
Добрый вечер. Так и не идет отчет. А с Выпиской генерирует.

Аватара пользователя

Автор темы
ElectrostaticMister
Сообщения: 185
Зарегистрирован: 12 май 2020, 23:14

Генератор налоговой декларации из отчетов IB

Сообщение ElectrostaticMister »

vadimvs писал(а): 21 апр 2021, 18:01 Добрый вечер. Так и не идет отчет. А с Выпиской генерирует.
Добавил вам галку Отключить сверку с финальным отчетом в форме, включайте ее при отправке flex-отчета, и генератор будет игнорировать расхождение на эти 4 доллара. Государственные биржевые сборы IB учитывает по непонятным правилам, и по-разному во flex и в выписке, поэтому часто не работает.


vadimvs
Сообщения: 3
Зарегистрирован: 21 апр 2021, 08:44
Контактная информация:

Генератор налоговой декларации из отчетов IB

Сообщение vadimvs »

ElectrostaticMister писал(а): 21 апр 2021, 19:13
vadimvs писал(а): 21 апр 2021, 18:01 Добрый вечер. Так и не идет отчет. А с Выпиской генерирует.
Добавил вам галку Отключить сверку с финальным отчетом в форме, включайте ее при отправке flex-отчета, и генератор будет игнорировать расхождение на эти 4 доллара. Государственные биржевые сборы IB учитывает по непонятным правилам, и по-разному во flex и в выписке, поэтому часто не работает.
Спасибо. Так работает.


guestwalker
Сообщения: 2
Зарегистрирован: 25 апр 2021, 17:22

Генератор налоговой декларации из отчетов IB

Сообщение guestwalker »

Здравствуйте, столкнулся с несколькими ошибками в отчёте

Код: Выделить всё

[2021-04-25 21:46:19.161795] ERROR:Portfolio: Security info doesn't match {"symbol":"FRES","name":"currency","value":"GBP","newValue":"USD"}
при этом по этому тикеру в отчёте действительно странность, бумага торгуется в GBP, и дивы в той же валюте должны приходить, но в flex отчёте IB видим следующее:
Спойлер

Код: Выделить всё

"DATA","FIFO","U1234567","","","STK","FRES","FRESNILLO PLC","51069466","GB00B2QPKJ12","ISIN","","GB00B2QPKJ12","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","","0","0","0","0","0","0","0","
-2696.134572","0","-2696.134572","0","0","-2696.134572","-2696.134572","0",""
"DATA","POST","U1234567","","","GBP","1.3878","STK","FRES","FRESNILLO PLC","51069466","GB00B2QPKJ12","ISIN","","GB00B2QPKJ12","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","2021-04-23","500
","8.934","4467","12.81948","12.81948","6409.74","3.41","-1942.74","Long","SUMMARY","","","","","","",""
"DATA","TRNT","U1234567","","","GBP","1.2809","STK","FRES","FRESNILLO PLC","51069466","GB00B2QPKJ12","ISIN","","GB00B2QPKJ12","LSE","","","","","","1","","","","","2020-09-10","","2020-09-10 09:48:35","","2020-09-10","","","2020-09-14","0.0","","0.0 ()","","100","13.305","1330.5","-1330.5","-6.6525","-6","GBP","-1343.1525","13.325","O","O","1343.1525","0","0","2","","","","","","","BUY","1522450221","","","","","","","2020-09-10 09:48:13","","","","","ORDER","","","LMT","","","0"
"DATA","CDIV","U1234567","","","USD","1","STK","FRES","FRESNILLO PLC","51069466","GB00B2QPKJ12","ISIN","","GB00B2QPKJ12","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","2021-04-22","2021-04-21","2021-04-22","2021-06-01","500","11.75","0","0.235","117.5","105.75","Po","","","DETAIL"
ещё есть вот такая ошибка:

Код: Выделить всё

ERROR:Portfolio: No settle date {"symbol":"TSCO","datetime":"2021-02-12 20:25:00"}
а вот что в отчёте по этому тикеру:
Спойлер
"DATA","FIFO","U1234567","","","STK","TSCO","TESCO PLC","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","","0","0","-1114.209547119","0","0","-1114.209547119","0","0","0","0","0","0","0","-1114.209547119","0",""
"DATA","TRNT","U1234567","","","GBP","1.3742","STK","TSCO","TESCO PLC","909281","GB0008847096","ISIN","","GB0008847096","LSE","","","","","","1","","","","","2021-02-08","","2021-02-08 09:25:49","","2021-02-08","","","2021-02-10","0.0","","0.0 ()","","1200","2.459","2950.8","-2950.8","-14.754","-6","GBP","-2971.554","2.438","O","O","2971.554","0","0","-25.2","","","","","","","BUY","1730618279","","","","","","","2021-02-08 09:25:49","","","","","ORDER","","","LMT","","","0"
"DATA","TRNT","U1234567","","","GBP","1.3742","STK","TSCO","TESCO PLC","909281","GB0008847096","ISIN","","GB0008847096","LSE","","","","","","1","","","3471755225","","2021-02-08","","2021-02-08 09:25:49","","2021-02-08","","","2021-02-10","0.0","ExchTrade","0.0 ()","EUDARK","1200","2.459","2950.8","-2950.8","-14.754","-6","GBP","-2971.554","2.438","O","","2971.554","0","0","-25.2","0","","","0","","15249950637","BUY","1730618279","00010993.6020e4ec.01.01","006a8381.0001731b.6020cf10.0001","","","N/A","HRSI-PR_12487902775","2021-02-08 09:25:49","","","","","EXECUTION","0","0","LMT","","N","0"
"DATA","TRNT","U1234567","","","GBP","1.3864","STK","TSCO","TESCO PLC","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","","","2021-02-17","","2021-02-12 20:25:00","","2021-02-17","","","","0.0","","0.0 ()","","0.3684","3.0476","1.12273584","-1.12273584","0","0","GBP","-1.12273584","2.3765","-","Ca","1.12273584","0","0","-0.2472","","","","","","","BUY","15380952613","","","","","","","","","","","","ORDER","","","","","","0"
"DATA","TRNT","U1234567","","","GBP","1.3864","STK","TSCO","TESCO PLC","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","","","2021-02-17","","2021-02-12 20:25:00","","2021-02-17","","","","0.0","FracShareCancel","0.0 ()","--","0.3684","3.0476","1.12273584","-1.12273584","0","0","GBP","-1.12273584","2.3765","","Ca","1.12273584","0","0","-0.2472","0","","","0","","15380952613","SELL (Ca.)","15380952613","","","","","N/A","N/A","","","","","","EXECUTION","0","0","","","N","0"
"DATA","TRNT","U1234567","","","GBP","1.3864","STK","TSCO","TESCO PLC","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","","","2021-02-17","","2021-02-12 20:25:00","","2021-02-17","","","","0.0","","0.0 ()","","-0.3684","2.4495","-0.9023958","0.9023958","0","0","GBP","0.9023958","2.3765","C","C","-1.155538","-0.253143","0","0.0269","","","","","","","SELL","15380952616","","","","","","","","","","","","ORDER","","","","","","0"
"DATA","TRNT","U1234567","","","GBP","1.3864","STK","TSCO","TESCO PLC","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","","","2021-02-17","","2021-02-12 20:25:00","","2021-02-17","","","","0.0","FracShare","0.0 ()","--","-0.3684","2.4495","-0.9023958","0.9023958","0","0","GBP","0.9023958","2.3765","C","","-1.155538","-0.253143","0","0.0269","0","","","0","","15380952616","SELL","15380952616","","","","","N/A","N/A","","","","","","EXECUTION","0","0","","","N","0"
"DATA","TRNT","U1234567","","","GBP","1.3741","STK","TSCO","TESCO PLC","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","","","2021-03-30","","2021-03-30 03:00:04","","2021-03-30","","","2021-04-01","0.0","","0.0 ()","","-947","2.287","-2165.789","2165.789","0","-6","GBP","2159.789","2.299","C","C","-2970.398462","-810.609462","0","-11.364","","","","","","","SELL","1836072403","","","","","","","2021-03-29 11:31:42","","","","","ORDER","","","LMT","","","0"
"DATA","TRNT","U1234567","","","GBP","1.3741","STK","TSCO","TESCO PLC","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","3658274516","","2021-03-30","","2021-03-30 03:00:04","","2021-03-30","","","2021-04-01","0.0","ExchTrade","0.0 ()","LSE","-947","2.287","-2165.789","2165.789","0","-6","GBP","2159.789","2.299","C","","-2970.398462","-810.609462","0","-11.364","0","","","0","","15931984697","SELL","1836072403","0001609a.6062bb88.01.01","006a8381.0001731b.60615c3f.0001","","","N/A","287662493663330/S","2021-03-29 11:31:42","","","","","EXECUTION","0","0","LMT","","N","0"
"DATA","TRNT","U1234567","","","GBP","1.3903","STK","TSCO.NEW","TESCO PLC","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","","","2021-02-15","","2021-02-12 20:25:00","","2021-02-12","","","","0.0","","0.0 ()","","-0.3684","3.0476","-1.12273584","1.12273584","0","0","GBP","1.12273584","2.4435","O","O","-1.12273584","0","0","0.2226","","","","","","","SELL","15348246386","","","","","","","","","","","","ORDER","","","","","","0"
"DATA","TRNT","U1234567","","","GBP","1.3903","STK","TSCO.NEW","TESCO PLC","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","","","2021-02-15","","2021-02-12 20:25:00","","2021-02-12","","","","0.0","FracShare","0.0 ()","--","-0.3684","3.0476","-1.12273584","1.12273584","0","0","GBP","1.12273584","2.4435","O","","-1.12273584","0","0","0.2226","0","","","0","","15348246386","SELL","15348246386","","","","","N/A","N/A","","","","","","EXECUTION","0","0","","","N","0"
"DATA","TRTX","U1234567","","","GBP","1.3742","STK","TSCO","TESCO PLC","909281","GB0008847096","ISIN","","GB0008847096","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","2021-02-08 09:25:49","UK Stamp Tax","1200","2021-02-08","-14.754","3471755225","2.4590","TRADE","","DETAIL"
"DATA","CORP","U1234567","","","GBP","1.3903","STK","TSCO","TSCO(GB0008847096) SPLIT 15 FOR 19 (TSCO, TESCO PLC, GB0008847096)","909281","GB0008847096","ISIN","","GB0008847096","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","2021-02-15","2021-02-12 20:25:00","TSCO(GB0008847096) SPLIT 15 FOR 19 (TSCO, TESCO PLC, GB0008847096)","0","0","0","-1200","0","0","","RS","15348235769","DETAIL"
"DATA","CORP","U1234567","","","GBP","1.3903","STK","TSCO.NEW","TSCO(GB0008847096) SPLIT 15 FOR 19 (TSCO.NEW, TESCO PLC, GB00BLGZ9862)","471204140","GB00BLGZ9862","ISIN","","GB00BLGZ9862","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","2021-02-15","2021-02-12 20:25:00","TSCO(GB0008847096) SPLIT 15 FOR 19 (TSCO.NEW, TESCO PLC, GB00BLGZ9862)","0","0","0","947.3684","0","0","","RS","15348235768","DETAIL"
"DATA","CTRN","U1234567","","","GBP","1.3925","STK","TSCO.OLD","TSCO(GB0008847096) CASH DIVIDEND GBP 0.5093 PER SHARE (Bonus Dividend)","909281","GB0008847096","ISIN","","GB0008847096","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","2021-02-26 20:20:00","2021-02-26","608.61","Dividends","","","15551829929","2021-03-01","","DETAIL"
"DATA","CTRN","U1234567","","","GBP","1.3925","STK","TSCO.OLD","TSCO(GB0008847096) PAYMENT IN LIEU OF DIVIDEND (Bonus Dividend)","909281","GB0008847096","ISIN","","GB0008847096","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","2021-02-26 20:20:00","2021-02-26","2.55","Payment In Lieu Of Dividends","","","15551829928","2021-03-01","","DETAIL"
"DATA","CDIV","U1234567","","","GBP","1.3974","STK","TSCO.OLD","TESCO PLC","909281","GB0008847096","ISIN","","GB0008847096","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","2021-02-18","2021-02-12","2021-02-15","2021-02-26","1200","0","0","0.5093","611.16","611.16","Po","","","DETAIL"
"DATA","CDIV","U1234567","","","GBP","1.3925","STK","TSCO.OLD","TESCO PLC","909281","GB0008847096","ISIN","","GB0008847096","LSE","","","","","","1","","","","","","","","0.0","0.0 ()","2021-03-01","2021-02-26","2021-02-15","2021-02-26","1200","0","0","0.5093","-611.16","-611.16","Re","","","DETAIL"

Ответить