Greetings!

I am trying to work with a single column in the datatstore, I can view and display the contents, like this ->

q = test.all()
q.filter("adjclose =", "adjclose")
q = db.GqlQuery("SELECT * FROM test")

results = q.fetch(5)
for p in results:
    p1 = p.adjclose     
    print "The value is --> %f" % (p.adjclose)

however i need to calculate the historical values with the adjclose column, and I am not able to get over the errors

for c in range(len(p1)-1): TypeError: object of type 'float' has no len()

here is my code!

for c in range(len(p1)-1): p1.append(p1[c+1]-p1[c]/p1[c]) p2 = (p1[c+1]-p1[c]/p1[c]) print "the p1 value<--> %f" % (p2) print "dfd %f" %(p1)

new to python, any help will be greatly appreciated!

thanks in advance

Ray

HERE IS THE COMPLETE CODE

class CalHandler(webapp.RequestHandler):

def get(self): que = db.GqlQuery("SELECT * from test") user_list = que.fetch(limit=100)

doRender(
     self,
     'memberscreen2.htm',
     {'user_list': user_list} )


q = test.all()
q.filter("adjclose =", "adjclose")
q = db.GqlQuery("SELECT * FROM test")

results = q.fetch(5)
for p in results:
    p1 = p.adjclose     
    print "The value is --> %f" % (p.adjclose)
    for c in range(len(p1)-1):
        p1.append(p1[c+1]-p1[c]/p1[c])
        print "the p1 value<--> %f" % (p2)
        print "dfd %f" %(p1)