This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
The command I used looks like this: | |
youtube-dl --cookies library.utoronto.ca_cookies.txt https://stream.library.utoronto.ca:1935/MyMedia/play/mp4:1/f1d06b55a1909ed73463eddbecfa8095.mp4/chunklist_w159688705.m3u8 | |
1. You need to pip install youtube-dl im pretty sure | |
2. the last url is the .m3 file in network console (go to google chrome inspect element and then network tab to find the video url after you've clicked on the relevant video) | |
3. cookies can be downloaded from a chrome extension like this one: | |
https://chromewebstore.google.com/detail/get-cookiestxt-locally/cclelndahbckbenkjhflpdbgdldlbecc | |
You need to sign into quercus and then click on the extension to download them. In my case I have them as "library.utoronto.ca_cookies.txt" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1. Sign up for a Bybit account (use a referral link to maximize free money). Here’s mine: | |
https://www.bybit.com/en-US/invite?ref=QVAMK | |
This site was built using [GitHub Pages](https://pages.github.com/). | |
2. Enable 2FA so that you can get an API key | |
3. Get an API key, copy the key and secret, and store them in a safe place on your computer | |
4. Create an account at www.hashmycash.com | |
5. Message me your email once you have created your HMC account, and I will enable your account for bot trading | |
6. Once you have gotten confirmation from me that your account is enabled, sign into your HMC account, and click ‘Account’. | |
7. Scroll down to ‘Account API keys’, and select Bybit as your default exchange. Paste in your key and secret from step 3. Click update credentials if this is a live account, otherwise click ‘update test credentials’ if this is a simulated account with fake currency. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//Modify the parameters i and j to capture the range of your sheet. J indicates rows and i indicates columns | |
function appendString() { | |
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); | |
var map = {}; | |
for (var j = 1; j < 119; j++) | |
{ | |
for (var i = 1; i < 10; i++) |