STT and Excel Issue

This topic is empty.

Viewing 15 posts - 1 through 15 (of 24 total)

1 2 →

Author

Posts
October 6, 2021 at 1:31 am #102175

JulianCohen
Participant

Has anyone had an update to Excel recently? My STT suddenly won’t run macros even if I set the Macro privacy settings to allow anything…..

Edit: I just checked my update history and I don’t have any Excel updates so something weird is happening

October 6, 2021 at 2:38 am #113942

KateMoloney
Participant

I’ve had no problems. Used it this morning and yesterday.

October 6, 2021 at 2:43 am #113946

JulianCohen
Participant

Thanks Kate…looks like some sort of Microsoft catastrophe of some sort. I managed to transfer the data across and all is almost OK….I’m digging around in my backups now

October 6, 2021 at 3:44 am #113947

Nick Radge
Keymaster

There was a Microsoft update in the last day or so. MIne working okay though.

October 6, 2021 at 10:06 am #113943

ChrisThong
Participant

Mine works fine too.

October 6, 2021 at 11:18 pm #113948

JulianCohen
Participant

Just one of those one off sporadic computer things I guess. Luckily I managed to find a back up that worked.

February 14, 2022 at 11:54 am #113949

JulianCohen
Participant

I just noticed that in the soldTrades tab of STT, some of my days held are negative numbers. I have an AUD STT and a seperate US STT and they both have this issue…

Anyone else notice this?

February 14, 2022 at 5:10 pm #114396

SaidBitar
Member

For me since last week it is not working anymore, I do not know if i installed anything that corrupted it.

February 14, 2022 at 9:35 pm #114397

Nick Radge
Keymaster

Send details to me and I’ll have it investigated.

April 20, 2022 at 6:40 am #113944

KateMoloney
Participant

Just to add to this thread;

I’ve had some issues with STT recently (files corrupting and failing). I was told to save the STT files to desktop and turn auto save OFF. It has helped somewhat. I copy the files to one drive once daily.

For the MOC strategy I use a new STT spreadsheet every month. Sometimes the STT corrupts itself mid month, so I grab a backup STT copy. For that reason, I keep the API data spreadsheets as backups.

April 20, 2022 at 6:40 am #113945

KateMoloney
Participant

Just to add to this thread;

I’ve had some issues with STT recently (files corrupting and failing). I was told to save the STT files to desktop and turn auto save OFF. It has helped somewhat. I copy the files to one drive once daily.

For the MOC strategy I use a new STT spreadsheet every month. Sometimes the STT corrupts itself mid month, so I grab a backup STT copy. For that reason, I keep the API data spreadsheets as backups.

April 20, 2022 at 7:56 am #114648

JulianCohen
Participant

yes I’ve had this issue for ages. Only with my US spreadsheet, not my Aud one. I have transferred all data to a new spreadsheet seven times in the last two years. Scott hasn’t found a cause for it and I haven’t taken it further. I feel like there is a transfer coming up in the near future as it has started to give me a few warning signs….like the red error screen of death every time I update the prices.

April 20, 2022 at 8:16 am #114651

Nick Radge
Keymaster

I’ve put in a support request to Scott.

Are either of you using iDrive or Google Drive?

April 20, 2022 at 8:58 am #114652

KateMoloney
Participant

I started using idrive about 2 weeks ago, but it only backs up Onedrive files one a day.

I’ve put in support requests with Scott a number of times on the crashing issue, even sent him corrupt files.
All he could offer was saving to desktop and turning auto save off.
STT crashes still happen (maybe every 7-10 trading days?) but its better than the 2-3x a week occurrence.

For example, yesterday I loaded up STT with 63 trades from MOC strategy. The upload took about 20 minutes. Spreadsheet operated fine. Was able to pull up individual strategy results, account balances etc no problems. Then this morning I open the spreadsheet and it opens then closes/crashes about 2 seconds later.

April 20, 2022 at 9:02 am #114656

KateMoloney
Participant

I keep the longer term strategies on a separate STT to try and eliminate the data on one spread sheet.

I’ve had the longer term strategy STT crash occasionally, but most of the issue is with the MOC strategy.
Author

Posts