Search Results

< Back Dynamic View of Trading Hours: SIX Swiss Exchange V1 Dynamic View of the opening and closing hours of the SIX Swiss Stock exchange for 2024. Additionally, current summary of the market's activity is stated. Segmented Trading Hours of the SIX Swiss Exchange , as of 4th December 2023, as well as market holidays for 2024 have been incorporated in the basic web application below to display the current state of the SIX. Github: https://github.com/akweix/SIX_trading_hours Market Holidays Date Holiday Mon 01.01.2024 New Year's Day Tue 02.01.2024 Berchtholdstag Fri 29.03.2024 Good Friday Mon 01.04.2024 Easter Monday Wed 01.05.2024 Labour Day Thu 09.05.2024 Ascension Day Mon 20.05.2024 Whitmonday Thu 01.08.2024 National Day Tue 24.12.2024 Christmas Eve Wed 25.12.2024 Christmas Thu 26.12.2024 St. Stephen's Day Tue 31.12.2024 New Year's Eve The trading hours and segments of the SIX Swiss Exchange, as of 4th December 2023, are as follows: Start of Business Day : 06:00 CET Start of Clearing Day : 08:00 CET Opening of Various Segments : 08:30 CET: Bonds (CHF Swiss Confederation, CHF Swiss Pfandbriefe, Non-CHF) 09:00 CET: Blue Chip Shares, Mid-/Small-Cap Shares, Secondary Listing Shares, Sponsored Foreign Shares, Separate Trading Lines, Investment Funds, Exchange Traded Funds (ETFs), ETFs on Bonds of the Swiss Confederation, Exchange Traded Products (ETPs) 09:00 CET: Start of Trading for SwissAtMid, Swiss EBBO, Quote on Demand, ETF/ETP QOD Europe 09:15 CET: Sponsored Funds, Structured Products, Rights and Options 09:30 CET: Bonds (CHF) 15:00 CET: Sparks Shares, Global Depository Receipts End of Trading for Various Segments : 17:00 CET: Bonds (CHF Swiss Confederation, CHF Swiss Pfandbriefe, Non-CHF), ETFs on Bonds of the Swiss Confederation 17:15 CET: Structured Products, Rights and Options 17:20 CET: SwissAtMid, Swiss EBBO 17:30 CET: Quote on Demand, ETF/ETP QOD Europe Closing Auctions : 17:20 CET: Start for Blue Chip Shares, Mid-/Small-Cap Shares, Sparks Shares, Global Depository Receipts, Secondary Listing Shares, Sponsored Foreign Shares, Separate Trading Lines, Investment Funds 17:30 CET: Start for Sponsored Funds, ETFs, ETPs 17:30 CET: Run Auction and Close for Blue Chip Shares, Mid-/Small-Cap Shares, Sparks Shares, Global Depository Receipts, Secondary Listing Shares, Sponsored Foreign Shares, Separate Trading Lines, Investment Funds 17:35 CET: Run Auction and Close for Sponsored Funds, ETFs, ETPs Trading -At-Last : 17:30 CET: Start for Blue Chip Shares, Mid-/Small-Cap Shares, Sparks Shares, Global Depository Receipts, Investment Funds 17:40 CET: End for Blue Chip Shares, Mid-/Small-Cap Shares, Sparks Shares, Global Depository Receipts, Investment Funds End of Clearing Day : 18:15 CET End of Business Day : 22:00 CET Future Works: Identifying Market trends across market segments Identifying Market trends across trading days (seasonality) Previous Next

< Back Dynamic view of Ghana's Insurance Industry Work in progress Previous Next

< Back Web-Scrapper V1: Web Application Web Application for web-scrapping news articles Full code here on Python Anywhere Previous Next

< Back Financial Performance of Ghana's political regimes from 1960 - 2000 Analysis of Economic Growth in Ghana, 1960 – 2000 – ARYEETEY & FOSU "Economic Growth in Ghana, 1960 - 2000" by Ernest Aryeetey and Augustin Kwasi Fosu examines the fluctuating economic growth in Ghana over four decades, marked by frequent policy changes and military coups. The study highlights the transition of Ghana's economy and its impact on the livelihoods of its citizens. Period Key Factors Impact on Growth Post-Independence (1960-1965) Kwame Nkrumah implemented his 7-year Plan, emphasizing high investments into public infrastructure and industry creation. The economy grew rapidly due to the investments, but the high government spending led to inflation and a decline in living standards. Busia and the Military (1966-1971) Busia and the military regime ushered pro-private capital policies, devaluing the Ghanaian Cedi and liberalizing the external sector. The economy initially grew due to the pro-business policies, but the devaluation of the cedi caused inflation and public anger, leading to another coup d'état. The Era of Five Regimes (1972-1983) This period was marked by economic decline due to high government intervention policies, low productivity, and external shocks such as drought and food shortages. The economy contracted significantly during this period, with GDP growth averaging only 2.2% per year. Inflation soared to 112% in 1983, and the government deficit reached 17% of GDP. After the Economic Reforms (1984-2000) The government launched the Economy Recovery Program (ERP) under the World Bank and the IMF, which liberalized the economy and led to increased growth. The ERP helped to stabilize the economy and promote growth, with GDP growth averaging 5.3% per year during this period. Inflation fell from 112% in 1983 to 10% in 1992, and the government deficit was reduced to 4% of GDP. Previous Next

< Back Google News Scrapper Scrape Google News articles for a particulair keyword and date range You can use the google_news_scraper function by providing the keyword and date range as inputs. For example, google_news_scraper("oil prices", "2023-08-25", "2023-08-31") will fetch articles with the keyword "oil prices" published between August 25 and 31, 2023, and save it as a CSV file. # Install necessary packages !pip install selenium !apt-get update !apt install chromium-chromedriver import sys import pandas as pd from datetime import datetime, timedelta import re from selenium import webdriver from selenium.webdriver.chrome.options import Options from selenium.webdriver.common.by import By from selenium.webdriver.common.keys import Keys from bs4 import BeautifulSoup import time def convert_relative_date(text, current_datetime): current_year = current_datetime.year if 'hour' in text or 'hours' in text: return current_datetime.strftime('%Y-%m-%d') elif 'day' in text or 'days' in text: match = re.search(r'\d+', text) days_ago = int(match.group()) if match else 0 return (current_datetime - timedelta(days=days_ago)).strftime('%Y-%m-%d') elif 'minute' in text or 'minutes' in text: return current_datetime.strftime('%Y-%m-%d') elif 'yesterday' in text.lower(): return (current_datetime - timedelta(days=1)).strftime('%Y-%m-%d') else: try: parsed_date = datetime.strptime(text, '%b %d') return datetime(current_year, parsed_date.month, parsed_date.day).strftime('%Y-%m-%d') except ValueError: return text # Return the original text if parsing fails def google_news_scraper(keyword, start_date, end_date): # Convert start_date and end_date to datetime objects start_date = datetime.strptime(start_date, '%Y-%m-%d') end_date = datetime.strptime(end_date, '%Y-%m-%d') # Set up Chrome options for Selenium chrome_options = Options() chrome_options.add_argument('--headless') chrome_options.add_argument('--no-sandbox') chrome_options.add_argument('--disable-dev-shm-usage') sys.path.insert(0,'/usr/lib/chromium-browser/chromedriver') # Initialize the Chrome WebDriver with the specified options driver = webdriver.Chrome(options=chrome_options) # Fetch the Web Page query = '+'.join(keyword.split()) url = f'https://news.google.com/search?q={query}' driver.get(url) # Scroll the page to load more articles for _ in range(5): # Adjust the range for more or fewer scrolls driver.find_element(By.TAG_NAME, 'body').send_keys(Keys.END) time.sleep(2) # Wait for page to load # Get the page source and close the browser html = driver.page_source driver.quit() # Parse the Web Page using BeautifulSoup soup = BeautifulSoup(html, 'html.parser') articles = soup.find_all('article') # Extract the Necessary Information news_data = [] base_url = 'https://news.google.com' for article in articles: title_link_element = article.find('a', class_='JtKRv', href=True) title = title_link_element.text.strip() if title_link_element else "No Title" link = base_url + title_link_element['href'][1:] if title_link_element else "No Link" time_element = article.find('time') date = time_element.text.strip() if time_element else "No Date" news_data.append([title, link, date]) # Store the Data in a DataFrame df = pd.DataFrame(news_data, columns=['Title', 'Link', 'Date']) # Convert dates to a standardized format current_datetime = datetime.now() for i, row in df.iterrows(): if row['Date']: df.at[i, 'Date'] = convert_relative_date(row['Date'], current_datetime) # Filter the DataFrame by the provided date range def is_valid_date(date_str): try: return start_date <= datetime.strptime(date_str, '%Y-%m-%d') <= end_date except (TypeError, ValueError): return False filtered_df = df[df['Date'].apply(is_valid_date)] # Save the filtered DataFrame to CSV csv_file = f'google_news_filtered_{query}.csv' filtered_df.to_csv(csv_file, index=False) print(f"Filtered articles saved to {csv_file}") # Check if running in an environment that supports file download try: from google.colab import files files.download(csv_file) except ImportError: print(f"Download not supported in this environment. Please manually retrieve the file: {csv_file}") # Prompt user for input keyword = input("Enter the search keyword: ") start_date = input("Enter the start date (YYYY-MM-DD): ") end_date = input("Enter the end date (YYYY-MM-DD): ") # Call the function with user input google_news_scraper(keyword, start_date, end_date) Project Github repository: https://github.com/seanxjohn/google_news_scrapper/tree/main Previous Next

< Back Plain Vanilla Bond Price Calculator A web application that takes the arguments of FV, Coupon Rate, YTM and Periods to price a Plain Vanilla Bond Github: https://github.com/akweix/vanilla_bond_price_calculator Previous Next

< Back Sustainability Dimensions of Stocks on the SIX:Render 3 Quantitatively assessing Brundtland's Dimensions (1987). The case of the SIX View Plot here: https://www.akweidata.com/sixsustainabilitydimensions Previous Next

< Back ESG Strategies: Passive and Active Management Do the laws of passive and active strategies also affect sustainability investing? I recently concluded a sustainability data visualization project. The draft of the visualization is below Viewing the plot, I sought to understand the sustainability of stocks on the SIX. Parameters were used to identify sustainability in terms of ESG scores (70 and above) and Economic score (having an expected return above the market return). I developed four sustainable funds based on the ESG findings and market returns. Additionally I used ETHOS fund data found on Swiss Fund Data to develop the sustainable funds. The funds developed were: Negative Screening Best in Class Approach Thematic Approach ESG integration Against the staus quo, ESG integration was the only fund that was not "sustainable." Typcially ESG itegration is hailed as one of the most effective and practical strategies for promoting sustainability. Why is this the case? Unlike the first three strategies which are very basic to implement, when it came to the ESG integration fund, I randomly picked the ETHOS fund and duplicated the stock selectio - an in this case per the basic quantitaive metric developed, said fund was not . However, when I picked another ESG integrated fund its performace was sustainable. It appears that ESG integration has greater levels of subjectivity and the funds constructed across traders are likely to differ much greately than the previous 3 strategies. Thus, one can argue the element of the manager's skill in the active management of an ESG integrated fund plays a greater role in the fund's performance as compared to the other 3 strategies. Could this be the case of "passive" and active management of portfolios? Future works: Compare performace of ESG integrated funds Calculate the average return of ESG integrated funds vs "passive" strategies (Negative screening, Best In Class Approach ~ basic strategies) Do the variations of ESG integration strategies and basic sustainability stratigies vary across market types (Geographic and effeciency wise)? Previous Next

< Back Fixed Deposits Offers in Ghana A simple directory that shows Fixed Deposit offers in Ghana Github: https://github.com/seanxjohn/fixed_deposit_options_gh Future Works: Comparing and Assessing the Competitiveness of rates Assessing the Credit worthiness of firms Developing a dynamic risk-adjusted matrix of the offers Developing a Fixed Deposit calculator targeted to non- financially literate clients Develop a dynamic "Composite Fixed Deposit Instrument" based on current averages and interpolations Develop a dynamic yield curve (depicting expectations theory) based on the evolution of fixed deposit rates Previous Next

Projects Alternative Data Regressor Framework: Draft 1 A framework for linear regression of alternative data against financial asset prices View Alternative Data Regressor Framework: Flow Chart A framework for linear regression of alternative data against financial asset prices - the flow chart View Alternative Data Regressor: V1 A Python Program to attain a linear regression of some alternative data against financial asset prices . A CSV file is the input. The output is the regression results. View Beta of Fan Milk Ltd (FML): Ghana Stock Exchange (GSE) Finding the Beta of FML on the GSE using Python (Jupyter Notebook) View Cocoa Production: Ghana and Ivory Coast - 2022 Summary of Cocoa Production in Ghana and Ivory Coast in 2022. View Cocoa Production: Ghana and Ivory Coast - Historic Trend Work in progress View Cocoa Production: West Africa - 2022 Work in progress View Commentary: Brexit could lead to recession, says Bank of England An economic commentary on the article "Brexit could lead to recession, says Bank of England" View Commentary: Ghana fixes new cocoa price to control smuggling An economic commentary on the Article, "Ghana fixes new cocoa price to control smuggling" View Commentary: Washington’s Decision to “Normalize” Relations with Cuba..." An economic commentary on the article "Washington’s Decision to “Normalize” Relations with Cuba: Impede China’s Growing Influence in Latin America" View Convering Excel to CSV: Web Application A basic Web application written in HTML and Javascript to convert excel files to CSV. View Data Visualization of the Dynamic Efficiency of Oil and Gas Production in Ghana A comprehensive tool for understanding the Real-time Efficiency of Oil and Gas production in Ghana View Do Sustainable Funds in Switzerland outperform the Market? What is the performance of "sustainable" funds in relation to the market? Let's explore the case of the SIX Swiss Exchange View Dynamic Forestry and Agricultural Summary of ECOWAS states Work in progress View Dynamic View of Ghana's Unemployment Investigating the trend and segmentation of employment in Ghana View Dynamic View of Trading Hours: SIX Swiss Exchange V1 Dynamic View of the opening and closing hours of the SIX Swiss Stock exchange for 2024. Additionally, current summary of the market's activity is stated. View Dynamic view of Ghana's Forestry Work in progress View Dynamic view of Ghana's Insurance Industry Work in progress View ESG Strategies: Passive and Active Management Do the laws of passive and active strategies also affect sustainability investing? View Electricity Consumption as a proxy of production: Draft 1 Using publicly available data on Swiss Power Consumption, this exploration seeks to identify an association with power consumption and select firms output View Expected Loss Calculator A simple tool to calculate the Expected Loss for a credit portfolio. View Financial Performance of Ghana's political regimes from 1960 - 2000 Analysis of Economic Growth in Ghana, 1960 – 2000 – ARYEETEY & FOSU View Fixed Deposits Offers in Ghana A simple directory that shows Fixed Deposit offers in Ghana View Game Theory: Prisoner's Dilemma Strategies Tools Recreating and Simulating Robert Axelrod's 1980 Computer Tournament. View Ghana Stock Exchange: Real-Time Prices Web App V1 A basic web-application to find real time summaries of stocks on Ghana's Stock Exchange (GSE) View Google News Scrapper Scrape Google News articles for a particulair keyword and date range View Hedonic Valuation Model: Real Estate in Zurich With significant portions of banks portfolios consisting of mortgage loans, it is paramount to develop a strong model for valuating real estate. View Hollywood Boulevard to Wall Street: Futurism in Movies and Tech-Stock Prices This study investigates the relationship between the box office sales of futurism-themed movies and the performance of the tech stock index. View How Much Time Do I have left? Visualizing and Quantifying our most valuable asset: "Time" View How much time do I have left? - Version 2 Visualizing and Quantifying our most valuable asset: "Time"; Version 2 View Implementing design thinking for efficiency in Ghana's public sector This research paper introduces a remedy for Ghana's weak public sector by exploring the implementation of Design Thinking into the sector's practices. View Initial margin requirement for Derivative Trading A simplified VaR-based approach to calculate the initial margin requirement for Derivative Trading View Is ignorance truly bliss? Investigating the link between the lack of general information and the conception of the economy in Ghana. Project from 2018 View Manipulating File Paths: Backward to Foward Slashes A program made to convert backward slashes in file path names to foward slashes. Targeted for Windows users when copying paths to R or Pthon. View Paradox of Choice and Utility Maximization: Music Traditional Asset Pricing models are conceptually based on utility maximization. However, what about the role of the quantity of choices in utility maximization? View Photography Tool: Black & White Conversion A basic photo editor to convert PNG pictures from color to Black and White View Plain Vanilla Bond Price Calculator A web application that takes the arguments of FV, Coupon Rate, YTM and Periods to price a Plain Vanilla Bond View Prisoner's Dilemma: Player 2 Allowing users to participate in Robert Axelrod's 1980 Computer Tournament. View Proving the Butterfly Effect Within the context of metreology and physics, we can explore the butterfly effect View Scrapping Data using Python A Python application designed to generate a histogram depicting the frequency of articles published on Google News in 2022 concerning '@celebjets'. View Scrapping Oil related articles Run on python via GoogleCollab View Smartphone App for University Students An all-purpose app for Ashesi students. Project from 2017 View Snapshot Macroeconomic Summary of ECOWAS States: 2022 As at the end of 2022, this is was the macroeconomic status of each ECOWAS state View Sustainability Dimensions of Stocks on the SIX:Render 1 Quantitatively assessing Brundtland's Dimensions (1987). The case of the SIX View Sustainability Dimensions of Stocks on the SIX:Render 2 Quantitatively assessing Brundtland's Dimensions (1987). The case of the SIX View Sustainability Dimensions of Stocks on the SIX:Render 3 Quantitatively assessing Brundtland's Dimensions (1987). The case of the SIX View The Solow Model and Human Capital in Developing Economies How can human capital enrichment lead to long-run economic growth? View Value at Risk (VaR) for a portfolio Simple Tool using a historical simulation to find VaR View Web scrapping Box Office Sales A python code used to web scrape data from Box Office Mojo's Website. View Web-Scrapper V1: Web Application Web Application for web-scrapping news articles View frankenstein.io - Draft 1 Restructuring & Simplifying "Frankenstein codes" View