Here just i had written django script to calculate in my data MarketUpdate in my django model Here i am passing two custom fields 'ticker' and 'test_start_date'(datetime format) this script is finely working while executing in django shell It displays error after calling as a method "stock_up()"
from optionsAlpha.models import MarketUpdate from datetime import datetime from django.db.models import Q def stock_up(ticker, test_start_date): #stock_value=0 mu1 = MarketUpdate.objects.filter(Q(stock_symbol=ticker) & Q(update_timestamp__gt=datetime(test_start_date))).order_by('stock_value') #print mu1[0].stock_value max_stock=mu1[0].stock_value count=0 for i in mu1: if i.stock_value >= max_stock: max_stock = i.stock_value count+=1 return count Output when calling this method from django shell: >>> dat datetime.datetime(2011, 3, 19, 8, 58, 28, 999615) >>> ticker 'GOOG' >>> stock_up(ticker,dat) Traceback (most recent call last): File "<console>", line 1, in <module> File "/home/hirelex/optionsalpha/optionsAlpha/trade_count.py", line 6, in stock_up mu1 = MarketUpdate.objects.filter(Q(stock_symbol=ticker) & Q(update_timestamp__gt=datetime(test_start_date))).order_by('stock_value') TypeError: an integer is required >>> Here Stock_value is another field (float) in my model. just i need to order it what is the meaning of this error? How to resolve it? could you suggest it -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.