Es: -1.8% at 1975.50
10yr: +2.8% at 2.186
Vx: +8.9% at 21.15
Cl: -4% at 34.51
Earnings: MON
Other News: Most names are dropping here, few popping; Oil is getting pasted again, only .30 away from new 52wk lows. Oil related names are being taken down with it;
GAINERS:
MBLY: +6% at 38.32, 347k, b/a 0.01 - presenting at CES conf. today
TASR: +4.1% at 17.72, 47k, b/a 0.10 - upgraded this AM
LOSERS:
MNKD: -9.2% at 0.68, 527k, b/a 0.01 - ripped by analysts after yesterday's implosion
PXD: -7.8% at 115.41, 665k, b/a 0.06 - 10.5m share 2ndary offering at 117
CEMP: -7% at 26.70, 5k, b/a 0.68 - $175m 2ndary offering
VRX: - 3.2% at 97.65, 485k, b/a 0.05 - CEO out for med reasons
WDAY: -2.9% at 75.00, 1.3k, b/a 0.85 - downgraded
TT Vol Watch:
PXD (options have always been too illiquid) VRX
TT Track of the Day: Lacuna Coil "Swamped". I can't believe this track is almost 14 years old, ugh.
any tips on where to check out the coding that goes into that?
ReplyDeleteYes! Here's what I found super helpful:
DeleteThis youtube video for Yahoo Finance into excel, editing of Yahoo URL works the same for Google Sheets:
https://www.youtube.com/watch?v=EoeIn-3jbhI
Then These two websites:
https://www.quora.com/How-do-you-import-fundamental-stock-data-from-Yahoo-into-Google-Sheets
http://www.marketindex.com.au/yahoo-finance-api
When editing the URL, I found my errors were usually because I was either missing a quote or an ampersand "&&"
thanks a bunch! but how do you pull in extended hours data?
ReplyDeleteI use the TDAmeritrade Thinkorswim platform. I have my watchlists sorted by bid/ask/mark/mark% change/volume. Using those data points allow symbols to be sorted by pre-mkt moves.
Delete