adhocshare Blog

0

Public datasets

Source: https://github.com/caesar0301/awesome-public-datasets Awesome Public Datasets This list of public data sources are collected and tidied from blogs, answers, and user responses. Most of the data sets listed below are free, however, some are not. Other amazingly awesome lists can be found...

0

Indicators cheat sheet

Source: http://www.tradeciety.com/the-ultimate-indicator-cheatsheet/   Related posts: Swing trading resources Indicator Bullshit: Do You Really Think All of the Indicators Will Help You Win? Installing zipline module in pycharm? Stock Indicators, Patterns and Strategies

0

Maintaining database of price file using R

Source: http://www.thertrader.com/2015/12/13/maintaining-a-database-of-price-files-in-r/ Steps Prepare a list of securities (onetime) Setup initial data file (onetime) Update data files (periodic)   1. Prepare a list of securities One time setup. If changed on demand then will have to call initial data setup. File: /Users/rdebnath/robin/ticker_data/r-input/listOfInstruments.R...

0

Swing trading resources

Scan resources Chart resources Indicators Strategies Analysis with R Bullish in last 7 days 6 SIMPLE WAYS TO SCAN FOR SWING TRADING OPPORTUNITIES Swing Trading Stock Screener. How to Scan for Winning Stocks TAZ Traders action zone How to Use...

0

Analyzing top gainer loser data

Housekeeping with mysql Downloading data from wsj using python script here Concatenating daily files # Below command concatenates files and skips the first row of each file $ tail -q -n +2 *.tsv > /tmp/stock_aggr.tsv Creating table in mysql drop...

0

WSJ Top Loser Gainer pull

Below code will pull losers and gainers from wsj.com for a given date range, #!/usr/bin/env python from lxml import html import requests import sys import os import humanize import pandas # from datetime import date, timedelta import datetime import re...

0

Parsing sqoop logs for stats analysis

Below python code will help you extract statistics from a set of Sqoop log files for transfer analysis,   #!/usr/bin/env python import fnmatch import os import datetime def find_files(directory, pattern): for root, dirs, files in os.walk(directory): for basename in files: if...

0

Handy bash commands

Top 20 files by size Concatenate multiple files skipping n rows Compress last X days data in one archive Compress files older than X days individually Merging multiple lines Find latest files recursively Get rows starting and ending between a...

0

Hive datatype mappings

Hive meaning Teradata meaning .net BCL Type TINYINT 1-byte signed integer, from -128 to 127 ByteInt Represents a 8-bit (1-byte) signed integer. Range: -128 to 127 System.Int16 SMALLINT  2-byte signed integer, from -32,768 to 32,767  SmallInt Represents a 16-bit (2-Byte) signed integer. Range: -32,768 to 32,767...

0

Starting AMPPS without password on MAC

The below method will not start AMMPS without password, but instead does start mysql and apache web server if you have AMPPS installed already. There are 2 steps involved, 1. Modifying sudoers file, and 2. Creating a startup applescript application....