Very Basic Stock Screening VBA Code -Essential for Stock Traders-

[Trader11]

Hello,

I need help on a VBA code -which I think is a very basic one.

I have cells that display, "BUY", "SELL" or "-" based on some conditions. I would like to create a VBA code so that a corresponding cell would show the date when the signals i.e. "BUY", "SELL" or "-" are triggered for the given cell. When the signal disappears (due to change in the linked condition) the date should disappear as well. As some might have guessed this is for Stock Screening hence I have some hundred rows.

Also I've saw threads that read, "copy this code and paste it to the screen where it says 'view code' and then it should run automatically", for example, but I'm struggling with that. Will I need to click on "Run" function? And how will I apply this code on the column I like.

Thank you so much in advance.

 

[Kishan]

Hi Trader11,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am very new in stock trade just I have started study about ibex35 from Invertia.com getting data in excel using this link http://www.invertia.com/mercados/bolsa/indices/historico.asp?idtel=IB011IBEX35<o></o>
<o></o>
Browsing excel question I found this topic interisting reading all post when I reach at post #24 find sample data and I copied in my excel (I am using Excel-2000) and tried to find link to get update TICKER-> NTHOL TI Equity from net and insert formula Formula under M (RSI 14D):
=BDP($A3,"RSI_14D")
Formula under P (DIFF MACD):
=BDP($A3,"MACD2")<o></o>
As you have describe. <o></o>
<o></o>
Now my question is to you which is the link to get data update automaticaly for all TICKER and how to get result with formula BDP. <o></o>
<o></o>
Thank you very much for your help in advance.<o></o>
<o></o>
Kishan<o></o>

 

[Trader11]

Hey Kishan, you need to be a Bloomberg Terminal user, to run those functions.

 

[Kishan]

Hi, Trader11,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
To be a user do I have to registered for it ? please tell me where I have to procced.<o></o>
<o></o>
Thanks<o></o>
Kishan<o></o>

 

[Trader11]

Kishan, you need to pay for it. Surf on the web.