avatarDr Mehmet Yildiz

Free AI web copilot to create summaries, insights and extended knowledge, download it at here

1238

Abstract

me Python code to retrieve Tesla stock prices from 2022 using Yahoo Finance. I want the output to be in a csv file called ‘stock_prices.csv’ The CSV file mys have a column named “Date” representing the dates and a column named “Price” representing the stock prices.”</p><p id="e110">And then the output will be:</p><figure id="f70f"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*4cgK5TnDtjHmV_MaFnGNCw.png"><figcaption></figcaption></figure><h1 id="df02">Step 2: Copy this code using the botton “copy code” at the top right</h1><h1 id="f854">Step 3: Paste the code in Google Colab</h1><p id="38fa">Navigate to <a href="https://colab.research.google.com/">https://colab.research.google.com/</a> . The create a new notebook by logging in using your Google account.</p><p id="0eee">This is the full code I got from Chat GPT.</p><p id="77be">But remember, you can customise the prompt to get any other stock.</p><div id="eeb1"><pre><span class="hljs-keyword">import</span> yfinance <span class="hljs-keyword">as</span> yf <span class="hljs-keyword">import</span> pandas <span class="hljs-keyword">as</span> pd

<span class="hljs-comment"># Define the stock symbol and the time range for which you want the data</span> sym

Options

bol = <span class="hljs-string">"TSLA"</span> start_date = <span class="hljs-string">"2022-01-01"</span> end_date = <span class="hljs-string">"2022-12-31"</span>

<span class="hljs-comment"># Fetch the stock data using Yahoo Finance</span> stock_data = yf.download(symbol, start=start_date, end=end_date)

<span class="hljs-comment"># Extract the 'Date' and 'Close' columns from the stock data</span> stock_data = stock_data[[<span class="hljs-string">'Close'</span>]].reset_index()

<span class="hljs-comment"># Rename the columns to 'Date' and 'Price'</span> stock_data.columns = [<span class="hljs-string">'Date'</span>, <span class="hljs-string">'Price'</span>]

<span class="hljs-comment"># Save the stock data to a CSV file</span> stock_data.to_csv(<span class="hljs-string">'stock_prices.csv'</span>, index=<span class="hljs-literal">False</span>)

<span class="hljs-built_in">print</span>(<span class="hljs-string">"Stock data saved to 'stock_prices.csv'"</span>)</pre></div><h1 id="dbca">Step 4: Use the CSV file with the stock data</h1><p id="db5f">As simple as that!</p><figure id="4c88"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/0*lpNgMNRzr3oNIaAX.png"><figcaption></figcaption></figure></article></body>

#Fiance #Business #Technology

Here’s How I Do Technical Solution Cost Planning at a High Level.

A methodical approach and practical guide to Business Architects in digital transformation initiatives

Image by Gerd Altmann from Pixabay

In this article, based on my experience, my aim is to provide high-level architectural guidance for solution cost planning to business architects responsible for the earlier phases of digital transformation initiatives. Business architects are capable of creating fundamental relationships and play critical roles by being a bridge between business and technical stakeholders.

Solution cost planning is one of the highest focus areas of digital transformation programs. Business stakeholders pay tremendous attention to solution cost as an investment hence they want to understand the return on their investment from the very beginning. They also expect the business architects to manage overall solution cost at least in the macro level design stage and provide costing guidance for the micro level designs.

The problem is the technical team members have little awareness and understanding of cost implications in these programs, as cost planning and management are not their forte. Only a few exceptional technical architects or specialists may have some cost awareness and understanding. Therefore, business architects are expected to fill an important solution cost planning and management gap for the feasibility of these complex programs.

Ironically, the traditional position descriptions that I reviewed don’t even mention the cost awareness requirements for business architects however, in reality, there is an expectation once they are assigned to the lead roles in these programs.

Therefore, while redefining the new roles and responsibilities of business architects in one of my recent publications, I created this stakeholder expectation and the actual requirement in the field. I elaborate on the key points in this article.

My experience reveals that as business architects leading and focusing on the successful progress of a digital transformation program, we must follow a proven methodical approach to manage the cost and contribute to the business solution viability and profitability.

Both a top-down and bottom-up approach must be applied depending on the needs. At the top tier, we see the business and IT processes, and at the bottom tier, we see IT infrastructure.

These two critical domains can independently be transformed using parallel activities. However, an integrated approach is essential as there can always be dependencies from multiple angles in both top-down and bottom-up approaches.

As business architects, we are not subject matter experts, and it is not possible to cover all domains. Therefore, we must closely work with multiple domain architects, solution architects, and infrastructure architects across the program.

In addition, we are expected to gather solution details and even specifications from subject matter experts to create an order of magnitude cost for a digital transformation initiative. This initial cost is critical for the senior executives to make a go or no go decision for the initiatives.

How can we deal with solution costs after initial approval?

Once a business organization has an approved transformation strategy, then we can refine the strategy and convert it to clear architectural and technical formats.

The strategy document is a critical artifact in bringing all parties and stakeholders on the same page. Then we can identify the critical dependencies among these domains based on the short-term, midterm, and long-term considerations.

By using the strategy and considering the dependencies, we can develop a high-level roadmap to inform the sponsoring executives. This roadmap can indicate the key outcomes, timelines, and a ballpark cost for the overall modernization and transformation activities. These indications initially can be at a very high level as there may be many factors affecting timelines, resources, and other associated cost items.

After setting the transformation roadmap, we need to make a comprehensive viability assessment considering the current state of the scoped initiatives, their indicative future state, and the strategies to reach the end state.

This viability assessment must include key risks, constraints, and dependencies. The viability assessment can be the most informative tool a lead business architect can provide to the sponsoring executives of the digital transformation program for them to make informed decisions for solution feasibility leading to successful business outcomes.

After review and approval of the viability assessment by the governing stakeholders, we delve into collecting the high-level requirements of the initiative based on the included domains.

These domains can be exhaustive and complex. Some key domains we may need to consider are business IT processes, business data, business applications, IT infrastructure, and IT service delivery. These domains can even be more complicated in global business organizations with the addition of geographical factors, such as adding multiple countries to the equation.

As dealing with the requirements of those domains can be daunting, we can delegate the requirements collection process to the domain, program, and solution architects, technical specialists, and business analysts based on their skill set relevant to the types of requirements. I provided guidance on the critical technical roles in the attached article.

In this phase, the role of the business architect is to coordinate and facilitate the requirements management team, which can consist of multiple solution architects, technical specialists, and business analysts.

After requirements are collected and analyzed at a reasonable amount, the next important activity is to prioritize the requirements based on business impact. We need to develop criteria to prioritize the requirements based on factors depicted in the strategy and business roadmap documents, as well as the financial and business priorities set by the sponsoring executives.

There are many more cost considerations that we need to cover. However, I want to emphasize the service level agreements (SLAs) as one of the fundamental cost factors in these programs. Let me briefly explain.

Service downtime costs can be very high based on agreed rates and cause excessive penalties when accumulated for service-level breaches by service-providing business organizations. Service Level breaches can also have a strategic adverse effect on an organization’s products, services, and overall business performance.

Downtime in business services or defects in products can result in poor client satisfaction. If we also look at from the consumers’ perspectives, they lose business due to service downtime. It is a lose-lose scenario even though the consumer organizations are compensated with SLA penalties paid by the service providers.

As business architects, we need to pay attention to the SLAs from the nascent stages of the solution lifecycle, starting from the business architecture framework phase. More information on the business architecture framework can be obtained from the attached article.

The higher the quality of the architectural guiding principles, the easier it can be for SLAs to meet when the digital transformation solutions are in production and the operational state. The rigor for quality in each phase can positively contribute to deal with SLA risks.

We can take some architectural measures and provide guidance. For example, we can advise the solution architects that some of the key considerations to address SLA issues could be autonomous condition monitoring and remote maintenance for the devices or systems in remote locations.

For example, sending a technician to a remote location may take several hours of travel. However, fixing those units can be done remotely in minutes. One simple yet powerful example in my projects that we applied was rebooting servers remotely. This simple task saved us a considerable amount of time and money. It also helped us prevent SLA penalties associated with the services.

There are specialist solutions regarding these trending techniques. It can be useful to recommend and assign automation and standardization specialists for the design of these unique features in our programs.

Service level costs are crucial for business organizations. Let’s put this into a practical perspective. One of the biggest fears of the business executives is the adverse impact of poor performance and availability problems damaging their client satisfaction and compromising business revenues in their transformed products and services.

To address the business risks associated with this valid business concern, as business architects, we need to pay special attention to SLA strategy, planning, design, and implementation in an integrated way in our overall business architecture framework. Proactive and effective SLA management is one of the key areas where the digital and financial intelligence of business architects make real differences in cost planning and management.

Conclusions

Following a methodical, transparent, and pragmatic approach, we can be on top of risks and issues affecting cost hence we can contribute to the productive control of cost at the architectural level.

Sponsoring executives’ highest expectations from business architects are to help reduce cost and increase the financial viability of the digital transformation initiative.

To achieve this business goal and make our sponsors happy, we need to introduce a new way of thinking in the form of continuous and collaborative innovation. To understand the importance and the leadership approach to innovation, I shared my experience in the following articles.

To learn more about architecting and designing digital transformation solutions, you may check the following comprehensive article.

As business architects, we are crucial leaders in digital transformation programs. For more information on the expected and required characteristics of technical leaders in digital transformation programs, you might review the attached article.

In my next articles, I plan to provide guidance on creating effective and innovative solution cost models with an accompanying bill of materials for digital transformation initiatives.

Related Articles

The Significance of Quantum Computing for the Future of Artificial Intelligence

Business Architecture Framework for Digital Transformation

On the Cusp of the Artificial Intelligence Revolution — Chapter 1

Business Value and Architectural Overview of Robotics Process Automation

Why Digital Intelligence Matters: Key benefits for individuals, business organizations, the economy, and society

The World Needs Passionate & Compassionate Leaders

Do You Want to Become A Sexy Entrepreneur?

Business Collection: A Mini MBA Bundle

Top Stories About Artificial Intelligence

Top AI Stories on Technology Hits

How Storytellers Articulate Cryptocurrencies and Blockchain

NFT Story Collection on ILLUMINATION Integrated Publications

Cognitive Transformation

A Bizarre And Hilarious Story Likely Caused By Artificial Intelligence

How To Deal With Big Data For AI?

Digital Scent Technology And AI Machines Can Smell Now. So What!

Learning AI, Cognitive, Data Science, Programming, & Cloud Computing

Architecting Data Lake Solutions

Digital Transformation Handbook for Solution Architects

Ethical Hacking

Power of Design Thinking for Writers

How Tim Denning Helped Me Connect with Satoshi Nakatomi

Sample Health Improvement Articles for New Readers

Defeat Fatty Liver Disease with Three Doable Tips

Lower the Risks of Heart Disease and Strokes in Five Steps

Defeat Metabolic Syndrome and Slim Down Waistline with Three Tips

Why 442 Million People Live Diabetic and What We Can Do About it

Reduce Liver Cancer Risks with Healthy Lifestyle Choices

Make Your Lungs Healthier via Lifestyle Approaches

Make Your Pancreas Healthier via Lifestyle Choices

Make Your Kidneys Healthier via Lifestyle Choices

Make Your Brain Healthier with Ten Lifestyle Approaches

Six Tips to Prevent Brain Atrophy and Lower the Risks of Mental Disorders

What Can We Do About NCDs Killing 41 Million People Yearly?.

Five Tips to Prevent Infectious Diseases.

Three Tips to Improve Cardiovascular Health.

Three Lifestyle Habits to Lower Dementia Risks

Reduce the Risks of Neonatal Disorders to Prevent Infant Mortality.

Reduce the Risks of Major Diseases with Healthy Lifestyle Habits

I also write about valuable nutrients. Here are the links for easy access:

Boron, Urolithin, taurine, citrulline malate, biotin, lithium orotate, alpha-lipoic acid, n-acetyl-cysteine, acetyl-l-carnitine, CoQ10, NADH, TMG, creatine, choline, digestive enzymes, magnesium, hydrolyzed collagen, nootropics, pure nicotine, activated charcoal, Vitamin B12, Vitamin B1, Vitamin D, Vitamin K2, Omega-3 Fatty Acids, and other nutrients that might help to improve metabolism and mental health.

About the Author

I am a technologist, postdoctoral researcher, author of several books, editor, and digital marketing strategist with four decades of industry experience.

I write articles on Medium, NewsBreak, and Vocal Media. On Medium, I established ILLUMINATION, ILLUMINATION-Curated, ILLUMINATION’ S MIRROR, ILLUMINATION Book Chapters, Technology Hits, SYNERGY, and Readers Hope publications supporting 15,500+ writers on Medium. You can join my publications requesting access here. You may subscribe to my account to be notified when I post on Medium.

If you are new to Medium, you may join by following this link.

I publish my lifestyle, health, and well-being stories on EUPHORIA. I wrote several articles on major diseases and valuable nutrients for health. My focus is on metabolic, cellular, mitochondrial, and mental health. Here is my collection of Insightful Life Lessons from Personal Stories.

You might join my seven publications on Medium as a writer by sending a request via this link.

You might find more information about my professional background.

I write about health as it matters. I believe health is all about homeostasis.

Business
Leadership
Technology
Entrepreneurship
Science
Recommended from ReadMedium