Skip to content

Instantly share code, notes, and snippets.

Avatar
💭
howdy 😁

Jan Jůna junajan

💭
howdy 😁
View GitHub Profile
View sandy_2020-2022.tsv
Ticker Amnt (scale) Open date O. Price Close date C. Price Profit/Loss
MRK 85 (1) Jul 20, 2022 $7,626.78 ($89.73) Jul 25, 2022 $7,697.87 ($90.56) $71.09 | 0.93%
LMT 59 (2) Jul 15, 2022 $23,061.82 ($390.88) Jul 20, 2022 $23,312.85 ($395.13) $251.03 | 1.09%
PM 818 (4) Jun 30, 2022 $78,088.05 ($95.46) Jul 19, 2022 $74,675.30 ($91.29) ($3,412.75) | -4.37%
JNJ 44 (1) Jul 12, 2022 $7,731.19 ($175.71) Jul 15, 2022 $7,832.76 ($178.02) $101.57 | 1.31%
T 1143 (2) Jul 11, 2022 $23,566.69 ($20.62) Jul 15, 2022 $23,504.77 ($20.56) ($61.92) | -0.26%
BMY 624 (3) Jul 5, 2022 $46,926.20 ($75.20) Jul 15, 2022 $47,132.84 ($75.53) $206.64 | 0.44%
COP 510 (3) Jun 17, 2022 $46,155.41 ($90.50) Jun 28, 2022 $48,522.06 ($95.14) $2,366.65 | 5.13%
SO 345 (2) Jun 10, 2022 $23,316.02 ($67.58) Jun 21, 2022 $23,197.87 ($67.24) ($118.15) | -0.51%
ALL 381 (3) Jun 9, 2022 $46,970.34 ($123.28) Jun 21, 2022 $46,385.95 ($121.75) ($584.39) | -1.24%
@junajan
junajan / ib_migration.md
Created October 6, 2022 16:26
IBCE to IBIE Migration guide
View ib_migration.md

Dear Mr. ..., Thank you for contacting Interactive Brokers Customer Service. If you would like to have an account with IBIE rather than an IBCE account, you can initiate a new account opening on our website. When you initiate the opening process, please specify a Western European country (e.g. Germany) as legal residence so the application can trigger IBIE as the governing entity of your account. Once you proceed further with the application and reach the tax details part, please contact us via ticket so we can change the account details manually and finish up the setup. Once your new account is opened, you can request a full manual transfer from your current account in the following way:

  1. Log into Client Portal
  2. Click to the User menu (head and shoulders icon) in the top right corner, followed by Secure Message Center
  3. Click to Compose, then click to create new to submit a new web ticket
  4. Select Funds & Banking as the category and Other Deposits and Withdrawals as the topic
View bitstamp-aggregate-tick-data.js
const _ = require('lodash')
const moment = require('moment')
const fse = require('fs-extra')
const csv = require('fast-csv')
const path = require('path')
const FILENAME = 'bitstampUSD.csv';
var outputStream = csv.createWriteStream();
View 90tka_june_trades.tsv
# Ticker Amnt (pieces) Open date O. Price Close date C. Price Profit/Loss
1141 NEE 27 (1) Jun 19, 2020 $6,589.81 ($244.07) $6,670.08 ($247.04) $80.27 | 1.22%
1140 LLY 47 (1) Jun 15, 2020 $6,643.98 ($141.36) Jun 16, 2020 $7,695.25 ($163.73) $1,051.27 | 15.82%
1139 TGT 57 (1) Jun 12, 2020 $6,670.50 ($117.03) Jun 16, 2020 $6,787.13 ($119.07) $116.63 | 1.75%
1138 WMT 227 (4) Jun 12, 2020 $26,755.22 ($117.86) Jun 16, 2020 $27,094.31 ($119.36) $339.09 | 1.27%
1136 WMT 165 (3) Jun 8, 2020 $19,970.96 ($121.04) Jun 16, 2020 $19,694.10 ($119.36) ($276.85) | -1.39%
1135 WMT 109 (2) Jun 5, 2020 $13,246.64 ($121.53) Jun 16, 2020 $13,010.04 ($119.36) ($236.60) | -1.79%
1134 WMT 54 (1) Jun 4, 2020 $6,589.33 ($122.02) Jun 16, 2020 $6,445.34 ($119.36) ($143.99) | -2.19%
1137 LLY 44 (1) Jun 8, 2020 $6,556.12 ($149.00) Jun 10, 2020 $6,645.64 ($151.04) $89.52 | 1.37%
1133 BMY 283 (3) May 29, 2020 $16,929.65 ($59.82) Jun 1, 2020 $17,053.83 ($60.26) $124.18 | 0.73%
View investice.md
View 90tka_pre_corona_trades.tsv
# Ticker Amnt (pieces) Open date O. Price Close date C. Price Profit/Loss
1110 NEE 132 (4) Mar 16, 2020 $26,540.92 ($201.07) Mar 17, 2020 $28,995.12 ($219.66) $2,454.20 | 9.25%
1106 NEE 87 (3) Mar 12, 2020 $18,221.41 ($209.44) Mar 17, 2020 $19,110.42 ($219.66) $889.01 | 4.88%
1104 NEE 50 (2) Mar 11, 2020 $12,054.50 ($241.09) Mar 17, 2020 $10,983.00 ($219.66) ($1,071.50) | -8.89%
1103 NEE 23 (1) Mar 10, 2020 $5,856.57 ($254.63) Mar 17, 2020 $5,052.18 ($219.66) ($804.39) | -13.73%
1108 AGN 34 (1) Mar 12, 2020 $5,963.58 ($175.40) Mar 13, 2020 $6,158.42 ($181.13) $194.84 | 3.27%
1109 MSFT 88 (2) Mar 12, 2020 $12,247.96 ($139.18) Mar 13, 2020 $13,035.44 ($148.13) $787.48 | 6.43%
1107 BMY 230 (2) Mar 12, 2020 $12,236.00 ($53.20) Mar 13, 2020 $12,675.30 ($55.11) $439.30 | 3.59%
1105 BMY 107 (1) Mar 11, 2020 $6,059.41 ($56.63) Mar 13, 2020 $5,896.77 ($55.11) ($162.64) | -2.68%
1102 MSFT 40 (1) Mar 9, 2020 $6,042.89 ($151.07) Mar 13, 2020 $5,925.20 ($148.13) ($117.69) | -1.95%
View mysql-wrapper-class.php
<?php
/*
#
# Trida zajistujici praci s databazi.
# Pokud se planuje pouziti jine databaze, pak je nutne vytvorit kopii teto tridy s prikazi pro zvolenou
# databazi, ulozit ji pod nazvem_databaze.class.php
#
*/
class MySQL {
View flatten.js
const arr = [{
values: [1, 2]
}, {
values: [3, 4]
}];
const c = arr
.map((obj) => obj.values)
.reduce(((all, arr) => [...all, ...arr]), []);
View 90tka_trades_simple_oct_nov_dec.tsv
# Ticker Amnt (pieces) Open date O. Price Close date C. Price Profit/Loss
846 MDT 125 (2) Dec 26, 2018 $11,072.25 ($88.58) Dec 27, 2018 $11,176.65 ($89.41) $104.40 | 0.94%
844 MDT 66 (1) Dec 17, 2018 $6,072.34 ($92.01) Dec 27, 2018 $5,901.27 ($89.41) ($171.07) | -2.82%
843 WMT 133 (2) Dec 17, 2018 $12,066.76 ($90.73) Dec 26, 2018 $12,011.88 ($90.31) ($54.88) | -0.45%
842 WMT 65 (1) Dec 14, 2018 $5,968.00 ($91.82) Dec 26, 2018 $5,870.47 ($90.31) ($97.53) | -1.63%
837 USB 474 (4) Dec 10, 2018 $24,004.36 ($50.64) Dec 26, 2018 $21,471.82 ($45.30) ($2,532.53) | -10.55%
833 USB 346 (3) Dec 7, 2018 $17,937.64 ($51.84) Dec 26, 2018 $15,673.52 ($45.30) ($2,264.12) | -12.62%
831 USB 228 (2) Dec 6, 2018 $11,934.52 ($52.34) Dec 26, 2018 $10,328.22 ($45.30) ($1,606.31) | -13.46%
830 USB 113 (1) Dec 4, 2018 $5,951.57 ($52.67) Dec 26, 2018 $5,118.81 ($45.30) ($832.76) | -13.99%
845 UNP 130 (3) Dec 17, 2018 $18,172.00 ($139.78) Dec 26, 2018 $17,672.04 ($135.94) ($499.95) | -2.75%
View stocks_over_sma200.tsv
Ticker Name Sector Exchange Health
ABT Abbott Laboratories Health Care NYSE +
AMGN Amgen Inc. Health Care NASDAQ +
EXC Exelon Utilities NYSE +
FOXA Twenty-First Century Fox, Inc Consumer Discretionary NASDAQ +
KO The Coca-Cola Company Consumer Staples NYSE +
LLY Eli Lilly and Company Health Care NYSE +
MCD McDonald's Corp Consumer Discretionary NYSE +
MDT Medtronic Inc. Health Care NYSE +
MRK Merck & Co. Health Care NYSE +