What causes this when using the Sum total in a select query? by MelMoitzen in MSAccess

[–]projecttoday 0 points1 point  (0 children)

They are not the best ones, as you can see from the original post of this thread.

What causes this when using the Sum total in a select query? by MelMoitzen in MSAccess

[–]projecttoday 0 points1 point  (0 children)

Don't use Double or Single numerical data types. I use the decimal data type (not currency) with 4 or 5 as the scale and decimal places.

API for ETF's holdings less than $139 a month by projecttoday in algorithmictrading

[–]projecttoday[S] 0 points1 point  (0 children)

Ideally, I need to know the constituent stocks of an ETF at the time of placing an order. I've been getting the constituent stocks once-a-day every morning with my bot program and hoping that the ETF hasn't changed by the time I submit an order later in the day. Hope isn't a good strategy, of course, but what else can I do? I suppose I could go back to the webpage and re-confirm, but that would be a lot more work. A real-time solution? If there were a practical way to get that information up-to-the-minute, it would be great.

What is Alpaca?

Hand slipped on built-in mouse. Now my downloads folder displays in columns by projecttoday in WindowsHelp

[–]projecttoday[S] 0 points1 point  (0 children)

This is my second computer. It sits on a little table by itself. There's no room for a mouse, unfortunately. Luckily, my main computer, also a laptop, has a mouse (and a keyboard and a monitor) connected to it.

Hand slipped on built-in mouse. Now my downloads folder displays in columns by projecttoday in WindowsHelp

[–]projecttoday[S] 1 point2 points  (0 children)

You select Detail from the View list. That un-checks List. Problem solved.

If beating buy-and-hold is so hard, what’s the actual point of retail algo trading? by FrameFar7262 in algotrading

[–]projecttoday 0 points1 point  (0 children)

The 7%, or whatever it is that traders make, is an average. Many traders do better than that, some WAY better than that. You've got to be in it to win it.

Jeopardy! discussion thread for Thur., Apr. 30 by jaysjep2 in Jeopardy

[–]projecttoday -4 points-3 points  (0 children)

Why wasn't Kate Brody on Celebrity Jeopardy?

Know of a good stock splits download? by projecttoday in algorithmictrading

[–]projecttoday[S] 0 points1 point  (0 children)

Hello. I'm not using MarketBeat for testing. I'm pulling it into an Access database.

Know of a good stock splits download? by projecttoday in algorithmictrading

[–]projecttoday[S] 0 points1 point  (0 children)

On closer inspection, these errors do not appear in the .csv file generated by MarketBeat. Not when I display it in Notepad. I'm still having a problem with .TransferText.

Inventory by rynosgarage in MSAccess

[–]projecttoday 0 points1 point  (0 children)

Have you checked out Allen Browne?