FilesExpand file tree

 master

/

31301.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

37 lines (27 loc) · 895 Bytes

 master

/

31301.py

Copy path

Top

File metadata and controls

• Code
• Blame

37 lines (27 loc) · 895 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

#! /usr/bin/env python

# coding = utf-8

import pandas

import pandas.io.data

import datetime

import urllib2

import csv

YAHOO = "http://download.finance.yahoo.com/d/quotes.csv?s=%s&f=sd1ohgl1vl1"

def get_quote_today(symbol):

response = urllib2.urlopen(YAHOO % symbol)

reader = csv.reader(response, delimiter=",", quotechar='"')

for row in reader:

if row[0] == symbol:

return row

def main():

symbol = "BABA"

history = pandas.io.data.DataReader(symbol, "yahoo", start="2014/11/11")

print history.tail(3)

today = datetime.date.today()

df = pandas.DataFrame( columns=["Open", "High", "Low", "Close", "Volume", "Adj Close"], dtype=float)

row = get_quote_today(symbol)

df.ix[0] = map(float, row[2:])

history = history.append(df)

print "today is %s" % today

print history.tail(2)

if __name__ == "__main__":

main()