help with a task.

[400396]

hi guys.

i have a task and hope you guys can help me.

i import data (stock price) with DDE to my excel spread sheet, the price streaming in one field and change like every second.

the data updated automatically i don't need to download or paste it.


i want in another field to analyzing the price and if the number increase to just to asign it with the number 1 and if the price was decrease to asign it with -1, can some think on a soulotion with excel for it?

thanks.

avi. <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[sheetspread]

=if(b2>a2,1,-1)

If zero is a possible result then we'd include a nested if or some extra math trick

 

[400396]

=if(b2>a2,1,-1)

If zero is a possible result then we'd include a nested if or some extra math trick

thanks, but the data is on a2 and is all the time goes up or down (live qoute) i have no data on b2 so i don't see the logic in =if(b2>a2,1,-1)

please advise.

 

[sheetspread]

I have a better idea now of what you're asking, but there's no Bloomberg terminal here for me to experiment (I am occasionally at one every month or so). Comparing dynamic data obviously requires a formula reference for each price, and that's much easier if they're between ends of days. You seem to want an intraday comparison, which may be possible, I have to see how discrete the last price and historical prices fields can get. Hopefully someone else can give you a quicker answer, but I'll try to learn more about this.