MetaBrowser

jdm

Well-Known Member
#1
hi folks,

glad to share a simple excel macro i developed to automate some mundane jobs.

Why METABROWSER
After each trading day I generally look at how various stocks performed, one by one. Pressing the Alt. + Right Arrow or clicking on the Next button 1000 times is a tedious job. So I built METABROWSER to automate that process. Well thats set. No Holy Grails.

hope it will work smoothly for you as it did for me. documentation in the worksheet only.

any feedback in this thread only.

upgrade:
04.12.2006

fixed an issue with metastock. now no problem, whether metastock is running or not. if metastock is running the browsing will start of immediately, but if metastock is not running metabrowser will open metastock and then start the process.

fixed some bugs.

21.12.2006

Upgraded MetaBrowser to an application. The new version can be downloaded from:

http://www.geocities.com/metabrowser

The excel version stands discontinued.

cheers,
jdm.
 
Last edited:
#2
hi folks,

glad to share a simple excel macro i developed to automate some mundane jobs.

hope it will work smoothly for you as it did for me. documentation in the worksheet only.

any feedback in this thread only.

cheers,
jdm.
Hi Joy!

It's a good macro and I enjoyed watching the movie. :)

However, there are few areas which can be improved upon. Please look into the following matters if possible:-

1. The Dialogue Box where one needs to put the data path etc has black color and hence one could not see what is being typed. Can we either change the background color or font color automatically as soon as dialogue box appears?

2. The data path is not saved and one needs to type it afresh everytime the macro is started. Can this issue be fixed?

3. If the user moves to some other program, metastock macro stops working. So can the macro be resumed automatically when user moves back to metastcok?

4. During macro run, if I do click on the excel spreadsheet, the system hangs. The mouse pointer disappears from the screen and even "Alt+Tab" does not work. The only solution is to press "Atlt+Ctrl+Del". This problem is persisting even when metastock movie has stopped playing if any other window was opened. Can you please suggest why such a problem may occur?

Hope I am not bothering you much.

Best Regards,
--Ashish
 

jdm

Well-Known Member
#3
Hi Joy!

It's a good macro and I enjoyed watching the movie. :)
hi ashish,
thanks for trying metabrowser.

However, there are few areas which can be improved upon. Please look into the following matters if possible:-

1. The Dialogue Box where one needs to put the data path etc has black color and hence one could not see what is being typed. Can we either change the background color or font color automatically as soon as dialogue box appears?
couldn't get you. things work fine in my computer. no issues at all. any way now made the source code available so one can change the color according to his/her liking.

2. The data path is not saved and one needs to type it afresh everytime the macro is started. Can this issue be fixed?
as i said, i made the source code available. so one can edit the data path to his/her needs.

3. If the user moves to some other program, metastock macro stops working. So can the macro be resumed automatically when user moves back to metastcok?

4. During macro run, if I do click on the excel spreadsheet, the system hangs. The mouse pointer disappears from the screen and even "Alt+Tab" does not work. The only solution is to press "Atlt+Ctrl+Del". This problem is persisting even when metastock movie has stopped playing if any other window was opened. Can you please suggest why such a problem may occur?
well limitations of my coding skills and limitations of excel also (not sure). just press ESC key to end the macro. you really do not have to end the task by pressing Alt + Ctrl + Del.

basically i am showing you a movie at the theater only. so no option of pause, which you can get if you are watching the same on a DVD.

Hope I am not bothering you much.

Best Regards,
--Ashish
not at all. without any feedback the whole effort will be futile and without which no improvements can be done.

hope i could address the issues.

cheers,
jdm.