Websites to Analyze Intrinsic value of a stock

Video Link --https://www.youtube.com/watch?v=TqVm4q_XzbM&t=42s

• Seeking Alpha (seekingalpha.com): Provides essential investment information, including stock movement data, company profiles, profitability metrics (gross profit and Avid margins) for financial health, and capital structure details. Kai emphasizes checking short interest, a "super super important" number, advising to generally avoid stocks with over 2% short interest as it indicates many are betting against the stock.
• Yahoo Finance (finance.yahoo.com): A "classic" and "powerful tool". Its graph features a strong comparison tool to trend multiple companies over time and show percentage changes. Kai highlights recent insider transactions as crucial, suggesting significant insider selling might signal a potential stock drop.
• Wallmine.com (wallmine.com): Consolidates most information onto a single page, which Kai finds convenient. It offers quick explanations when hovering over numbers, making it helpful for new investors. It also displays recent institutional transactions, which are powerful indicators given institutions' large holdings.
• TipRanks (tipranks.com): Features a proprietary "Smart Score" aggregating different sentiments and provides a clear visual of analyst forecasts. Kai notes its unique website traffic tool, which can indicate potential revenue growth, and often offers free features that are paid on other sites.
• Simply Wall Street (simplywall.st): Dissects stock analysis into categories like value, future, past, health, and dividend. It stands out by interpreting numbers for the user, highlighting positive (green) and negative (red) sentiments, and offers "super powerful and much cleaner" graphs.

Kai concludes by stressing the importance of cross-referencing information across these different platforms to ensure alignment and gain diverse perspectives, as analyst predictions and free features can vary. He also prefers visual graphs for easier trend identification. All these websites also provide mobile apps.

Chanage Data source in power Bi with Advance editor

Ref Video :  https://www.youtube.com/watch?v=Fd2tU-qull8

STEP-1- > Go to power query editor

STEP-2-> click on the table you want to change the data source

STEP-3 - > go to advance editor, copy the code in advance editor of the data source which needs to changed as data source

STEP-4 -> past this code in the table advance editor which you want to change

Schedule Python script using windows task Scheduler

 To run a Python program automatically using Windows Task Scheduler, follow these steps:

1. Create a Python Script:
   Ensure you have a Python script (.py file) that you want to run. For example, example.py.

2. Open Task Scheduler:

   • Press Win + R to open the Run dialog.
   • Type taskschd.msc and press Enter to open Task Scheduler.

3. Create a Basic Task:

   • In the Task Scheduler window, click on Create Basic Task in the Actions pane.
   • Enter a name and description for the task, then click Next.

4. Set the Trigger:

   • Choose when you want the task to start (e.g., Daily, Weekly, One time).
   • Set the specific details for the trigger (e.g., start date and time), then click Next.

5. Set the Action:

   • Select Start a program and click Next.

6. Specify the Program to Run:

• In the Program/script field, enter the path to the Python executable. For example, C:\Python39\python.exe (adjust the path according to your Python installation).
• Below is an example on how to find the path of python in command prompt
7. 
   
   
   
• In the Add arguments (optional) field, enter the path to your Python script. For example, C:\path\to\your\script\example.py.
• Optionally, in the Start in (optional) field, enter the directory where your script is located. This can help if your script relies on relative paths.
• Eg:
• Program/script: C:\Python39\python.exe
• Add arguments (optional): C:\Users\BKa\Desktop\Mail-Test.py
• Start in (optional): C:\Users\BKa\Desktop
• 
  
  
  

8. Finish the Task:

   • Review the settings and click Finish.

9. Optional Settings:

   • You can further customize the task by right-clicking on the task in the Task Scheduler Library and selecting Properties.
   • In the General tab, you can configure the task to run with highest privileges if needed.
   • In the Conditions and Settings tabs, you can adjust additional settings like stopping the task if it runs for too long, or running the task only if the computer is idle.

By following these steps, your Python script will run automatically according to the schedule you set in Windows Task Scheduler.

How To Calculate Intrinsic Value

Link to the Video-  https://www.youtube.com/watch?v=d0EBO-vs0GM

Websites for finding intrinsic Value of a stock

 https://www.alphaspread.com/intrinsic-value-calculator

https://in.tradingview.com/chart/l0PYylfY/

Sending Email from Python

 import smtplib, ssl

from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.utils import formatdate
from datetime import datetime

# Convert DataFrame to HTML
html_table = df_errormessage.to_html(index=False)

# Custom statement
custom_statement = "<p>Please find the below error data:</p>"

# Combine statement and HTML table
email_body = f"{custom_statement}<br>{html_table}"

# Get current date
current_date = datetime.now().strftime("%Y-%m-%d")

smail = 'do.not.reply@company.com'
tmail = ['123@company.com', '456@company.com']
sub = f'Error Report - {current_date}'

def send_mail(send_from, send_to, subject, text, isTls=True):
    msg = MIMEMultipart()
    msg['From'] = send_from
    msg['To'] = ','.join(send_to)
    msg['Date'] = formatdate(localtime=True)
    msg['Subject'] = subject

    # Attach the HTML table to the email body
    msg.attach(MIMEText(email_body, 'html'))

    smtp = smtplib.SMTP('outlook.company.com')
    if isTls:
        smtp.starttls()
    smtp.sendmail(send_from, send_to, msg.as_string())
    smtp.quit()

# Send the email if the condition is met
send_mail(smail, tmail, sub, text)
print(df_errormessage)