Find Jobs
Hire Freelancers

Full Time & Sales Data Analyzer

$8-15 CAD / hour

Probíhající
Zveřejněno skoro před 6 roky

$8-15 CAD / hour

This project is large in scope and will be separated into sections. This project has already been awarded to a freelancer who has demonstrated he can complete the project in its entirety. Part 1: Create the base script that will properly identify the correct raw data master file, filter through trade data, remove duplicates and delete previous files, for usage in the main macro. Part 2: Once all up-to-date trade data has been imported, a Net House Summary module will need to be created. This Summary must be fully flexible and fast. The user should be able to change date ranges and quickly receive all correctly calculated information. All trades must be calculated in order of date, from oldest to newest. In addition to the standard Net House Summary that is to be calculated, I would like to add these functions immediately: 1) Line graph of cumulative net house positions during selected time frame 2) A column in net house summary that calculates the percentage of trades going through the parent exchange vs the alternate exchanges (dark pools). I need to detect when the dark pools become active and receive a spike in activity. Therefore, all dark pools should be aggregated and measured against the volume being transacted through the parent exchanges that are listed as CNX, TSX, TSX-V. The relative % should be graphically displayed alongside the share price for a visual representation. 3) Each house will have a running cumulative net position from the net house summary. These will have been graphically displayed. This next step is to track major changes for each house. We need to have "alerts" for 1) New House Buyer (When a house makes its first buys) 2) New House Seller (When a house makes its first sales) 3) Accumulation Buyer (Logic is TBD ) 4) Distribution Seller (Logic is TBD) Logic will be something like tracking during what 2 week period (this should be adjustable, 1 day, 4 day, 10 day, etc) they had the highest frequency of buying and selling. 4) Separate all trades where price increases, then Count the House Buyers and determine who is pushing price up. Separate all trades where price decreases, then Count the House Seller and determine who is pushing price down. Make sure these are adjustable based on custom Begin Date and End Date. 5) Based on the cumulative house positions, calculate a matrix for correlations. Create a list for the top 3 highest positive correlations and top 3 highest negative correlations. This helps us determine if there is any potential algo trading/MMing or potential manipulation occurring. 6) Determine if MMs are active. Logic: If Delta neutral and Frequency of trades on the bid and ask are large and similar. Part 3: Include importation of shortdata file. Complete combination analysis to flag the trades that must equal the short data number. Example: during recent 2 week period, short volume activity was 550,000. Therefore, Create all possible combinations of trades that equal exactly 550,000. Record which combination required the least amount of trades to equal 550,000. Then, separate these trades and COUNT and SUM the house positions to determine who is shorting, when and why. More scope can/will be added in time and milestone achievements are available.
IČ projektu: 16764330

O projektu

9 nabídky
Vzdálený projekt
Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
Thank You, as I've mentioned, I will be able to start working on the project tomorrow and keep You updated, ask questions when I need anything. If it's possible I would be grateful for editing project tags, so that "Visual Basic for Apps" and "Excel VBA" are mentioned, as it helps me build the profile focused on this service. Best Regards
$13 CAD v 40 dnech
5,0 (65 recenze)
5,3
5,3
9 freelanceři nabízejí v průměru $21 CAD/hodinu za tuto práci
Avatar uživatele
Hello, I have the good knowledge of Full Time & Sales Data Analyzer . I have more than 5 years of experience in Data Analytics, Excel, Excel VBA, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$15 CAD v 40 dnech
4,9 (559 recenze)
8,4
8,4
Avatar uživatele
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
$30 CAD v 20 dnech
5,0 (340 recenze)
7,5
7,5
Avatar uživatele
Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, WEKA, TABLEAU and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$50 CAD v 40 dnech
5,0 (17 recenze)
5,5
5,5
Avatar uživatele
Hello. I have read your post seriously letter by letter. I think this is very nice chance for me to show off my excellent ability in original programs as you wanted in your post. I have plenty of experience in this field so am very confidence about your project. Original programs such as C++ are very efficient for your huge project. I am so glad to have chance to meet a long term partner to help each other on business. I believe my skill in C,Excell C# so on. I hope you would reply and can discuss about you project in detail. If you want a team for your project I can introduce my team. Best regards
$12 CAD v 40 dnech
5,0 (1 recenze)
2,1
2,1
Avatar uživatele
A proposal has not yet been provided
$8 CAD v 40 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi, I have came across this project, and after understanding the work involved in this and quality of work you prefer I have made a bid to it. please feel free revert me. regards Savyasachi
$16 CAD v 28 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z CANADA
Etobicoke, Canada
0,0
0
Ověřená platební metoda
Členem od dub 11, 2018

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.