|
PureBytes Links
Trading Reference Links
|
As long as user input is not required (eg user inter-acting with the OS system via messages)
then there is no need to use VB, eg Excel's free VBA and the free ScriptIt(AutoIt) will do.
Concept steps for a "M > E"-program:
------------------------------------
1)From:
within the VBA script, call on one of these programs, eg to run batch xxxx, and than
when finished, to automatically return to the VBA-script(macro).
2)Plus:
Data can be directly Copied from the Mstk/DL programs and also directly Pasted into Excel,
(without having to convert to text-files first) using the Windows' Clipboard, eg use the ScriptIt or
AutoIt programs to automate that section of this "MetaStock > Excel-program" or
"Downloader > Excel-program" (eg you the user will only have to write the source code).
3)Then:
using VBA to crunch the data (further) in/into the Excel-environment, can be easely recorded
and naturally be macro'ed (eg the source code will than also automatically be written for you).
------------------------------------
And Voila !
The "M > E" or "D > E"-program is written, and this is at no extra cost(s), eg and not forget
to mention "at no extra -commercial program- charges".
Check out my homepage for the free AutoIt or free Microsoft ScriptIt automating programs,
programs best decsribed as the in-betweens, eg "have most of DOSbatch and lesser than VB"-
programs, best for performing any automating tasks/writing straight simple programs.
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying and
note the new address change. Also for my Homepage
http://home.planet.nl/~anthmaas
----- Original Message -----
From: <dllabarre@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: donderdag 18 november 1999 19:44
Subject: Re: Using VB to access Metastock data
>
>
> Walter, List
>
> Yes - VB meaning Visual Basic 6.0 NOT VBA
>
> If you're using a spreadsheet (Lotus, Microsoft) you can paste the data directly
> into the spreadsheet from MetaStock. Use the instructions below to get the data
> out of MetaStock, skip the part about "Open Microsoft Note Pad" and paste it
> into the spreadsheet directly.
>
> In Microsoft Excel you can import external data from a text .txt file. Data -
> Get external - Import text file
>
> There is an open file function in VBA. You can use this to open a text .txt.
> file into Excel. You cannot use it to read MetaStock files directly.
>
> MetaStock File Library (costs $) can be used to read MetaStock files directly
> into VB. I will be getting a copy to use with my VB program.
>
> There are, however, a work around using VB to read MetaStock files and
> converting them to .txt to be used in Excel. Once in Excel you can use VBA.
>
> Let me know if I can be of any help,
> Don
>
> Web developer
> Visual Basic programmer
> MetaStock programmer
> http://www.abbracadabra.com/cybercast
>
>
>
>
>
>
> "Walter Lake" <wlake@xxxxxxxxx> on 11/18/99 10:38:55 AM
>
> Please respond to metastock@xxxxxxxxxxxxx
>
> To: metastock@xxxxxxxxxxxxx
> cc: (bcc: Donald L. LaBarre)
> Subject: Re: Using VB to access Metastock data
>
>
>
--------------------------------------------------------------------------------
>
> Hi Don
>
> You are referring to VB in your post and NOT to VBA?
>
> Is there a comparable method / path for VBA?
>
> Best regards
>
> Walter
>
> ----- Original Message -----
> From: dllabarre@xxxxxxxxx
> To: metastock@xxxxxxxxxxxxx
> Sent: Thursday, November 18, 1999 9:13 AM
> Subject: RE: Using VB to access Metastock data
>
>
>
>
> Guy, Richard Bone and List
>
> I'm writing a VB program to test some formulas for Steve and there are a
> couple
> of ways to get data into VB. First get the data out of MetaStock and into a
> more usable format - open a chart in MetaStock, click on the graph line,
> right
> click on the graph line, click copy, open Microsoft Note Pad, click paste,
> or
> open a spreadsheet program and click paste, save file as .txt. VB can open
> and
> read the comma delimited text (.txt) file with no problems. You can also
> incorporate a spreadsheet into VB directly and paste the above data into
> this
> spreadsheet, then perform any calculations on the data.
>
> Contact me privately for more information or if you want to purchase a VB
> program to do this.
>
> Don
> Web developer
> Visual Basic programmer
> MetaStock programmer
> http://www.abbracadabra.com/cybercast
>
>
>
>
>
>
>
>
>
> "Guy Tann" <grt@xxxxxxxxxxxx> on 11/17/99 11:45:19 PM
>
> Please respond to metastock@xxxxxxxxxxxxx
>
> To: metastock@xxxxxxxxxxxxx
> cc: (bcc: Donald L. LaBarre)
> Subject: RE: Using VB to access Metastock data
>
>
>
>
>
>
>
> Richard
>
> As I understand it, there are two ways to access your Metastock data from
> VB. Equis offers two different libraries. They offer a read only DLL
> library for $99 (I think) and a more extensive MSFL which provides you with
> the ability to maintain the Metastock data as well. I don!,t remember the
> price, but its all on the Equis site.
>
> If there are other ways to do it, I!,d be interested in hearing about them
> as
> well.
>
> Regards,
>
> Guy
> Fax (630) 604-1589
>
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
> Behalf Of Richard Bone
> Sent: Wednesday, November 17, 1999 4:39 PM
> To: metastock@xxxxxxxxxxxxx
> Subject: Using VB to access Metastock data
>
> Hi all,
>
> I have followed a number of the threads regarding Visual Basic but I am
> still unclear whether it's possible to access the MetaStock files from
> Visual Basic? ... and if so how?
>
> I have seen that there is a read-only MDK but that is at extra cost ... at
> present price is unclear.
>
> Are there 'other' ways of doing it?
>
> I'd appreciate any help.
>
>
>
> Richard Bone
>
>
>
>
>
>
|