VBA help (again)

This is a discussion on VBA help (again) within the Trading Software forums, part of the Commercial category; Attachment...

Reply
 
LinkBack Thread Tools Search this Thread
Old Nov 15, 2007, 6:31pm   #29
Joined Jun 2006
grantx started this thread Attachment
Attached Files
File Type: doc DB 3.doc (33.5 KB, 117 views)
grantx is offline   Reply With Quote
Old Nov 16, 2007, 9:08am   #30
 
A Dashing Blade's Avatar
Joined Jul 2004
So . . . to recap.

1) You get live data into your sheet when you bring in a chart.
2) We've established that when you used the Worksheet_Change event, you DID
see data changing in the status bar

As I understand it, your problem is that altho we can see data in the status bar, you can't get in onto a spreadsheet? Is this correct?

Can you describe what happens (or doesn't) ie any error messages etc?
A Dashing Blade is offline   Reply With Quote
Old Nov 23, 2007, 8:14am   #31
 
7 Posts
Joined Oct 2007
Hello Grantx.

Look for something like Dim BidSize or Dim AskSize. Under this copy and paste into your code
Dim Counterbid As Double
Dim CounterAsk As Double
Under the main block of code shown above copy and paste into your code
Counterbid = BidSize
CounterAsk = AskSize
For i = 2 To 10
If (.LimitVol(i, osBuy, 0, Data) <> NullValue) Then
Counterbid = Counterbid + .LimitVol(i, osBuy, 0, Data)
End If
If (.LimitVol(i, osSell, 0, Data) <> NullValue) Then
CounterAsk = CounterAsk + .LimitVol(i, osSell, 0, Data)
End If
Next i
ExcelDoc.Sheets(1).Cells(2, 19).Value = Counterbid
ExcelDoc.Sheets(1).Cells(2, 22).Value = CounterAsk

I hope this helps you.

Mikel.
JOSEBA is offline Software vendor   Reply With Quote
Old Nov 23, 2007, 8:30am   #32
 
Profitaker's Avatar
Joined Jan 2005
Forgot to mention this last time I swung past:-

http://www.excelforum.com/
__________________
Good judgment comes from experience. Experience comes from bad judgment.
Profitaker is offline   Reply With Quote
Old Nov 23, 2007, 3:45pm   #33
Joined Jun 2006
grantx started this thread Mikel,

Excellent. It works. Now I can clean up on Eurex. Watch out Flipper.

PT,

Thanks for the link. I actually started using this site last week (1 question) but it is a really good site.

Grant.
grantx is offline   Reply With Quote
Old Aug 14, 2008, 12:17pm   #34
 
1 Posts
Joined Dec 2007
Thaks

Thank you to all who put in a lot of hard work on my question I am sorry I could not reply
sooner as I have been slightly ill once again many thanks to all
jsteve1999
jsteve1999 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivots and VBA grantx Technical Analysis 7 Nov 1, 2007 10:40pm
VBA help needed grantx Technical Analysis 24 Oct 19, 2007 8:10pm
Excel VBA Developer job??? gurm Home Trader 7 Nov 30, 2005 9:29pm
any techies able to help Excel Vba V. III Techies Corner 3 Sep 19, 2003 9:51am

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)