ok, i have a question,
how do i obtain a number from a history list and then use that number in excel?
For instance i have a bot that identifies the fav in a custom column on one click screen. How do i get that figure into excel?
History Lists
-
MemphisFlash
- Posts: 2162
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.
-
MemphisFlash
- Posts: 2162
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
Hi Dallas, merry christmas if i don't get to talk this side of the holidays.
Do you have an example i can get my head around.
Do you have an example i can get my head around.
-
MemphisFlash
- Posts: 2162
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
what does that do?
i like to understand formulae before i use it
that is not excel, that is the one click screen
i like to understand formulae before i use it
that is not excel, that is the one click screen
Paste this formula in Excel on your VWAP column:
=SMALL(IF($E$4:$E$24=0, "", $E$4:$E$24), ROWS($A$1:A1))
You can transfer four VWAP column in Excel in any order.. this formula will sort ascendant your values
If you want descendent swap SMALL with LARGE ..
=SMALL(IF($E$4:$E$24=0, "", $E$4:$E$24), ROWS($A$1:A1))
You can transfer four VWAP column in Excel in any order.. this formula will sort ascendant your values
If you want descendent swap SMALL with LARGE ..