VBA to run analysis and select stock to add to watchlist

[fishmarket]

There are different status options as seen in your link

Status( "action" ) == actionExplore means that the code is only getting executed if clicking Explore button.

Great!


Yes, it's the watchlist number.




What does that mean practically? What do you need it for? Control AB from Excel for doing what?

Sometimes say at office I cannot use amibroker. I will use excel to control my amibroker at home and send me results of my analysis.

And I don't have live feed or data from yahoo as yahoo always produce wrong data, I use excel to get some more reliable source and need import to AB. I wanna automate this by excel itself, etc etc

 

[fishmarket]

Yes, but if I want to use excel as my control panel, then seems OLE is the only way to control AB...

I have some confused with the function "status(" xxxx")" what does it used for? return the status of the AB? or ask AB to run the NEW analysis?

ref: http://www.amibroker.com/guide/afl/status.html

thanks

Can I create a new watchlist instead of specifying the list as I want each day have a new watchlist for say 52week Hi stocks. Thanks

 

[trash]

Can I create a new watchlist instead of specifying the list as I want each day have a new watchlist for say 52week Hi stocks. Thanks

e.g. wlnumber = LastValue ( DayOfWeek() );

or wlnumber = LastValue ( DayOfYear() );

But there are only 64 watchlists