|
PureBytes Links
Trading Reference Links
|
Thanks Keith -- just what I needed.
----- Original Message -----
From: Keith McCombs
To: amibroker@xxxxxxxxxxxxxxx
Sent: Friday, June 02, 2006 2:57 PM
Subject: Re: [amibroker] Match date from numeric date in Excel?
In Excel, assume your date is in cell F5 {in Date format}. Then equation for AFL format is:
=(YEAR(F5)-1900)*10000 + MONTH(F5)*100 + DAY(F5) {in General format}
-- Keith
cstrader232 wrote:
I want to match a numeric date variable from an Excel file to a numeric date
value that AFL understands.
(has to be numeric to work in a loop)
My options in Excel seem to be:
Number of days since January 1, 1900
"julian" date in yyyy, num days since 1/1 format:
e.g. 2006153
But can either of these be matched to datetime()?
I don't want to have to use 3 separate numeric variables: M D Y
TIA
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
SPONSORED LINKS Investment management software Real estate investment software Investment property software
Software support Real estate investment analysis software Investment software
------------------------------------------------------------------------------
YAHOO! GROUPS LINKS
a.. Visit your group "amibroker" on the web.
b.. To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------------------------------------------------------------
|