CV and Personal Experiences

Question 1

J.P. Morgan - analysed prospective clients using Financial Times and The Economist to gain industry and market insight

Answer 1

• Looked into the market environment and one story I found was a drop in Chinese bond yields and read that the China was issuing nearly $400bn worth of government bonds in late 2024
• This could have been problematic as it would have potentially meant that investors would invest into riskier assets to chase returns (bonds are a lot safer)
• Gov will have reduced the bond yield to 2.12% to stimulate economic activity e.g. reduce debt and encourage borrowing
• I know my knowledge is limited and that there is a lot more to be learnt as well as many other factors to consider, but I still found this project fascinating

Question 2

J.P. Morgan - conducted market analysis and developed a trade strategy for currencies based on statistical methods

Answer 2

• To try and link the case study I was looking at, I tried to establish a correlation between China’s bond yields and the potential impact on the Chinese Yuan
• Linear regression allowed me to quantify this relationship between bond yields and currency movements
• Found a relatively positive correlation between bond yields and the value of the currency
• Therefore if bond yields were expected to fall further, the strategy would involve shorting the Chinese Yuan

Question 3

Sports Centre - integrated excel skills to organise and register sports facility bookings to improve efficiency

Answer 3

• Mostly involved using built in features including tables to create a timetable
• Multiplied cells to calculate client costs

Question 4

Morrinson - understood applications of Excel and Python to streamline business operations and automate documentation

Answer 4

• VBA (extension of excel) was used to automate documentation when clients signed up because normally all data had to be manually transferred by putting it into a cloud
• Python used to automate email updates (scheduling when they were sent)

Question 5

Morrinson - understood importance of transparency and communication as a core principle to the industry

Answer 5

• Transparency ensures trust between clients and advisors
• Clear communication ensures clients fully understand their investments and they are up-to-date with any market changes

Question 6

Morrinson -the link between macroeconomics and finance - what was going on at the time in the economy

Answer 6

• Rachel Reeves became chancellor in July and was talking about filling the 22bn pound black hole, so there was concerns of capital gains tax increases
• What this could mean for FIC is a shift in investment strategies to products that provide a more steady income such as bonds

Question 7

How was scraping used in python to automate documentation?

Answer 7

• Involved sending HTTP requests to a webpage, retrieving its HTML content, and then parsing the relevant data