You will get Excel stock analysis tool for the Pakistan Stock Exchange (PSX)
Project details
FOR WHOM THE TOOLS IS?
This Excel Tool is tailored for those who are interested in Pakistan Stock Exchange either for investment or study purposes.
WHAT T ACTUALLY THE TOO DO FOR YOU?
The Excel Tool extracts live data of stocks as it updates on Pakistan Stock Exchange, puts them into different sheets & table, analyze and categorize them into different categories and present you in a way that you can undertake right trade activity right time.
WHAT FUNDAMENTAL AND TECHNICAL DATA DOES IT PROVIDE?
The tool provides the following data:
Earnings Per Share (EPS) or Lose Per Share (LPS)
Price to Earn Ratio (PE Ratio
Support & Resistance (S1, S2, R1, R2)
Moving Average (MA) Calculator (1-Year, 6-months, 3-months, 1-month and 15-days moving averages).
Prices (LDCP, Open, High, Low, Current)
Volume (Current & 30 days’ average)
Market Cap
Free Float Shares
Top 10s (Gainers, Losers, Volume Leaders etc.)
Watchlist
Sector Watch
Index Watch
1-year performance and
Many more with metrics and color formatting so you can easily identify different categories.
WHY EXCEL?
The tool has been constructed in MS Excel because it is easy to use and easy to personalize.
This Excel Tool is tailored for those who are interested in Pakistan Stock Exchange either for investment or study purposes.
WHAT T ACTUALLY THE TOO DO FOR YOU?
The Excel Tool extracts live data of stocks as it updates on Pakistan Stock Exchange, puts them into different sheets & table, analyze and categorize them into different categories and present you in a way that you can undertake right trade activity right time.
WHAT FUNDAMENTAL AND TECHNICAL DATA DOES IT PROVIDE?
The tool provides the following data:
Earnings Per Share (EPS) or Lose Per Share (LPS)
Price to Earn Ratio (PE Ratio
Support & Resistance (S1, S2, R1, R2)
Moving Average (MA) Calculator (1-Year, 6-months, 3-months, 1-month and 15-days moving averages).
Prices (LDCP, Open, High, Low, Current)
Volume (Current & 30 days’ average)
Market Cap
Free Float Shares
Top 10s (Gainers, Losers, Volume Leaders etc.)
Watchlist
Sector Watch
Index Watch
1-year performance and
Many more with metrics and color formatting so you can easily identify different categories.
WHY EXCEL?
The tool has been constructed in MS Excel because it is easy to use and easy to personalize.
Data Tool
Microsoft ExcelWhat's included $30
These options are included with the project scope.
$30
- Delivery Time 1 day
- Number of Pages Mined/Scraped 40
- Number of Sources Mined/Scraped 2
- Number of Revisions 0
Optional add-ons
You can add these on the next page.
Additional Revision
+$5
1 review
(1)
(0)
(0)
(0)
(0)
This project doesn't have any reviews.
MV
Mihai V.
Aug 16, 2022
Convert PDF to Word
quick to respond and delivered quality work. thanks!
About Aftab
Data Analyst |Python | EDA | Statistical Modeling | MS Office
Chitral, Pakistan - 8:06 pm local time
I am a Google Certified Data Analyst with also having over 7 years of experience in Human Resources and Office Administration. I specialize in transforming complex data into actionable insights to help businesses optimize operations and improve decision-making.
Core Skills:
- Data Cleaning & Preparation
- Data Visualization (Excel, Tableau, Python)
- Exploratory Data Analysis (EDA)
- Predictive Modeling & Forecasting
- Statistical Analysis
- HR Data Analytics (Recruitment, Performance, Retention)
- Workflow Automation & Process Optimization
Services I Offer:
- Data Cleaning & Organization: Ensuring high data quality for accurate insights.
- Visualization & Dashboards: Creating clear and actionable reports using Excel and Tableau.
- Trend & Predictive Analysis: Identifying patterns and building models to forecast future outcomes.
- Automated Reporting: Streamlining data workflows and automating repetitive tasks for efficiency.
- HR Data Analytics: Optimizing recruitment, performance management, and retention strategies through data.
- Business Insights: Assisting leadership teams in leveraging data to reduce costs and drive growth.
I have a proven track record in both corporate and government sectors, consistently delivering data-driven solutions that enhance organizational performance. Let's collaborate to turn your data into a strategic asset!
Steps for completing your project
After purchasing the project, send requirements so Aftab can start the project.
Delivery time starts when Aftab receives requirements from you.
Aftab works on your project following the steps below.
Revisions may occur after the delivery date.
I will provide the the sheet