SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : TA-Quotes Plus
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Sean W. Smith who wrote (7207)10/15/1998 10:02:00 PM
From: Roy Yorgensen  Read Replies (2) of 11149
 
Anyone who can help with Excel VBA for QP2

How do I modify the Macros Gary put in the Excel.zip files to limit the number of day to output?

This is the section of the code I thought would control it;

If Len(Symbol) = 0 Then
Call Done ' Nothing to do
Exit Sub
Else 'Try to load the data
' This function call sets raw mode to false and ignore Holidays to true.
NumDays = LoadSymbol(Symbol, Data(1), MAX_DAYS, 0, 1)
End If

I modified only one line to
NumDays = 260
and remarked out the original line.

What I got was approximately 130 days from the QPData buffer and the balance of 260 days was the oldest data from the DSKBUFF file. Leaving a BIG hole in the data.

Does not compute <g> literally.

Any help will be appreciated.
TIA
Roy
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News