Range % imported in to Excel

[98lewisj]

I know this has been mentioned previously but is there any way to either import the Range % (from the over view screen) in to excel? If not is there a way to highlight runners in excel that are either at the top or bottom of there traded range? Im not the most excel savvy.

Thanks

[to75ne]

not sure why you would need to replicate what already exists in the overview screen but it can be done in excel using reiteration/circular references.

see this post as i cant be asked to type it out again on how to record the highest and lowest values reached in a cell (and how to reset the sheet)

viewtopic.php?f=19&t=7461&p=58626&hilit ... ons#p58626


substitue ltp price cell on betangel sheet1 k9,( k11, k13 and so on ), as the value you wish to record the highest and lowest prices reached for the appropiate one in the formulas in the example.

once you have done that the "percentage rangee" is found by
LTP - MINIMUM LTP / MAXIMUM LTP - MINIMUM LTP

the result of the above multiplied by 100


bear in mind that excel will have to be reset each time you change the market, and hence will only record highest/lowest LTP and % range from the moment you reset it, whereas the ba overview screen will record it from the moment its in guardian.

[98lewisj]

Thanks a lot, appreciate it.

[nigelk]

I try to avoid using vba as if things change or you need to alter something, its too arcane and cumbersome to adapt quickly

You must be hardcoding it?

[to75ne]

I try to avoid using vba as if things change or you need to alter something, its too arcane and cumbersome to adapt quickly

You must be hardcoding it?

dont know what is meant by hard coding (with regards to VBA specific to excel, word etc).

although i know a bit of vba, i prefer formulas.

formulas to me are a lot easier to understand and remember then the equivalant vba, which i find far too rigid - not easy to alter quickly as it usually requires a lot of thinking to even adapt vba to a slight change in requirements.

quite funny really with a name like VISUAL BASIC for applications; its nigh on impossible to visulise (for me).

ps i picked up quite a bit of vba either directly from you, or adapting your code and expanding on it so to speak Nigel.

its your fault i dont like it, you should have made it more interesting

pps your website is coming along nicely, good stuff hope it continues and goes well for you.