Ask Python Expert

I am new to Phython. Using Spyder IDE Simple code. It is not recognizing by Data file see line 33.

I/O error TSX_Listing.cvs not found

# -*- coding: utf-8 -*-
"""

Assignment 1 Sample code: Python code for grabbing data from Yahoo!Finance

Note: This code guides you to grab Canadian stock returns data from Yahoo!Finance.

The purpose of this assignment is to get you familiar with the Python. Enjoy!

Reference: http://pandas.pydata.org/pandas-docs/stable/remote_data.html
Source file https://github.com/pydata/pandas/blob/master/pandas/io/data.py
"""

# Load packages
import pandas.io.data as web
import datetime
import pandas as pd
import os
import numpy as np
import statsmodels.formula.api as sm

#create your current working directory of the located .py file
directory = 'C:\\Users\\maryannp\\Documents\\Phython Scripts\\Assignment#1'

#Choose your starting and ending time
start = datetime.datetime(2014, 1, 1) #(YYYY, m, d)
end = datetime.datetime(2014, 12, 31)

#Load the csv file with the TSX Tickers, this code assume that the ticker files
#located in the same folder as the directory
tickers = pd.read_csv(directory + '\\' + 'TSX_Listing.csv')
tickers = list(tickers['YAHOO_TICKER'])

#Intiate the dictionnary that will store all the downloaded tick data
d = pd.DataFrame()

# Options for web.DataReader function:
"""
input 1: ticker in string form - Ex: OSPTX is for the S&P/TSX
input 2: the source (ex: 'yahoo' or 'google') to download the data from
input 3: start time in datatime.datetime format
input 4: end time in datatime.datetime format
"""
#Loop over each tickers to load the data to be stored in the dictionnary d
for tick in tickers:
f = web.DataReader(tick, 'yahoo', start, end)
d[tick] = f['Adj Close'] # select the adjusted close price

# how to calculate simple returns
ret=d.pct_change()
#Example on how to compute the log returns for all the stocks in d
d_lret = np.log(d) - np.log(d.shift())

#export the return data to csv file
d_lret.to_csv ('C:\\Users\\maryannp\\Documents\\Phyton Scripts\\Assignment#1\\TSX_data2014.csv')

Attachment:- TSX_Listing.csv

Python, Programming

  • Category:- Python
  • Reference No.:- M91411874
  • Price:- $40

Priced at Now at $40, Verified Solution

Have any Question?


Related Questions in Python

Part i the assignment filesone of the most important

Part I: The Assignment Files One of the most important outcomes of this assignment is that you understand the importance of testing. This assignment will follow an iterative development cycle. That means you will write a ...

Homework -this homework will have both a short written and

Homework - This homework will have, both a short written and coding assignment. The problems that are supposed to be written are clearly marked. 1) (Written) Make heuristics Describe two heuristics for the slide problem ...

Tasksdemonstrate data scraping of a social network of

Tasks Demonstrate data scraping of a social network of choice. Develop technical documentation, including the development of the code & detailing the results. Provide a report on the findings, that includes research into ...

Assignment1 utilising python 3 build the following

Assignment 1. Utilising Python 3 Build the following regression models: - Decision Tree - Gradient Boosted Tree - Linear regression 2. Select a dataset (other than the example dataset given in section 3) and apply the De ...

Python programming assignment -you first need an abstract

Python Programming Assignment - You first need an abstract base class, called, Account which has the following attributes and methods: accountID: This attribute holds the ID assigned the account , if not provided set to ...

Learning outcomes lo3 - research develop and document a

Learning Outcomes LO3 - Research, develop, and document a basic security policy, and analyse, record, and resolve all security incidents LO4 - Identify and assess the threats to, and vulnerabilities of networks Assessmen ...

Question research pythons dictionary data type dictdiscuss

Question : Research Python's dictionary data type (dict). Discuss its interface and usage. Include examples. Discuss practical applications of dictionaries.

Questionwhat is a python development frameworkgive 3

Question What is a python development framework? Give 3 examples python development framework used today. and explain which development framework is used in which industry.

Below zero - ice cream storethe local ice-cream store needs

Below Zero - ice cream store The local ice-cream store needs a new ordering system to improve customer service by streamlining the ordering process. The manager of the store has found that many orders are incorrect and s ...

The second task in this assignment is to create a python

The second task in this assignment is to create a Python program called pancakes.py that will determine the final order of a stack of pancakes after a series of flips.(PYTHON 3) Problem Task In this problem, your input w ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As