[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Access and TA



PureBytes Links

Trading Reference Links

Hi Jan Willem

Just what I was afraid of ..."SQL" and "Jet", enough to send shivers up any
coders back <G>

Here I was hoping for a nice gentle learning curve ... VBA for Access and
Access itself, then you want to throw me into the "deep-end of the pool".
<G>

Glad to hear from you, would love to hear more about the basics. My trading
situation is slightly different from most stock traders as I trade commodity
spreads. They're perfect for organizing in Access. Most of the yearly
spreads go back 30 years.

==============

To others that wrote re: the charting workbook:

Comment out the lines in the "ProtectSheets" sub in Module 4

Paste your data into "Calcs" sheet Col B to F
Set up different versions according to the amount of data that you want to
show or use sliders

or ... Install a new module in VBE i.e., "GetFile_Run"

Put in your "GetFile" subs ... for ASCII data and Excel files etc.

Use a "MainRunSubs" to call the following subs, etc.:

Function FindStartCell()
Sub RecalcOnly()

Add "Run" buttons where ever you like or you can run it from the VBE set up
as half screen.

The workbook runs rock steady without screeen flicker and saves without
difficulty.

I have multiple versions set up. One of the versions is set up for spreads
which doesn't use volume. Another version is set up for commodities. It
still needs to add have OI added to it. You will probably need other
variations put together for your situation.

The names and linked cells used by the Active X controls etc. are on the
"Parms" sheet. The text is yellow covered with yellow fill.

Best regards

Walter



----- Original Message -----
From: "J.W.E. Roberts" <jan.roberts@xxxxxxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Wednesday, September 27, 2000 11:16 AM
Subject: Re: Access and TA


| Hi Walter,
| Pain and suffering are the price we (still) have to pay for the eating of
| one single apple. Excercise: Calculate the compound interest.
| Re. X-cess2000 maybe another word to the wise: If you're seriously
| considering to build a database of equities you should program it in
"pure"
| SQL only (insofar as the beasty exists at all). Then, after you data have
| grown out of playground size (and they will), you'll be able to switch
| relatively painlessly (back to the "blood, sweat & tears" category again)
| to a real database engine from Access' Jet engine which cannot cope with
| other than playground size amounts of data.
| Kind regards & happy trading,
| Jan Willem
|
|
| At 12:35 26.09.2000 -0400, you wrote:
| >Hi Jan Willem
| >
| >Thanks for your reply
| >
| >Don't know what I'd do without lots of "pain and suffering" <G>
| >
| >Will check out Access 2000 or is it called X-cess 2000.
| >
| >Best regards
| >
| >Walter
| >
| >----- Original Message -----
| >From: "J.W.E. Roberts" <jan.roberts@xxxxxxxxxxxxxxxxx>
| >To: <metastock@xxxxxxxxxxxxx>
| >Sent: Tuesday, September 26, 2000 9:49 AM
| >Subject: Re: Access and TA
| >
| >
| >| Hi Walter,
| >| >I just got a copy of Access 97 (my first excursion into databases) and
| >would
| >| >be interested in hearing about how anyone uses it in their trading.
| >| >Hopefully the learning curve with Access and VBA for Access won't be
as
| >| >steep as the learning curve was for Excel and Excel VBA.
| >| I'd strongly recommend that you get a copy of Access2000! Access97 has
the
| >| old & kludgy interface; also its macro-language is not VBA. Access2000
is
| >| the 1st. Access that's been fully integrated in the Office (2000)
suite.
| >| Using A2k will save you a lot of pain & time.
| >| Kind regards & hyppy trading,
| >| Jan Willem
| >|
|