-
Notifications
You must be signed in to change notification settings - Fork 0
/
definitions.py
520 lines (487 loc) · 39.2 KB
/
definitions.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
#!/usr/bin/env python
from __future__ import print_function
from __future__ import absolute_import
# this file is used by almost all of the scripts.
# see updateHistoryStockwatch.py for info on some of the lists stored here
# a lot of history in this script .. interfaces that I tried and later abandoned
# stockwatch has become the best place to get your US and Canadian stock and mutual fund data
# its not free but its also cheap ,reliable and up to date.
class definitions:
import sys
ClassPathNames = [ # these items get executed by both the console extensions jconsole270 and jython270 when they are started
"sys.path.append(r'/opt/moneydance/scripts/jython270/')", # location of console.py file only needed for the Jython270 console extension
# "sys.path.append(r'/home/wayne/source/jython2.7.0/jython.jar')",#location of the jython jar file (this is linked to one of the moneydance/jre/ext ,so its not required now )
# "sys.path.append(r'/home/wayne/source/jython2.7.0/Lib/')", # os.py lives here ( done with a link to moneydance/jre/ext now, so not required )
# "sys.path.append(r'/home/wayne/source/jython2.7.0/Lib/site-packages')", # nothing in here
# "sys.path.append(r'/opt/moneydance/jre/lib/ext/sqlite-jdbc.jar')", #
"sys.path.append(r'/opt/moneydance/scripts/')", # custom scripts live here ... needed for import custom.py files to load
"import os",
"os.chdir('/opt/moneydance/scripts')", # change the cwd. the jython execfile("custom.py") uses this as its default directory
# "import java",
# "java.lang.System.setProperty('java.library.path','/opt/moneydance/jre/lib/amd64')",
# "try:\n execfile('StockGlance75.py')\nexcept:\n sys.stderr.write('Jython failed to load StockGlance75.py\\n')\n", # fire up STockGlance doesn't work
# "try:\n execfile('sitecustomize.py')\nexcept:\n sys.stderr.write('Jython found no sitecustomize.py\\n')\n", # run the sitecustomize.py file if it exists
"try:\n execfile('runScripts.py')\nexcept:\n sys.stderr.write('Jython failed to load runScripts.py\\n')\n", # fire up the script picker swing GUI
"del buff"
]
directory = "/opt/moneydance/scripts/tmp/" #set this to the directory where you want the temporary files stored.
# remember to create the directory /opt/moneydance/scripts/tmp/
# should also create /opt/moneydance/scripts/tmp/Done
# should also create /opt/moneydance/scripts/tmp/Stockwatch for updateHistoryStockwatch.py..Note:all csv files placed here are processed and moved to tmp/Done
# should also create /opt/moneydance/scripts/tmp/StockwatchDay for updateDaylyStockwatch.py..Note:all csv files placed here are processed and moved to tmp/Done
# should also create /opt/moneydance/scripts/tmp/TMX for updateTMX.py need to create a TMX portfolio and save its csv file export here.
# should also create /opt/moneydance/scripts/tmp/ScotiaBank for Investment account csv file imports.
# should also create /opt/moneydance/scripts/tmp/BMO for Investment account csv file imports.
# the two structures below are used by the Globe and Mail Canadian mutual fund price update scripts
# update this list with your mutual fund info . quotes and commas are important .
# both the fund symbol(TML202) and the id (53895) need to be changed. They both can be found on www.globeandmail.com
# the symbols must match what has been entered in moneydance as the ticker symbol
# the globe and mail are busy rebuilding their web site so expect more changes ..
# see globeinvestor.com , globefunddb , http://gold.globeinvestor.com/generated/hubs/home.html
# also https://globeandmail.happyfox.com
# https://secure.globeadvisor.com/
#the globe and mail links below are broken ... Globe has a new web site
# could be revived by rewrite of fetchhtml but its simpler to use the GlobeInvestor history version which still works (or stockwatch)
# used by fetchhtml.py to get todays canadian mutual fund price from the GlobeInvestor web site
# FindFund = {
# 'TML202': 'https://www.theglobeandmail.com/investing/markets/funds/TML202.CF/', #worked
# 'MFC738': 'https://www.quicken.com/investing/mutual-funds/MUTUAL%3AMFC738/Cundill-Canadian-Security-Fund-Series-C', #failed
# 'BIP151': 'http://quote.morningstar.ca/quicktakes/Fund/f_ca.aspx?t=0P000072C0®ion=CAN&culture=en-CA', #failed
# 'BIP151': 'https://www.theglobeandmail.com/investing/markets/watchlist/', #failed
# 'FID281': 'https://marketsandresearch.td.com/tdwca/Public/MutualFundsProfile/PerformanceAndRisk/ca/FID281', #worked
# 'BMO471': 'https://ycharts.com/mutual_funds/M:BMO471.TO', #worked
# 'GOC309': 'https://ycharts.com/mutual_funds/M:GOC309.TO/holdings', #worked
# 'BNS344': 'https://www.msn.com/en-ca/money/funddetails/fi-F0CAN05NUM' #worked
# 'BNS744': 'http://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=68435',
# 'BNS361': 'http://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=18254',
# 'BNS741': 'http://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=68432',
# 'BMO146': 'http://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=17696'
# }
# used by fetchhhtmlHistory.py to get historical prices of a canadian mutual fund from the globefunddb web site
#these links still work but the id number is a little harder to find
# https://www.theglobeandmail.com/investing/markets/funds/TML202.CF/performance ..three months of price data from barchart
# the corporate actions button of this page pulls up years of dividend history.
# https://secure.globeadvisor.com/
# http://portfoliodb.theglobeandmail.com/gishome/plsql/port_gaf.login
# http://gold.globeinvestor.com/ seems broken
#/www.globefund.com/v5/ ? what is this
# http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_filter?pi_type=B .........use this to find the fund id .. its dead now
# http://globefunddb.theglobeandmail.com/gishome/plsql/gis.analyser . is still working you can get the id with it too
# once you find your fund click on the info table . the id is in the url as pi_fund_id=98881
# plug this number into the queery below and you'll get the last 30 days prices
# FundTables = {
# 'TML202':'https://www.theglobeandmail.com/investing/markets/funds/TML202.CF/performance', # this failed (barchart)
# 'TML202-T':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=53895',
# 'MFC738-T':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=51396',
# 'BIP151-T':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=56107',
# 'FID281-T':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=60075',
# 'BMO471-T':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=94801',
# 'GOC309-T':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=38663',
# 'BNS344-T':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=57442'
# 'BNS744':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=68435',
# 'BNS361':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=18254',
# 'BNS741':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=68432',
# 'BMO146':'http://globefunddb.theglobeandmail.com/gishome/plsql/gis.price_history?pi_fund_id=17696'
# }
# just list the symbols that are not on the TSX
# used by BMO-Inv-new.py and Scotia-Inv-new.py
SymbolTable = {
'KMB-T':'KMB-N', # Kimberly Clark is on the New York Exchange
'MHYB-T':'MHYB-NEO',
'VST-T':'VST-N', # Vista Energy Corp
'FCD-UN-T':'FCD-UN-X' # the venture exchange
}
# info from stockwatch site ->US mutual fund data is received from the Nasdaq feed,
# therefore the symbols conform to the Nasdaq standard.
# Each fund has a five letter symbol of which the last letter is always X. The exchange code is Q.
# Canadian mutual fund Symbols
# info from stockwatch->Canadian mutual fund symbols are of the form GGG*FFF where GGG represents the fund group, and FFF represents the specific fund.
# the list below is the result of different companies using different symbols for the Canadian mutual funds.
# example TML202 (Fundserv Code) = BIF*CDN (Stockwatch) = id=53895 (GlobeInvestor)
# TML202 is recognized by many web sites but BIF*CDN seems to be only used by stockwatch
# used by updateHistoryStockwatch.py and updateDaylyStockwatch.py to look up the fundserv ticker symbol given the name used by www.stockwatch.com
StockwatchSymbols = { #mutual funds only.. used by updateHistoryStockwatch.py and updateDaylyStockwatch.py
'TML202-T':'BIF*CDN',
'MFC738-T':'CUN*SSC',
'BIP151-T':'BRN*GLO', # :'MUTF_CA:BIP151', this is how google is handling it https://finance.google.ca/finance?q=MUTF_CA:BIP151
'FID281-T':'FSB*CAA',
'BNS744-T':'BNA*SAG',
'BNS361-T':'BNS*MOR',
'BNS741-T':'BNA*SIG',
'BNS357-T':'BNS*MMF',
'BMO146-T':'BOM*DIV',
'BMO471-T':'BME*TFP',
'GOC309-T':'Canoe Canadian Asset Allocation Class-Z' # missing from stockwatch looks like stockwatch makes up their own names for Canadian mutual funds
}
# Currency Exchange Rates to Canadian Dollars
StockwatchIndexs = { # used for exchange rate update. used by updateDaylyStockwatch.py
'AUD':'FX$AUD/CAD', # Australia $
'BGN':'FX$BGN/CAD', #? Bulgarian Lev
'BMD':'FX$BMD/CAD', # Bermudian $
'BRL':'FX$BRL/CAD', # Brazilian Real
'BSD':'FX$BSD/CAD', # Bahamian $
'CHF':'FX$CHF/CAD', # Swiss Franc
'CLP':'FX$CLP/CAD', # Chilean Pesos
'CNH':'FX$CNY/CAD', # Chinese YUAN Renminbi
'CRC':'FX$CRC/CAD', # Costa Rica Colon
'DKK':'FX$DKK/CAD', # Danish Krone
'EGP':'FX$EGP/CAD', # Egyption Pound
'EUR':'FX$EUR/CAD', # Euro
'FJD':'FX$FJD/CAD', # Fijian Dollar
'GBP':'FX$GBP/CAD', # British Pound
'HKD':'FX$HKD/CAD', # Hong Kong $
'IDR':'FX$IDR/CAD', # Indonesian Rupiah
'ILS':'FX$ILS/CAD', # Israeli New Shekel
'INR':'FX$INR/CAD', # Indian Rupee
'ISK':'FX$ISK/CAD', # Icelandic Krona
'JMD':'FX$JMD/CAD', # Jamaican Dollar
'JOD':'FX$JOD/CAD', # Jordonian Dollar
'JPY':'FX$JPY/CAD', # Japan YEN * 100 looks wrong but FX$CAD/JPY looks right
'KPW':'FX$KPW/CAD', # North Korean Won
'KRW':'FX$KRW/CAD', # South Korean Won
'LBP':'FX$LBP/CAD', # Lebanese Pound
'MYR':'FX$MYR/CAD', # Malaysian Ringgit
'MXN':'FX$MXN/CAD', # Mexican Pesos
'NOK':'FX$NOK/CAD', # Norwegian Kroner
'NZD':'FX$NZD/CAD', # New Zealand $
'PHP':'FX$PHP/CAD', # Philippines Peso
'PKR':'FX$PKR/CAD', # Pakistani Rupee
'RON':'FX$RON/CAD', # Romanian Leu
'SAR':'FX$SAR/CAD', # Saudi Arabian Riyal
'SDG':'FX$SDG/CAD', # Sudan Pound
'SGD':'FX$SGD/CAD', # Singapore Dollars
'SEK':'FX$SEK/CAD', # Swedish Krona
'THB':'FX$THB/CAD', # Thai Baht
'TRY':'FX$TRY/CAD', # Turkish Lira
'TTD':'FX$TTD/CAD', # Trinidad and Tobago Dollar
'TWD':'FX$TWD/CAD', # Taiwan Dollars
'USD':'FX$USD/CAD', # US $
'VEF':'FX$VEF/CAD', # Venezuelan Bolivar
'ZAR':'FX$ZAR/CAD', # South African RAND
'ZMW':'FX$ZMW/CAD' # Zambian Kwacha
}
# the Yahoo financial interface is gone...
# but https://ca.finance.yahoo.com/quote/PKI.TO?p=PKI.TO&.tsrc=fin-srch may work to get quotes
# the interface moved to Alphavantage now .. Finding Canadian Mutual Funds on either of these databases (Yahoo or Alphavantage) is very difficult so this dictionary is no longer used.
# YahooSymbols = {
# 'TML202':'F0CAN05OKY.TO',
# 'MFC738':'F0CAN05LW6.TO',
# 'BIP151':'F0CAN05NZE.TO',
# 'FID281':'F0CAN05TEZ.TO',
# 'BNS744':'F0CAN07204.TO',
# 'BNS361':'SCOTIAMORTGA.TO',
# 'BNS741':'F0CAN07205.TO',
# 'BNS357':'SCOTIAMONEYM.TO',
# 'BMO146':'BMODIVIDEND.TO',
# 'BMO471':'F00000QVBL.TO',
# 'GOC309':'Canoe Canadian Asset Allocation Class-Z' # missing from Yahoo ,Alphavantage and Stockwatch. Globeinvestor has it.
# }
# tried to get quotes from these sites but they didn't work
# https://web.tmxmoney.com/quote.php?qm_symbol=BR
# https://web.tmxmoney.com/pricehistory.php?qm_symbol=BR
# https://www.stockwatch.com/Quote/Detail.aspx?symbol=PKI®ion=C # this works ... not sure why it didn't work before . has date time and everything you need.
# http://www.quotemedia.com/portal/quote?qm_symbol=TML202%3ACA&searchBySymbol=symbol
# https://www.aequitasneo.com/en/single-security/MHYB this works if typed into the NEO exchange . looks like all the TSX symbols do
# NEO must be detecting my browser type
# 'MHYB-NEO':'https://www.aequitasneo.com/en/single-security/MHYB', # failed
# 'MHYB-NEO':'https://www.aequitasneo.com/en/connect/fund-directory', # failed too NEO sucks
# 'MHYB-NEO':'https://www.theglobeandmail.com/investing/markets/stocks/MHYB-T/', # failed globe and mail doesn't have NEO
# # MUTF:FPBFX this is what an american mutual fund looks like on google finance
# these Google queries still work Nov 22 2018 .. not the mutual funds or MHYB .. google seems to be getting out of Canadian Stock Markets..
# used by Stocks-fetchhtml-Google.py , Stock-html2csv-Google.py , Stock-update.py , Stock-up.py
# StockPriceHistoryGoogle = {
# 'TML202':'https://finance.google.ca/finance?q=MUTF_CA:TML202', # the canadian mutual fund data on Google is older than Globeinvestor
# 'MFC738':'https://finance.google.ca/finance?q=MUTF_CA:MFC738', # so should stick to GlobeInvestor or Stockwatch for Canadian Mutual Fund data
# 'BIP151':'https://finance.google.ca/finance?q=MUTF_CA:BIP151', # the price and data info was in the html file but it was old
# 'FID281':'https://finance.google.ca/finance?q=MUTF_CA:FID281',
# 'BNS744':'https://finance.google.ca/finance/historical?q=MUTF_CA:BNS744', # had a nice table of values but was two days old.
# 'BNS361':'https://finance.google.ca/finance?q=MUTF_CA:BNS361',
# 'BNS741':'https://finance.google.ca/finance?q=MUTF_CA:BNS741',
# 'BNS357':'https://finance.google.ca/finance?q=MUTF_CA:BNS357',
# 'BMO471':'https://finance.google.ca/finance?q=MUTF_CA:BMO471',
# 'GOC309':'https://finance.google.ca/finance?q=MUTF_CA:GOC309',
# 'BR-T':'https://finance.google.ca/finance?q=TSE:BR', # # Big Rock on TSX
# 'PKI-T':'https://finance.google.ca/finance?q=TSE:PKI', # Parkland Fuel TSX
# 'MID-UN-T':'https://finance.google.ca/finance?q=TSE:MID-UN', # Mint Income TSX
# 'GWO-PR-S-T':'https://finance.google.ca/finance?q=TSE:GWO-S', # Great West Life TSX
# 'CIQ-UN-T':'https://finance.google.ca/finance?q=TSE:CIQ-UN', # Canadian Hi Income TSX
# 'CU-PR-F-T':'https://finance.google.ca/finance?q=TSE:CU-F', # Canadian Utility TSX
# 'BPF-UN-T':'https://finance.google.ca/finance?q=TSE:BPF-UN', # Boston Pizza TSX
# 'RBN-UN-T':'https://finance.google.ca/finance?q=TSE:RBN-UN', # Blue Ribbon TSX
# 'KMB-N':'https://finance.google.ca/finance?q=NYSE:KMB' # Kimberly Clark on New York Exchange
# }
# list below is used to get the current (real time) price of a stock from GlobeInvestor
# the date is now in the html page and the quote is in real time.
# is hideing the historical data however /performance/ should have shown it.
# you can use your watchlist to find the stock tickers.
# was used by Stock-fetchhtml-Globe-Investor.py , Stock-html2csv-Globe-Investor.py to create Stock-Results.csv for Stock-update.py
# now only used by fetchhtml-Globe-Performance.py and txt2csv-Globe-Performance.py
# this table controls how many symbols are pulled down from globe investor. each one has around 3 months of closing prices
# so a lot of data is generated . Libre Office Calc is started to give you an opportunity to trim the data before it is
# fed to moneydance . make sure no historical screen is displayed in moneydance when you feed the data to moneydance.
# above seems to be fixed in MD2019
# you can run uphst-Globe-Performance.py to import the data into moneydance.
# I don't use this anymore and consider it to be a backup to the stockwatch scripts.
# these scripts use the selenium.webdriver under python instead of jython making the screen scrapping very clean.
StockPriceHistoryGlobeInvestor = {
# 'BR-T':'https://www.theglobeandmail.com/investing/markets/stocks/BR-T/', # Big Rock on TSX
# 'PKI-T':'https://www.theglobeandmail.com/investing/markets/stocks/PKI-T/', # Parkland Fuel TSX
# 'VST-N':'https://www.theglobeandmail.com/investing/markets/stocks/VST-N/', # Vista Energy
'ALA-T':'https://www.theglobeandmail.com/investing/markets/stocks/ALA-T/', # AltaGas Ltd
# 'MID-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/MID-UN-T/', # Mint Income TSX
# 'GWO-PR-S-T':'https://www.theglobeandmail.com/investing/markets/stocks/GWO-PR-S-T/', # Great West Life TSX
# 'CIQ-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/CIQ-UN-T/', # Canadian Hi Income TSX
# 'CU-PR-F-T':'https://www.theglobeandmail.com/investing/markets/stocks/CU-PR-F-T/', # Canadian Utility TSX
# 'BPF-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/BPF-UN-T/', # Boston Pizza TSX
# 'RBN-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/RBN-UN-T/', # Blue Ribbon TSX
# 'KMB-N':'https://www.theglobeandmail.com/investing/markets/stocks/KMB-N/', # Kimberly Clark on New York Exchange
# 'BNE-T':'https://www.theglobeandmail.com/investing/markets/stocks/BNE-T/',
# 'DR-T':'https://www.theglobeandmail.com/investing/markets/stocks/DR-T/',
# 'EIT-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/EIT-UN-T/',
# 'FCD-UN-X':'https://www.theglobeandmail.com/investing/markets/stocks/FCD-UN-X/',
# 'FFI-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/FFI-UN-T/',
# 'FIG-T':'https://www.theglobeandmail.com/investing/markets/stocks/FIG-T/',
# 'HHL-T':'https://www.theglobeandmail.com/investing/markets/stocks/HHL-T/',
# 'IDR-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/IDR-UN-T/',
# 'INC-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/INC-UN-T/',
# 'JE-T':'https://www.theglobeandmail.com/investing/markets/stocks/JE-T/',
# 'KWH-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/KWH-UN-T/',
# 'MFR-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/MFR-UN-T/',
# 'MFT-T':'https://www.theglobeandmail.com/investing/markets/stocks/MFT-T/',
# 'MHYB-NEO':'https://www.theglobeandmail.com/investing/markets/stocks/MHYB-NE/', # globe and mail has NEO too NE is the NEO exchange.
# 'MID-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/MID-UN-T/',
# 'MUB-T':'https://www.theglobeandmail.com/investing/markets/stocks/MUB-T/',
# 'PGI-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/PGI-UN-T/',
# 'UTE-UN-T':'https://www.theglobeandmail.com/investing/markets/stocks/UTE-UN-T/',
# 'TML202-T': 'https://www.theglobeandmail.com/investing/markets/funds/TML202.CF/', # mutual funds work too
# 'MFC738-T': 'https://www.theglobeandmail.com/investing/markets/funds/MFC738.CF/',
# 'BIP151-T': 'https://www.theglobeandmail.com/investing/markets/funds/BIP151.CF/',
# 'FID281-T': 'https://www.theglobeandmail.com/investing/markets/funds/FID281.CF/',
# 'BMO471-T': 'https://www.theglobeandmail.com/investing/markets/funds/BMO471.CF/',
# 'GOC309-T': 'https://www.theglobeandmail.com/investing/markets/funds/GOC309.CF/',
# 'BNS344-T': 'https://www.theglobeandmail.com/investing/markets/funds/BNS344.CF/'
}
# I've switched to stockwatch it does NEO and has date/time.
# Does Canadian Mutual Funds and Stocks. Has USA stocks and funds too.
# also has international currency/exchange rates.
# used by updateDaylyStockwatch.py and Stock-fetchhtml-Stockwatch.py
StockPriceHistoryStockwatch = {
'TML202':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BIF*CDN®ion=C',
'MFC738':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=CUN*SSC®ion=C',
'BIP151':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BRN*GLO®ion=C',
'FID281':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FSB*CAA®ion=C',
'BNS744':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BNA*SAG®ion=C',
'BNS361':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BNS*MOR®ion=C',
'BNS741':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BNA*SIG®ion=C',
'BNS357':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BNS*MMF®ion=C',
'BMO146':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BOM*DIV®ion=C',
'BMO471':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BME*TFP®ion=C', # ...............................end of the mutual funds
'AI-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=AI®ion=C',
'ARX-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=ARX®ion=C',
'ABX-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=ABX®ion=C', # Barrick Gold
'AD-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=AD®ion=C',
'ALA-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=ALA®ion=C', # AltaGas Ltd
'APR-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=APR.UN®ion=C',
'AW-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=AW.UN®ion=C',
'AX-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=AX.UN®ion=C',
'BR-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BR®ion=C', # Big Rock on TSX
'BTB-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BTB.UN®ion=C', # Big Rock on TSX
'BNE-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BNE®ion=C',
'BPF-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=BPF.UN®ion=C', # Boston Pizza TSX
'CCO-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=CCO®ion=C', # cameco
'CHP-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=CHP.UN®ion=C', # choice REIT
'CRR-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=CRR.UN®ion=C', # cameco
'CNR-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=CNR®ion=C',
'CIQ-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=CIQ.UN®ion=C', # Canadian Hi Income TSX
'CJR-B-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=CJR.B®ion=C', # Corus
'CU-PR-F-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=CU.PR.F®ion=C', # Canadian Utility TSX
'DS-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=DS®ion=C', # Quadvest div select corp
'DR-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=DR®ion=C',
'EIT-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=EIT.UN®ion=C', # Canoe ETF
'EIF-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=EIF®ion=C', # Exchange Income Corp
'ENB-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=ENB®ion=C', # Enbridge
# 'ENF-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=ENF®ion=C', # Enbridge Fund was ENF.UN now ENB
'EXE-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=EXE.UN®ion=C', # Extendicare
'FC-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FC®ion=C', # Firm Capital Mortgage Investment Corp
'FCD-UN-X':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FCD.UN®ion=C', # Firm Capital Property Trust its on the venture exchange ?
'FFN-PR-A-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FFN.PR.A®ion=C',
'FFI-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FFI.UN®ion=C',
'FTN-PR-A-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FTN.PR.A®ion=C',
'FN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FN®ion=C',
'FIG-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FIG®ion=C',
'FTS-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FTS®ion=C',
'GDG-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=GDG.UN®ion=C',
'G-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=G®ion=C', # goldcorp
'GWO-PR-S-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=GWO.PR.S®ion=C', # Great West Life TSX
'HR-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=HR.UN®ion=C', # Hydro One
'H-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=H®ion=C', # Hydro One
'HHL-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=HHL®ion=C',
# 'IDR-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=IDR.UN®ion=C',
'IDR-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=IDR.UN®ion=C',
'IPL-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=IPL®ion=C',
'INC-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=INC.UN®ion=C',
'JE-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=JE®ion=C',
'K-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=K®ion=C', # Kinross
'KEG-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=KEG.UN®ion=C',
'KMB-N':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=KMB®ion=U', # Kimberly Clark on New York Exchange
'KWH-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=KWH.UN®ion=C',
'LFE-PR-B-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=LFE.PR.B®ion=C',
'MFR-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=MFR.UN®ion=C',
'MFT-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=MFT®ion=C',
'MHYB-NEO':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=MHYB®ion=C',
'MID-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=MID.UN®ion=C', # Mint Income TSX
'MUB-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=MUB®ion=C',
'MR-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=MR.UN®ion=C',
'MRT-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=MRT.UN®ion=C',
'MMP-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=MMP.UN®ion=C',
'NPF-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=NPF.UN®ion=C',
'NWH-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=NWH.UN®ion=C',
'PEY-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=PEY®ion=C',
'PCD-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=PCD.UN®ion=C',
'PGI-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=PGI.UN®ion=C',
'PKI-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=PKI®ion=C', # Parkland Fuel TSX
'PLZ-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=PLZ.UN®ion=C',
'PPL-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=PPL®ion=C',
'PR-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=PR®ion=C',
'PGF-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=PGF®ion=C',
'RBN-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=RBN.UN®ion=C', # Blue Ribbon TSX
'REI-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=REI.UN®ion=C',
# 'REF-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=REF.UN®ion=C', Canadian REIT now CHP.UN
'RIT-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=RIT®ion=C',
'SCW-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=SCW.UN®ion=C',
'SIN-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=SIN.UN®ion=C',
'SJR-B-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=SJR.B®ion=C',
'SKG-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=SKG.UN®ion=C',
'SPB-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=SPB®ion=C',
'S-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=S®ion=C', # Sherrit
'SRU-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=SRU.UN®ion=C',
'SRV-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=SRV.UN®ion=C',
'SSF-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=SSF.UN®ion=C',
'SU-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=SU®ion=C', # Sun core
'TECK-A-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=TECK.A®ion=C', # Teck
'T-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=T®ion=C', # Telus
'TNT-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=TNT.UN®ion=C', # Telus
'TF-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=TF®ion=C', #Timber creek Financial
'TA-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=TA®ion=C', # TransAlta
'UTE-UN-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=UTE.UN®ion=C',
'VET-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=VET®ion=C', # Vermillion
'VST-N':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=VST®ion=N', # Vista Energy
'WJA-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=WJA®ion=C', # West Jet
'ZWE-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=ZWE®ion=C',
'ZWU-T':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=ZWU®ion=C',
'AUD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$AUD/CAD®ion=U', # exchange rates start here ..only used as a filter to indicate which rate we're interested in
# 'BGN':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$BGN/CAD®ion=U',
# 'BMD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$BMD/CAD®ion=U',
# 'BRL':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$BRL/CAD®ion=U',
# 'BSD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$BSD/CAD®ion=U',
# 'CHF':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$CHF/CAD®ion=U',
# 'CLP':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$CLP/CAD®ion=U',
# 'CNH':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$CNH/CAD®ion=U',
# 'CRC':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$CRC/CAD®ion=U',
# 'DKK':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$DKK/CAD®ion=U',
# 'EGP':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$EGP/CAD®ion=U',
'EUR':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$EUR/CAD®ion=U',
# 'FJD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$FJD/CAD®ion=U',
'GBP':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$GBP/CAD®ion=U',
# 'HKD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$HKD/CAD®ion=U',
# 'IDR':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$IDR/CAD®ion=U',
# 'ILS':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$ILS/CAD®ion=U',
# 'INR':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$INR/CAD®ion=U',
# 'ISK':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$ISK/CAD®ion=U',
# 'JMD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$JMD/CAD®ion=U',
# 'JOD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$JOD/CAD®ion=U',
# 'JPY':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$JPY/CAD®ion=U',
# 'KPW':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$KPW/CAD®ion=U',
# 'KRW':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$KRW/CAD®ion=U',
# 'LBP':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$LBP/CAD®ion=U',
# 'MYR':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$MYR/CAD®ion=U',
# 'MXN':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$MXN/CAD®ion=U',
# 'NOK':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$NOK/CAD®ion=U',
# 'NZD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$NZD/CAD®ion=U',
# 'PHP':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$PHP/CAD®ion=U',
# 'PKR':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$PKR/CAD®ion=U',
# 'RON':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$RON/CAD®ion=U',
# 'SAR':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$SAR/CAD®ion=U',
# 'SDG':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$SDG/CAD®ion=U',
# 'SGD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$SGD/CAD®ion=U',
# 'SEK':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$SEK/CAD®ion=U',
# 'THB':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$THB/CAD®ion=U',
# 'TRY':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$TRY/CAD®ion=U',
# 'TTD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$TTD/CAD®ion=U',
# 'TWD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$TWD/CAD®ion=U',
'USD':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$USD/CAD®ion=U',
# 'VEF':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$VEF/CAD®ion=U',
# 'ZAR':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$ZAR/CAD®ion=U',
'ZMW':'https://www.stockwatch.com/Quote/Detail.aspx?symbol=FX$ZMW/CAD®ion=U'
}
# fetch Alphavantage historical prices using the API
# this table basily converts the Alphavantage Symbol to what is being used in moneydance.
# it also defines which symbols to fetch because we own them or are just interested in tracking them.
# used by stock-fetchhtmal-Alphavantage.py
# I don't use Alphavantage anymore ... was inconsistent on Canadian stocks and Canadian Mutual funds
StockPriceHistoryAlphavantage = {
'AD-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:AD&apikey=01833J9F7164BSUN&datatype=csv',
'ALA-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:ALA&apikey=01833J9F7164BSUN&datatype=csv',
'BR-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:BR&apikey=01833J9F7164BSUN&datatype=csv', # Big Rock on TSX
'PKI-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:PKI&apikey=01833J9F7164BSUN&datatype=csv', # Parkland Fuel TSX
'MID-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:MID-UN&apikey=01833J9F7164BSUN&datatype=csv', # Mint Income TSX
'GWO-PR-S-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:GWO-PS&apikey=01833J9F7164BSUN&datatype=csv', # Great West Life TSX
'CIQ-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:CIQ-UN&apikey=01833J9F7164BSUN&datatype=csv', # Canadian Hi Income TSX
'CU-PR-F-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:CU-PF&apikey=01833J9F7164BSUN&datatype=csv', # Canadian Utility TSX
'BPF-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:BPF-UN&apikey=01833J9F7164BSUN&datatype=csv', # Boston Pizza TSX
'RBN-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:RBN-UN&apikey=01833J9F7164BSUN&datatype=csv', # Blue Ribbon TSX
'KMB-N':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=NYSE:KMB&apikey=01833J9F7164BSUN&datatype=csv', # Kimberly Clark on New York Exchange
'BNE-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:BNE&apikey=01833J9F7164BSUN&datatype=csv',
'DR-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:DR&apikey=01833J9F7164BSUN&datatype=csv',
'EIT-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:EIT-UN&apikey=01833J9F7164BSUN&datatype=csv',
'FCD-UN-X':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=FCD-UN.V&apikey=01833J9F7164BSUN&datatype=csv', # its on the venture exchange ?
'FFI-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:FFI-UN&apikey=01833J9F7164BSUN&datatype=csv',
'FIG-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:FIG&apikey=01833J9F7164BSUN&datatype=csv',
'HHL-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:HHL&apikey=01833J9F7164BSUN&datatype=csv',
'IDR-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:IDR-UN&apikey=01833J9F7164BSUN&datatype=csv',
'INC-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:INC-UN&apikey=01833J9F7164BSUN&datatype=csv',
'JE-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:JE&apikey=01833J9F7164BSUN&datatype=csv',
'KWH-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:KWH-UN&apikey=01833J9F7164BSUN&datatype=csv',
'MFR-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:MFR-UN&apikey=01833J9F7164BSUN&datatype=csv',
'MFT-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:MFT&apikey=01833J9F7164BSUN&datatype=csv',
# 'MHYB-NEO':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:MHYB&apikey=01833J9F7164BSUN&datatype=csv', # trouble not on Alphavantage
'MID-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:MID-UN&apikey=01833J9F7164BSUN&datatype=csv',
'MUB-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:MUB&apikey=01833J9F7164BSUN&datatype=csv',
'PGI-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:PGI-UN&apikey=01833J9F7164BSUN&datatype=csv',
'UTE-UN-T':'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSX:UTE-UN&apikey=01833J9F7164BSUN&datatype=csv'
}
# used by Stock-fetchhtml-Bloomberg.py
# StockQuoteBloomberg = {
# 'Test-T':'https://www.aequitasneo.com/en/single-security/PKI',
# 'AD-T':'https://www.bloomberg.com/quote/AD:CN',
# 'ALA-T':'https://www.bloomberg.com/quote/ALA:CN',
# 'BR-T':'https://www.bloomberg.com/quote/BR:CN', # Big Rock on TSX
# 'PKI-T':'https://www.bloomberg.com/quote/PKI:CN', # Parkland Fuel TSX
# 'MID-UN-T':'https://www.bloomberg.com/quote/MID-U:CN', # Mint Income TSX
# 'GWO-PR-S-T':'https://www.bloomberg.com/quote/GWO-PS:CN', # Great West Life TSX .....Missing
# 'CIQ-UN-T':'https://www.bloomberg.com/quote/CIQ-U:CN', # Canadian Hi Income TSX
# 'CU-PR-F-T':'https://www.bloomberg.com/quote/CU-PF:CN', # Canadian Utility TSX ........Missing
# 'BPF-UN-T':'https://www.bloomberg.com/quote/BPF-U:CN', # Boston Pizza TSX
# 'RBN-UN-T':'https://www.bloomberg.com/quote/RBN-U:CN', # Blue Ribbon TSX
# 'KMB-N':'https://www.bloomberg.com/quote/KMB:US', # Kimberly Clark on New York Exchange
# 'BNE-T':'https://www.bloomberg.com/quote/BNE:CN',
# 'DR-T':'https://www.bloomberg.com/quote/DR:CN',
# 'EIT-UN-T':'https://www.bloomberg.com/quote/EIT-U:CN',
# 'FCD-UN-X':'https://www.bloomberg.com/quote/FCD-U:CN', # its on the venture exchange ?
# 'FFI-UN-T':'https://www.bloomberg.com/quote/FFI-U:CN',
# 'FIG-T':'https://www.bloomberg.com/quote/FIG:CN',
# 'HHL-T':'https://www.bloomberg.com/quote/HHL:CN',
# 'IDR-UN-T':'https://www.bloomberg.com/quote/IDR-U:CN',
# 'INC-UN-T':'https://www.bloomberg.com/quote/INC-U:CN',
# 'JE-T':'https://www.bloomberg.com/quote/JE:CN',
# 'KWH-UN-T':'https://www.bloomberg.com/quote/KWH-U:CN',
# 'MFR-UN-T':'https://www.bloomberg.com/quote/MFR-U:CN',
# 'MFT-T':'https://www.bloomberg.com/quote/MFT:CN',
# 'MHYB-NEO':'https://www.bloomberg.com/quote/MHYB:CN',
# 'MID-UN-T':'https://www.whatismybrowser.com/detect/what-http-headers-is-my-browser-sending', # header test
# 'MID-UN-T':'https://manytools.org/http-html-text/http-request-headers/', # header test
# 'MUB-T':'https://www.bloomberg.com/quote/MUB:CN',
# 'PGI-UN-T':'https://www.bloomberg.com/quote/PGI-U:CN',
# 'UTE-UN-T':'https://www.bloomberg.com/quote/UTE-U:CN'
#
# }